Mason – Thanks for all the help. Actually your
previous email with those troubleshooting commands helped me find the
problem. Once I discovered I could not telnet on port 3306 to the remote
server I found that port 3306 on the database server was only open to one
IP. I changed the IP to the new one and telnet worked. I then tried
connecting to the remote database from a client using the mysql command you
suggested and still could not connect. I looked to see if any linux firewall
rules were enabled on the remote database server and found everything to
be locked down to only allow communication from one server. I updated the
rules with the appropriate IP and everything started working again. Thanks
again for pointing me in the right direction.
Rob
From: Mason James
[mailto:mason.loves.sushi@gmail.com]
Sent: Monday, May 12, 2008 10:11 PM
To: Robert Linebaugh
Cc: koha-devel@nongnu.org
Subject: Re: [Koha] Changed IP - Can't connect to mysql server
On 2008/05/13, at 3:44 AM, Robert Linebaugh wrote:
The my.cnf is located at /etc/my.cnf. Below is the
info. I don’t seem to have a bind-address.
[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]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
HI Rob
Hmm, the 'bind-address' option is a mysql5-ism, i
think..
Have a look here for info on your mysql4 issue
Cheers, Mason.