Re: [mythtv-users] Failure to connect to remote backend

Sat, 26 Feb 2005 12:36:01 -0800

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

Reply via email to