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

[Robert Linebaugh]

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

 

 

*******************************

Rob Linebaugh

Director of Computer Services

Davis College

400 Riverside Drive

Johnson City, NY  13790

T: 607.729.1581 ext.404

F: 607.729.2962

 

From: Mason James [mailto:mason.loves.sushi at gmail.com] 
Sent: Monday, May 12, 2008 9:42 AM
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 1:13 AM, Robert Linebaugh wrote:





Koha version 2.2.5  (Internal IP 10.0.254.3)

Mysql version 4.1  (Internal IP 10.0.254.4)

 

I did not use the GRANT ALL ON command on the mysql server.  I assume
this command has to be performed on the mysql server and the @server
should be the Koha server?  (ex.  GRANT ALL ON koha.* to
kohaadmin at 10.0.254.3  ) I probably need to know the mysql root password
that I've been reading about?

 

I'm not sure how to connect to the mysql server with the commandline
mysql client from the koha server.

 

C:\Documents and Settings\rlinebaugh>telnet 10.0.250.4 3306

Connecting To 10.0.250.4...Could not open connection to the host, on
port 3306:

Connect failed

 

Rob

 

 

Hi Rob, 

 

your mysql server isnt configured to allow remote connections.

 

these are *nix examples, but you get the gist...

You can google for more info.

 

 

1) edit your mysql conf file , change your bind-address value from
127.0.0.1 to your server's IP

 

server$ vi /etc/mysql/my.cnf

# bind-address       = 127.0.0.1    

bind-address        = 10.0.254.4

 

------------

2) restart your mysqld

server$ /etc/init.d/mysql restart

 

------------

3)  connect to server from the client....

client $ mysql -u kohaadmin -h 10.0.254.4  -p    koha

Your MySQL connection id is 8

Server version: 5.0.32-Debian_7etch5 Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> 

 

Mason.

 

 

 





From: Mason James [mailto:mason.loves.sushi at gmail.com] 
Sent: Friday, May 09, 2008 7:53 PM
To: Ryan Higgins
Cc: Robert Linebaugh; koha
Subject: Re: [Koha] Changed IP - Can't connect to mysql server

 

 

On 2008/05/10, at 10:02 AM, Ryan Higgins wrote:







Did you 

GRANT ALL ON mykoha_db_name.* to kohaadmin at 72.227.31.7 

on the mysql server ?

Can you connect to the mysql server with the commandline mysql client on
the koha server ?

 

		> I had to change the IP scheme of my network.  I have
changed the
		> interfaces, hosts and koha.conf files to reflect the
new IP.  When I try
		> to access Koha by typing http://koha.domain.com:8050 I
get a 500
		> internal server error.  My opac-error_log file says:
		>
		>
		>
		> Thu May 08 21:24:58 2008] [error] [client 72.227.31.7]
DBI
		> connect('Koha:10.0.250.4','kohaadmin',...) failed:
Can't connect to
		> MySQL server on '10.0.250.4' (111) at
		> /usr/local/koha/intranet/modules/C4/Context.pm line
411

 

Hi Robert,

 

Try these tests too...

 

To test your networking, try a telnet to the remote mysql box...

$ telnet 10.0.250.4  <http://10.0.250.4> 3306

 

If that works, hit it with the mysql client...

$ mysql -u kohaadmin -h 10.0.250.4   <http://10.0.250.4> -p'mypassword'
koha

 

Cheers, Mason.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080512/67b993bd/attachment-0001.htm