[mythtv-users] Unable to access database from remote client

JCA 1.41421 at gmail.com
Mon Dec 4 01:20:28 UTC 2006


   I am trying to set up a remote mythfrontend client on a box A, to
connect to the backend in a box B, so far without any success. This is
what I get when I invoke mythfrontend on A:

2006-12-03 17:04:01.386 Using runtime prefix = /usr/local
2006-12-03 17:04:01.440 XScreenSaver support enabled
2006-12-03 17:04:01.441 DPMS is disabled.
2006-12-03 17:04:01.461 New DB connection, total: 1
2006-12-03 17:04:01.463 Unable to connect to database!
2006-12-03 17:04:01.463 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.7' (111)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-12-03 17:04:01.542 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-12-03 17:04:01.611 Unable to connect to database!
2006-12-03 17:04:01.612 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.7' (111)

and so on.

   The database and mythbackend are running on B, whose IP address
indeed is 192.168.0.7. A and B are in the same LAN, and they can
access each other without a problem - except for mythfrontend running
on A.

   I invoked myth-setup on B and made sure that this is the IP address
it connects to. Mythfrontend invoked on the backend box runs fine, and
it is configured on A with the sam MySQL parameters (user name,
password, database name) as in B.

   What am I missing?


More information about the mythtv-users mailing list