<br>Did you <br><br>GRANT ALL ON mykoha_db_name.* to <a href="mailto:kohaadmin@72.227.31.7">kohaadmin@72.227.31.7</a> <br><br>on the mysql server ?<br><br>Can you connect to the mysql server with the commandline mysql client on the koha server ?<br>
<br>HTH<br><br>Ryan<br><br><br><div class="gmail_quote">On Fri, May 9, 2008 at 5:53 PM, Ken Lomax <<a href="mailto:ken@lomax.gen.nz">ken@lomax.gen.nz</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Rob<br>
<br>
Can you please let us know which version of Koha you are using.<br>
<br>
Thanks<br>
<br>
Ken Lomax<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
> I had to change the IP scheme of my network. I have changed the<br>
> interfaces, hosts and koha.conf files to reflect the new IP. When I try<br>
> to access Koha by typing <a href="http://koha.domain.com:8050" target="_blank">http://koha.domain.com:8050</a> I get a 500<br>
> internal server error. My opac-error_log file says:<br>
><br>
><br>
><br>
> Thu May 08 21:24:58 2008] [error] [client <a href="http://72.227.31.7" target="_blank">72.227.31.7</a>] DBI<br>
> connect('Koha:<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>','kohaadmin',...) failed: Can't connect to<br>
> MySQL server on '<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>' (111) at<br>
> /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08<br>
> 21:24:58 2008] [error] [client <a href="http://72.227.31.7" target="_blank">72.227.31.7</a>] DBI<br>
> connect('Koha:<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>','kohaadmin',...) failed: Can't connect to<br>
> MySQL server on '<a href="http://10.0.250.4" target="_blank">10.0.250.4</a>' (111) at<br>
> /usr/local/koha/intranet/modules/C4/Context.pm line 411 [Thu May 08<br>
> 21:24:58 2008] [error] [client <a href="http://72.227.31.7" target="_blank">72.227.31.7</a>] Can't call method "prepare"<br>
> on an undefined value at /usr/local/koha/opac/cgi-bin/opac-main.pl line<br>
> 16.<br>
><br>
> [Thu May 08 21:24:58 2008] [error] [client <a href="http://72.227.31.7" target="_blank">72.227.31.7</a>] Premature end of<br>
> script headers: opac-main.pl<br>
><br>
><br>
><br>
> The Koha database is located on a different server that also received a<br>
> new IP address. Can anyone help me determine what configuration step I<br>
> have missed. I should also mention I am fairly new to Linux and Koha.<br>
><br>
><br>
><br>
> Thanks for the help<br>
><br>
><br>
><br>
> *******************************<br>
><br>
> Rob Linebaugh<br>
><br>
> Director of Computer Services<br>
><br>
> Davis College<br>
><br>
> 400 Riverside Drive<br>
><br>
> Johnson City, NY 13790<br>
><br>
> T: 607.729.1581 ext.404<br>
><br>
> F: 607.729.2962<br>
><br>
><br>
><br>
</div></div>> _______________________________________________<br>
> Koha mailing list<br>
> <a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
><br>
<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Ryan Higgins<br><br>LibLime * Open-Source Solutions for Libraries<br>Featuring KohaZOOM ILS<br>888-564-2457 x704