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

[Mason James]

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 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: </pipermail/koha-devel/attachments/20080513/2ac95c27/attachment-0002.htm>
-------------- next part --------------
_______________________________________________
Koha-devel mailing list
Koha-devel at nongnu.org
http://lists.nongnu.org/mailman/listinfo/koha-devel