[mythtv-users] 'database not open' problem

[Darren]

On Tuesday 15 May 2007 10:50, 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:
> 2007-05-14 17:24:44.489 New DB connection, total: 1
> 2007-05-14 17:24:44.489 Unable to connect to database!
> 2007-05-14 17:24:44.489 No error type from QSqlError?  Strange...
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-05-14 17:24:44.582 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
>
>    I've read online that this is mainly due to the qt library not
> having mysql support compiled in. I'm on Gentoo and beleive I do have
> myswl support compiled in. Here's what I have loaded which does
> include the mysql flag.
>
> lightning ~ # emerge -pv qt
>
> These are the packages that would be merged, in order:
>
> Calculating dependencies... done!
> [ebuild   R   ] x11-libs/qt-4.2.3-r1  USE="cups dbus gif jpeg mysql
> opengl png zlib -accessibility -debug -doc -examples (-firebird) -glib
> -mng -nas -nis -odbc -pch -postgres -qt3support -sqlite -sqlite3
> -xinerama" INPUT_DEVICES="-wacom" 0 kB
>
> Total: 1 package (1 reinstall), Size of downloads: 0 kB
> lightning ~ #
>
>    Since this is qt-4 I'm wondering if I also need qt3support?
>
>    Since qt takes quite a long time to compile I felt I'd ask first.
>
> Thanks,
> Mark
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Check to see if mysql is network enabled first. In a console use netstat -l |
grep mysql to see if it's listening on port 3306. Inspect mysql config 
(usually /etc/my.cnf ) to check the port number it's listening to and while 
your there make sure "skip-networking" is disabled, delete the line or 
#skip-networking then restart mysql.
You will also need to make sure the remote mythfrontend can find mythconverg 
host, in mythfrontend setup use the ip address of mythconverg host computer 
and a ~/user/.mythtv/mysql.txt file will be created.

goodluck
Darren