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

[Mason James]

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 3306

If that works, hit it with the mysql client...
$ mysql -u kohaadmin –h 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/20080510/0a95d69a/attachment.htm