[mythtv-users] 'database not open' problem

[R. G. Newbury]

Mark Knecht wrote:
> Hello,
>    In parallel with getting my server working I'm also trying to get
> my remote machines upgraded and connecting over the network. Currently
> they do not connect correctly.
> 
> 1) From my remote frontend I can connect to the database by hand:
> 
> mark at lightning ~ $ mysql -h 192.168.1.55 -u mythtv -p mythconverg
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 19
> Server version: 5.0.40 Gentoo Linux mysql-5.0.40
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> quit
> Bye
> mark at lightning ~ $
> 
> This makes me believe that the changes to allow connection over the
> network have worked.
> 
> 2) When mythfrontend tries to connect from the remote machine
> lightning across the network to the backend it fails:
> 
> 
> mark at lightning ~ $ mythfrontend
> 2007-05-14 17:24:44.415 Using runtime prefix = /usr
> 2007-05-14 17:24:44.423 DPMS is active.
> 2007-05-14 17:24:44.423 Unable to read configuration file mysql.txt
> 2007-05-14 17:24:44.477 Trying to create a basic mysql.txt file
> 2007-05-14 17:24:44.477 Writing settings file /home/mark/.mythtv/mysql.txt
> QSqlDatabase: QMYSQL3 driver not loaded
> QSqlDatabase: available drivers:

This looks like you do not have the qt-MySQL driver package installed on 
the remote computer.  Note that this name is case sensitive so 'yum 
install qt-mysql' will fail. IIRC the error message is misleading in 
this case...

Geoff

-- 
              R. Geoffrey Newbury			


        Helping with the HTTP issue
<a href="http://www.w3.org/Protocols/">HTTP</a>