I had no line like you mentioned in my.cnf so I knew that couldn't be it.
this little step might go in a document someplace, I was working off of
http://www.mythtv.info/moin.cgi/MythOnMacOsx
perhaps mention that the backend has to be setup with an IP address other than 127.0.0.1. hmm looks like I can add an edit myself. I'll go ahead and do that...
thanks much
On Feb 26, 2005, at 12:35 PM, Louie Ilievski wrote:
I had this same problem on Gentoo as well, and then figured it out. Edit /etc/mysql/my.cnf, and on line 69, it says bind-address. I just comment mine out, but if you want you can specifically put the network address of your card. I'm not sure, but I believe that commenting it out binds it to all addresses it has.
~Lou
M.Barnabas Luntzel wrote:
yeah what is that file? been trying to get an os X frontend running, I give it my backend IP (also gone through the sql commands below) and yet it still tries to contact 127.0.0.1 mysql port.
On Feb 26, 2005, at 9:27 AM, Greg Miller wrote:
It's in the Mythtv Documentation. I can't remember the name of the file but
you have to change the bind address from 127.0.0.1 (or what ever it is) to
your IP. I had the same problem with Gentoo.
Greg
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lonnie Borntreger
Sent: Friday, February 25, 2005 5:38 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Failure to connect to remote backend
Most new packages of mysql have network access turned off by default.
Check your mysql startup files and make sure that they allow network access.
On Mandrake (and Redhat, I think) that is set in /etc/sysconfig/mysql, but I
don't know about Gentoo.
Lonnie
On Sat, 2005-02-26 at 13:22 +1300, Bernard Mentink wrote:
Hi All,
I have just done a fresh install of Gentoo on my master server which runs mythfrontend and a master mythbackend, IP is 192.168.0.3
My remote frontend is at IP 192.168.0.2.
I am getting the following error while trying to access the MySQL database from the remote frontend:
---------------- Unable to connect to database! Driver error was [1/2003]: QMYSQL3: Unable to connect Database error was: Can't connect to MySQL server on '192.168.0.3' (111) -----------------
My mysql.txt on the frontend is:
DBHostName=192.168.0.3 DBUserName=mythtv DBPassword=mythtv DBName=mythconverg
I have grant'ed all permission to mythconverg database on the master backend, so do not know why I cannot access it?
Any Idea's anyone?
I presume I do not have to have the mysql daemon running on the frontend, mythfrontend should just use the backend's database.
Cheers, ebike
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-- No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2/22/2005
-- No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
---------------------------------------------------------------------- --
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
