|
From: | Robert Linebaugh |
Subject: | [Koha-devel] RE: [Koha] Changed IP - Can't connect to mysql server |
Date: | Mon, 12 May 2008 11:44:04 -0400 |
The my.cnf is located at /etc/my.cnf. Below is the
info. I don’t seem to have a bind-address. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with
mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ******************************* 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 From: Mason James
[mailto:address@hidden 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 address@hidden
) 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:address@hidden] On 2008/05/10, at 10:02 AM, Ryan
Higgins wrote:
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. |
[Prev in Thread] | Current Thread | [Next in Thread] |