View Single Post
  #1  
Old 3rd November 2012, 11:27
simonb simonb is offline
Junior Member
 
Join Date: Aug 2011
Posts: 13
Thanks: 1
Thanked 3 Times in 2 Posts
Default 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 '*****';

Last edited by simonb; 3rd November 2012 at 11:54.
Reply With Quote
Sponsored Links