Changed IP - Can't connect to mysql 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 [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 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Can't call method "prepare" on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line 16. [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Premature end of script headers: opac-main.pl The Koha database is located on a different server that also received a new IP address. Can anyone help me determine what configuration step I have missed. I should also mention I am fairly new to Linux and Koha. Thanks for the help ******************************* 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
Hi Rob Can you please let us know which version of Koha you are using. Thanks Ken Lomax
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 [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 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Can't call method "prepare" on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line 16.
[Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Premature end of script headers: opac-main.pl
The Koha database is located on a different server that also received a new IP address. Can anyone help me determine what configuration step I have missed. I should also mention I am fairly new to Linux and Koha.
Thanks for the help
*******************************
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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Did you GRANT ALL ON mykoha_db_name.* to kohaadmin@72.227.31.7 on the mysql server ? Can you connect to the mysql server with the commandline mysql client on the koha server ? HTH Ryan On Fri, May 9, 2008 at 5:53 PM, Ken Lomax <ken@lomax.gen.nz> wrote:
Hi Rob
Can you please let us know which version of Koha you are using.
Thanks
Ken Lomax
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 [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 [Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Can't call method "prepare" on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line 16.
[Thu May 08 21:24:58 2008] [error] [client 72.227.31.7] Premature end of script headers: opac-main.pl
The Koha database is located on a different server that also received a new IP address. Can anyone help me determine what configuration step I have missed. I should also mention I am fairly new to Linux and Koha.
Thanks for the help
*******************************
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
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704
On 2008/05/10, at 10:02 AM, Ryan Higgins wrote:
Did you
GRANT ALL ON mykoha_db_name.* to kohaadmin@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 3306 If that works, hit it with the mysql client... $ mysql -u kohaadmin –h 10.0.250.4 –p'mypassword' koha Cheers, Mason.
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@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 From: Mason James [mailto:mason.loves.sushi@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@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.
participants (4)
-
Ken Lomax -
Mason James -
Robert Linebaugh -
Ryan Higgins