[Koha] Changed IP - Can't connect to mysql server

[Robert Linebaugh]

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 at gmail.com] 
Sent: Monday, May 12, 2008 10:11 PM
To: Robert Linebaugh
Cc: koha-devel at 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

http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html

 

Cheers, Mason.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080515/c0b58fdc/attachment.htm