Re: [Koha] Changed IP - Can't connect to mysql server
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 http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html Cheers, Mason.
participants (1)
-
Robert Linebaugh