HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Adding remote access to a MySQL database does nothing (http://www.howtoforge.com/forums/showthread.php?t=59369)

simonb 3rd November 2012 10:27

Adding remote access to a MySQL database does nothing
 
(ISPConfig Version: 3.0.4.6 on Ubuntu 10.04)

I need to make a MySQL database accessible to a remote server on the LAN. ISPConfig is running on 192.168.108.129.

I check the "Remote Access" checkbox and enter the IP of the remote server, 192.168.108.140, in the "Remote Access IP" textbox.

I set the bind address in /etc/mysql/my.cnf
Code:

bind-address            = 0.0.0.0
I open port 3306 on the firewall for the remote server. Port 3306 appears open if I test it with nmap on the remote server. So far so good.

However I can't access the database from the remote server.
Code:

mysql -h 192.168.108.129 c3songs -u c3songs -p
Enter password:
ERROR 1130 (HY000): Host '192.168.108.140' is not allowed to connect to this MySQL server

If I log into mysql as root on the ISPConfig server then there doesn't appear to be a c3songs user created for the 192.168.108.140 address.

Code:

mysql> select Host,User from mysql.user;
+--------------------+------------------+
| Host              | User            |
+--------------------+------------------+
| 127.0.0.1          | root            |
| ispconfig.example.com | root            |
...(abbreviated, other users listed here)
| localhost          | c3songs          |
... (abbreviated, other users listed here)
| localhost          | ispconfig        |
| localhost          | root            |
+--------------------+------------------+
19 rows in set (0.00 sec)

Is ISPConfig doing anything to enable remote access? I can't see any evidence of it in the database unless I am missing something.

If I set the logging level to debug and run server.sh at the command line I see the following related output when I enable external dB access...

Code:

03.11.2012-09:35 - DEBUG - Found 1 changes, starting update process.
/usr/bin/fail2ban-client
/sbin/iptables
/sbin/ip6tables
03.11.2012-09:35 - DEBUG - Calling function 'db_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_update'.
03.11.2012-09:35 - DEBUG - Changing MySQL remote access privileges for database: c3songs
03.11.2012-09:35 - DEBUG - Processed datalog_id 254

If I add permissions manually then I can access the database from the remote server. But shouldn't ISPConfig be doing that for me?

This works...
Code:

GRANT ALL PRIVILEGES ON c3songs.* To 'c3songs'@'192.168.108.140' IDENTIFIED BY '*****';

till 4th November 2012 14:18

Most likely the mysql root password has been changed in mysql without changing it in ispconfig so that ispconfig is not able to alter the mysql user. Check that the mysql root password is correct in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

simonb 4th November 2012 14:23

Quote:

Originally Posted by till (Post 287753)
Most likely the mysql root password has been changed in mysql without changing it in ispconfig so that ispconfig is not able to alter the mysql user. Check that the mysql root password is correct in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf

Hi Till,

I just checked the root password in the mysql_clientdb.conf with "mysql -u root -p" and it logged in fine. I haven't changed the mysql root password since installing ispconfig.

Thanks,


All times are GMT +2. The time now is 22:29.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.