<span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Hi,<br><br>After upgrading to <span style="background-color:rgb(255, 255, 204);background-repeat:initial initial">mythtv</span> 0.22, mythfrontend has trouble connecting to the database. The logs show that the errors always start occurring after the third DB connection is setup. mythbackend has no troubles connecting to the database, and I've checked /usr/share/mysql/charsets/Index.xml file and latin1 is listed as a valid character set. Any pointers as to how to fix this problem?<br>
<br>Here is the relevant part of the mythfrontend logs...<br><br>2010-02-27 17:00:08.441 TV: Changing from None to Watching WatchingPreRecorded2010-02-27 17:00:08.441 New DB connection, total: 3<br>^GCharacter set 'latin1' is not a compiled character set and is not specified in<br>
the '/usr/share/mysql/charsets/Index.xml' file<br>2010-02-27 17:00:08.442 Realtime priority would require SUID as root.2010-02-27 17:00:08.442 Unable to connect to database!<br>2010-02-27 17:00:08.442 Driver error was [1/2019]:QMYSQL: Unable to connect<br>
Database error was:<br>Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)<br><br>QSqlQuery::exec: database not open<br>^GCharacter set 'latin1' is not a compiled character set and is not specified in<br>
the '/usr/share/mysql/charsets/Index.xml' file<br>QSqlQuery::exec: database not open<br>2010-02-27 17:00:08.493 No error type from QSqlError? Strange...2010-02-27 17:00:08.543 Database not open while trying to load setting: UseVideo<br>
Timebase<br>2010-02-27 17:00:08.546 Video timing method: USleep with busy wait<br>^GCharacter set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file<br>
2010-02-27 17:00:11.547 Unable to connect to database!<br>2010-02-27 17:00:11.547 Driver error was [1/2019]:<br>QMYSQL: Unable to connect<br>Database error was:<br>Can't initialize character set latin1 (path: /usr/share/mysql/charsets/)<br>
<br>QSqlQuery::exec: database not open<br>^GCharacter set 'latin1' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file<br>QSqlQuery::exec: database not open<br>
2010-02-27 17:00:11.598 No error type from QSqlError? Strange...<br></span>