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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
