[mythtv-users] 'database not open' problem

[Mark Knecht]

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