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

Darren fender_bender at aandr.com.au
Mon Dec 4 04:20:13 UTC 2006


On Mon, 4 Dec 2006 11:50 am, JCA wrote:
>    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)

G'day mate
You seem to be suffering the same problem as I did, the above output is what I 
WAS getting. It is not a permission problem it is a network problem. First 
make sure that mysql is listening for a connection, in a console type in 
"netstat -ap |grep mysql" there should be a tcp port listening if it isn't 
there then you will need to check the mysql config files for the option 
--skip-networking usually /etc/my.cnf but may depend on your distro. Mandriva 
has a second config file in /etc/sysconfig/mysqld which made it frustrating.

happy hunting
Darren
>
> 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?
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
> !DSPAM:45737816106101913415318!

-- 
"Better to remain silent and be thought a fool than to speak out and remove
all doubt." - Abraham Lincoln


More information about the mythtv-users mailing list