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

[glen martin]

I'll respond to my own question, for completeness, at the risk of
opening myself up to a fair amount of well-deserved ridicule. :)

I eventually figured this out. Seems I had two versions of qt installed
- 4.x and 3.x. Gentoo was happy because 3.x was installed, and the
latest install built qt with mysql. However, 3.x was built without mysql
support, so things were failing pretty miserably.  I solved by:

  emerge -C =x11-libs/qt-4.1.2
  echo "x11-libs/qt mysql" >> /etc/portage/package.use
  echo ">=x11-libs/qt-4"  >> /etc/portage/package.mask
  emerge qt

it remains to be seem what the removal of qt-4 might do to other
packages on the system, but after several days things seem to still be
working.

As an aside, another change I needed to make was to add privileges
(GRANT ...) in mysql based on host *name* and not just ip address or
address range.  This is unfortunate. :/

glen


glen martin wrote:
> 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
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>