<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<br><div><div>On 2008/05/10, at 10:02 AM, Ryan Higgins wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><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 ?</blockquote><div><br></div><blockquote type="cite"><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div class="Wj3C7c">> 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 </div></div></blockquote></div></blockquote><div><br></div><div>Hi Robert,</div><div><br></div><div>Try these tests too...</div><div><br></div><div>To test your networking, try a telnet to the remote mysql box...</div><div>$ telnet <a href="http://10.0.250.4" target="_blank">10.0.250.4 </a>3306</div><div><div><div><div><div><br></div><div>If that works, hit it with the mysql client...</div><div>$ mysql -u kohaadmin –h <a href="http://10.0.250.4" target="_blank">10.0.250.4 </a>–p'mypassword' koha</div></div></div><div></div></div><div><br></div><div>Cheers, Mason.</div></div></div></body></html>