[mythtv-users] Can only connect to mysql as localhost
Lan Barnes
lan at falleagle.net
Sun Aug 12 14:36:02 UTC 2007
On Sun, August 12, 2007 1:06 am, David Campbell wrote:
> Lan Barnes wrote:
>> I have diagnosed this and am convinced it is strictly a mysql
>> configuration problem.
>>
>> I have a mythtv BE/FE one one box in working order. I want to put remote
>> FEs on other machines. I had this working before but reinstalled my myth
>> box. Of course I've forgotten how.
>>
>> I have granted all on mythconverg.* to mythtv at
>> "192.168.1.0/255.255.255.0". I have selected from the mysql.user table
>> and
>> those privileges are in there.
>>
>> I change my database ip in mythsetup from localhost to either the ip
>> addr
>> or the BE's name. myth loses its connection when I do this and gets OK
>> when I change it back to localhost.
>>
>> But here's the interesting thing. Consider the results when I try
>> connecting with mysql from three machines:
>>
>> Connection command line was the same from each test host:
>>
>> mysql -h xena -u mythtv -p mythconverg
>>
>> 1. From the myth FE/BE (xena) newly upgraded: failure to connect to
>> 'localhost'
>>
>> 2. from my laptop (gypsy) never configured to be a remote FE: failure to
>> connect to 'gypsy'
>>
>> 3. from a workstation previously successfully configured to be a remote
>> FE
>> to the old mythtv installation: success!
>>
>> I've compared the /etc/my.cnf from the successful machine and the
>> others.
>> No difference. Also, nothing special in the environment variables on the
>> working machine.
>>
>> So I'm thinking, there is some configuration on the client machine that
>> makes this connection possible over tcp/ip, even if the client is on the
>> same machine as the backend.
>>
>> OR something broke in mysql between mythdora 3.2 and 4.0, which is
>> unlikely because the mythdora mailing list would be awash in complaints,
>> which it isn't.
>>
>> Does anyone know what I need to do to make the FE/BE mysql see itself
>> over
>> tcp/ip?
>
> what is thhe out put of
>
> ps auxww | grep mysql
>
[lbarnes at xena ~]$ ps auxww | grep mysql
root 2358 0.0 0.2 4484 1196 ? S Aug11 0:00 /bin/sh
/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf
--pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 2394 0.1 4.7 139976 24384 ? Sl Aug11 0:40
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--socket=/var/lib/mysql/mysql.sock
lbarnes 8339 0.0 0.1 3884 664 pts/0 R+ 07:32 0:00 grep mysql
> and
>
> netstat -an | grep 3306
>
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN
> Have you got port = defined in my.cnf?
>
[lbarnes at xena ~]$ cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
> Dave
>
>
--
Lan Barnes
SCM Analyst Linux Guy
Tcl/Tk Enthusiast Biodiesel Brewer
More information about the mythtv-users
mailing list