[mythtv-users] Linux frontend database connection problems

[Mark Frasa]

Hello,

While you installed myth frontend on the new machine.

Are you sure that the passwords match?
You can check the mysql info in:

/etc/mythtv/mysql.txt


Cheers,
Mark


On Tue, 2007-08-14 at 09:11 +0100, Piers Kittel wrote:
>                              From: 
> Piers Kittel <mailing at biased.org>
>                          Reply-To: 
> Discussion about mythtv
> <mythtv-users at mythtv.org>
>                                To: 
> Discussion about mythtv
> <mythtv-users at mythtv.org>
>                           Subject: 
> [mythtv-users] Linux frontend
> database connection problems
>                              Date: 
> Tue, 14 Aug 2007 09:11:05 +0100
> (10:11 CEST)
> 
> 
> Hello all,
> 
> My current setup is:
> 
> Debian Etch backend
> Mac Mini frontend running OS X
> PowerMac frontend running OS X
> Diskless frontend running Debian Etch
> Linux laptop running Debian Etch
> Spare box running Knoppmyth
> 
> all running 0.20 downloaded from wwwmythtv.org's download page.  The  
> OS X packages were obtained from the snider pad.
> 
> My problem is all of the Linux frontends, the OS X frontends works  
> fine.  I upgraded the server from Sarge to Etch without any problems  
> and the OS X frontends worked fine.  The diskless frontend that was  
> running Debian Sarge failed to work after the server upgrade, I  
> suspected a version mismatch between the SQL driver between the  
> backend and the frontend.  I decided to upgrade the diskless
> frontend  
> to Debian Etch, and after a lot of problems, have gotten it to a  
> working state, but MythTV fails to connect to the server.  On  
> starting, it spews a lot of "QSqlQuery::exec: database not open"  
> errors and then show the setup wizard, which already has the correct
> values in - I compared it with the OS X frontends, they all match up  
> exactly, and then I complete the wizard, it then exits with a final  
> "QSqlQuery::exec: database not open".  So I installed MythTV on my  
> laptop, exactly the same problem.  I decided to try Knoppmyth, it  
> didn't work either.
> 
> What am I doing wrong, and how do I fix it?
> 
> Here's a snippet of the output from the diskless frontend:
> 
> 2007-08-12 12:16:17.277 Using runtime prefix = /usr/local
> 2007-08-12 12:16:17.309 DPMS is active.
> 2007-08-12 12:16:17.319 New DB connection, total: 1
> 2007-08-12 12:16:17.320 Unable to connect to database!
> 2007-08-12 12:16:17.320 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:17.378 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:17.433 Unable to connect to database!
> 2007-08-12 12:16:17.434 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:17.488 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:17.544 Database not open while trying to load
> setting: GuiVidModeResolution
> 2007-08-12 12:16:17.545 Unable to connect to database!
> 2007-08-12 12:16:17.545 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:17.600 DB Error (KickDatabase):
> 
> <snip>
> 
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:30.024 Database not open while trying to load
> setting: Language
> 2007-08-12 12:16:30.028 Unable to connect to database!
> 2007-08-12 12:16:30.028 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:30.084 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:30.140 Database not open while trying to save
> setting: Language
> 2007-08-12 12:16:30.143 Unable to connect to database!
> 2007-08-12 12:16:30.144 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:30.200 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:32.342 Unable to connect to database!
> 2007-08-12 12:16:32.343 No error type from QSqlError?  Strange...
> 2007-08-12 12:16:32.396 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-12 12:16:32.452 Failed to init MythContext, exiting.
> 
> Nothing comes up in the backend's logs, not even if I use  
> "mythbackend -v all" which indicates to me that the frontend has  
> problems with the database driver...?  The frontends are able to  
> access the Internet, and the backend is also the NFS server for the  
> diskless's frontend files.