[mythtv-users] remote frontend connection problems
bjm at lvcm.com
Sun Aug 28 17:44:45 UTC 2005
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
More information about the mythtv-users