[mythtv-users] mysql update on remote frontend broke MythTV

Mark Knecht markknecht at gmail.com
Wed Oct 26 15:37:05 EDT 2005


Hi,
  I've been reading a number of things about this latest mysql update
and wanted to take it slow. On one of my Gentoo frontend boxes I gave
it a go this morning. Bad results so far.

On the frontend where I did the update and am having trouble I now have:

* dev-db/mysql
     Available versions:  !3.23.58-r1 4.0.22 4.0.22-r2 4.0.24
4.0.25-r2 ~4.0.26 ~4.1.13-r1 ~4.1.14 ~5.0.12_beta ~5.0.13_rc
     Installed:           4.1.14
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server

On the backend, whch hasn't been touched, and is working with the
other machines in the house, I have:

* dev-db/mysql
     Available versions:  [M]3.23.58-r1 [M]4.0.22 [M]4.0.22-r2
[M]4.0.24 [M]4.0.25-r2 [M]4.0.26 [M]4.1.13-r1 [M]4.1.14 [M]5.0.12_beta
     Installed:           4.0.25-r2
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server

   On the machine that's having trouble, when I run mythfrontend I
just get the page saying it couldn't contact the server and starts off
asking me about language, which server, etc. If I run mythfrontend in
a terminal I see this:

mark at lightning ~ $ mythfrontend
QSqlDatabase: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
2005-10-26 12:18:05.257 New DB connection, total: 1
2005-10-26 12:18:05.259 Unable to connect to database!
2005-10-26 12:18:05.259 No error type from QSqlError?  Strange...
2005-10-26 12:18:05.259 Unable to connect to database!
2005-10-26 12:18:05.260 No error type from QSqlError?  Strange...
2005-10-26 12:18:05.260 Database not open while trying to load
setting: GuiVidMo deResolution
2005-10-26 12:18:05.260 Unable to connect to database!
<SNIP>
2005-10-26 12:18:06.022 No error type from QSqlError?  Strange...
2005-10-26 12:18:06.022 Unable to connect to database!
2005-10-26 12:18:06.037 No error type from QSqlError?  Strange...
2005-10-26 12:18:06.037 Database not open while trying to load setting: Language

   So apparently it's not communicating with the server.

   etc-update did do a bunch of edits to /etc/mysql/my.cnf, which
seems like a prime target for creating a problem like this, but I've
looked through it and nothing of immense interest (to me) seems as if
it got changed. There's lots of new stuff added though.

   So, has anyone else run into something like this yet?

   If this is a Gentoo specific thing then I'll take the question over
there but I'm sure there are great MySQL folks here so I thought I'd
ask.

Thanks,
Mark


More information about the mythtv-users mailing list