[mythtv-users] remote frontend connection problems

[Bruce Markey]

Brian Wallen wrote:
> I've just installed a brand new backend server.  When I run mythfrontend 
> on the backend server, it connects and everything is great.  However, 
> when I try to connect a remote frontend to the backend, it doesn't 
> work.  I've searched all over and still havent found the answer to 
> this.  My mysql database has the right permissions.  I set them, then I 
> looked them up and it said that mythtv had the rights on 192.168.0.%, 
> which is correct. I have commented out the skip-networking part of the 
> my.cnf file, or whichever file it was, I can't remember right now.  Here 
> is the error I get when I try to run the remote mythfrontend.
> 
> 
> 2005-08-28 11:46:10.918 Unable to connect to database!
> 2005-08-28 11:46:10.918 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.0.6' (111)
> 
> 2005-08-28 11:46:10.918 Failed to init MythContext, exiting.

This says that it wasn't able to open a TCP/IP socket so the
user access may be correct but still unknown.

Recent MySQL versions (better info for debugging is at www.mysql.org
rather than www.mythtv.org) use a different config approach for
netowrking with the "bind-address". To allow connections to any address:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 0.0.0.0

Before trying mythfrontend again, makes sure you can connect with
the mysql client from the frontend machine with the parameters in
your mysql.txt file:

mysql -u mythtv -pmythtv -hyourmasterhost mythconverg

--  bjm