[mythtv-users] Remote database connect error, apparently not database privileges

[glen martin]

Greetings,

I'm provisioning a new frontend. Other frontends seem to work.  :) So
far as this frontend is concerned, there are 3 boxes that are usefully
talked about:

1) the mysql server is on one host;
2) the master backend is on a second host;
3) the frontend is on my desktop.

I'm at the stage of trying to run the frontend on this desktop for the
first time. As expected, it initially spits out gobs of errors, and then
brings up the screens to set hostnames and ids and so forth. Unlike in
previous cases, this doesn't clear up the problems. Here's the tail end
of the output:

<snip>
2006-06-15 13:34:56.245 Database not open while trying to save setting:
Language
2006-06-15 13:34:56.245 Clearing Settings Cache.
2006-06-15 13:34:56.245 Clearing Settings Cache.
2006-06-15 13:34:56.245 Unable to connect to database!
2006-06-15 13:34:56.245 No error type from QSqlError?  Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-15 13:34:56.296 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-15 13:35:18.481 Unable to connect to database!
2006-06-15 13:35:18.481 No error type from QSqlError?  Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-06-15 13:35:18.532 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-06-15 13:35:18.583 Failed to init MythContext, exiting.
</snip>

To forestall the obvious response, I've GRANTed access at the database. 
I've verified that the privileges should work by using the 'mysql' command.

eg. here's the top of my ~/.mythtv/mysql.txt:
<snip>
DBHostName=texada
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3
</snip>

I'm a little vague on what the DBType means .. I note that I'm using
MySQL v4.

Here's the mysql command:
<snip>
$ mysql -h texada -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 34 to server version: 4.1.14-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> 
</snip>

So it appears to me as if database access is fine from this host for the
relevant user and database, but is somehow still not working for mythtv.

For the record:
Gentoo, x86 using an Athlon64 in 32-bit mode
mythtv-0.19_p9163-r1
Library API version: 0.19.20060121-2
mysql-4.1.20

I've also done the obvious step of checking that all the hosts are
listed in host files.

Thoughts?

Thanks,

glen