Mysql in a different host inaccessible

[zenny]

I am following Falko's wonderful tutorial:

1) http://www.howtoforge.com/kvm-and-op...ith-proxmox-ve

to create VEs, and

2) http://www.howtoforge.com/perfect-se...nny-ispconfig3

to install different services in the different VEs. eg.

a) VE101 hosts web services like http, ftp (netftp), 1st dns and ispconfig3 (a wonderful product :-)
b) VE102 hosts db services like mysql
c) VE103 hosts mail services like postfix, courier, squirrelmal/roundcube
d) VE104 hosts 2nd dns server
5) VE105 hosts a telephone server

Installation of web, ftp and dns services were successful except quota (as there is nothing in VE1's /etc/fstab under openvz???), but when I try to install ispconfig3 in VE101, I could not access the db server in VE102 to create the dbispconfig database with an error message:

Unable to connect to mysql server Host '192.168.1.101' is not allowed to connect to this MySQL server

I tried to open mysql port 3306 on the VE2 (db server) with:

#/sbin/iptables -A INPUT -i venet0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT

Still I get to the same error. :-(

In the meantime, I did the following in the VE2 db server:

#mysql -u root -p
#grant all on *.* to root@192.168.1.101 identified by 'password';

It let me go beyond the selection of db, but I got the the following error in next step:

--------------------------------------------------------------------------------
_____ ___________ _____ __ _
|_ _/ ___| ___ \ / __ \ / _(_)
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
__/ |
|___/
--------------------------------------------------------------------------------


>> Initial configuration

Operating System: Debian Lenny or compatible

Following will be a few questions for primary configuration so be careful.
Default values are in [brackets] and can be accepted with <ENTER>.
Tap in "quit" (without the quotes) to stop the installer.


Select language (en,de) [en]:

Installation mode (standard,expert) [standard]: expert

Full qualified hostname (FQDN) of the server, eg server1.domain.tld [web.localhost]:

MySQL server hostname [localhost]: 192.168.1.102

MySQL root username [root]:

MySQL root password []: password

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

Shall this server join an existing ISPConfig multiserver setup (y,n) [n]:

ERROR: Unable to load SQL-Dump into database table.

And the last solution mentioned here (http://www.howtoforge.com/forums/sho...t=mysql+server) does not apply to my case as I am yet to install the ispconfig3 and there is any links as mentioned to the clientdb.

And I am just confused whether I have to install everything [including the webservers in the db server (VE102 in my case] in case I try to go after Till's advice:

ISPConfig has to be installed on the dbserver as well. Install ispconfig on the database server in expert mode and choose to join the master server then.

Please suggest. Thanks!!!

z

[zenny]

I tried as stated here, too: http://how2forge.org/forums/showthread.php?t=30009 by installing mysql-client on VE101 (web server) and unsuccesful. I can connect using 'mysql -h 192.168.1.102 -u root -p' where the IP is my db server VE.

Then I tried to do as instructed here: http://sudhaker.com/linux-unix/openv...z-cluster.html

Still, I am getting :

Unable to connect to mysql server Access denied for user 'root'@'192.168.1.101' (using password: YES)

Has anyone encountered such a problem?

[zenny]

In order to check whether this problem is dbserver-side or ispconfig3 installation script, I downloaded icebb to the VE101 (webserver where I want to install ispconfig 3) and installed the db in VE102. The installation went smoothly without any hitches. The following is the output from the VE102 (db server)

mysql> show grants for root@192.168.1.101;
+--------------------------------------------------------------------------------------------------------------------------+
| Grants for root@192.168.1.101                                                                                            |
+--------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.101' IDENTIFIED BY PASSWORD '*E1TB0C38323EC954FM1908F585476Q42037713J6' | 
| GRANT ALL PRIVILEGES ON `dbispconfig`.* TO 'root'@'192.168.1.101'                                                        | 
| GRANT ALL PRIVILEGES ON `icebb`.* TO 'root'@'192.168.1.101'                                                              | 
+--------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

If I could install icebb with the same database and permissions, then there could be something with the ispconfig3 installer that prevents me installing ispconfig3 on a remote db host (in my case 192.168.1.102).

Likewise, I can access the db server (in VE102) after making necessary changes in the /etc/phpmyadmin/config.inc.php in VE101as of below:

$i++;
$cfg['Servers'][$i]['host']          = '192.168.1.102';
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'root';
$cfg['Servers'][$i]['password']      = 'password';

Thus, it seems like it is the problem with the ISPConfig3 installer. I am struggling to install ISPConfig3 for some 36 hours in such a setup, but in vain. Any inputs will be highly appreciated. I really like and need ISPConfig. Thanks!
zenny

[zenny]

Just whining for a day and half and found a solution by executing the following command at mysql prompt on the VE running db-server:

#mysql -u root -p <ENTER>
mysql> GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.101' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

However, once the ispconfig3 gets installed, the ispconfig@localhost user in the db-server should be renamed to ispconfig@192.168.1.101 to get rid of the error that is encountered while login to ISPconfig3 gui.

all previous tweaks were reverted back.

However, I am trying to figure out how can I configure the mail server in VE103 as I installed without configuring mail while installing ISPConfig3. Any hints will be appreciated.

z