On Mon, May 14, 2007 at 07:59:52PM -0700, Mark Knecht wrote: > Hi, > I'm in the early stages of a complete MythTV update across my > network. I have the backend nearly working in an IA32 machine. It runs > fine but isn't getting all the channels correctly yet. In parallel > with that effort I'm trying to get the frontend working again on my > AMD64 machine. > > However when I try to start the frontend it complains like this: > > [EMAIL PROTECTED] ~ $ mythfrontend --geometry 800x600 > 2007-05-14 19:56:19.577 Using runtime prefix = /usr > 2007-05-14 19:56:19.585 DPMS is active. > QSqlDatabase: QMYSQL3 driver not loaded > QSqlDatabase: available drivers: > 2007-05-14 19:56:19.595 New DB connection, total: 1 > 2007-05-14 19:56:19.595 Unable to connect to database! > 2007-05-14 19:56:19.596 No error type from QSqlError? Strange... > QSqlQuery::exec: database not open > QSqlQuery::exec: database not open > 2007-05-14 19:56:19.646 DB Error (KickDatabase): > Query was: > SELECT NULL; > No error type from QSqlError? Strange... > > First, I believe MythTV still required QT3. The QT package is slotted, so you should be able to have both 3 and 4 installed. If you upgraded MySQL on the AMD64 box, you may want to rebuild QT3 with something like emerge -av =dev-libs/qt3*
If that doesn't fix it, it sounds like it could be a password encryption problem. I had a similar problem when I tried using a RHEL box as a front end. The RHEL distribution only supported MySQL 4.0.x and my back end DB is MySQL 5.x. I could connect fine from the command line, but the front end could not. After a bit of research I determined it was a password encryption problem. I decided the easiest solution for me was to create a second account for the mythconverg DB and encrypt the password using the old_password function. You can also upgrade the client to 5.x. If it's already at 5.x you may need to re-encrypt the password for the account. You may want to look at http://dev.mysql.com/doc/refman/5.0/en/old-client.html and try some of the suggestions. Hope this helps. Brett -- [EMAIL PROTECTED] mailing list
