Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th March 2010, 14:55
zenny zenny is offline
Senior Member
 
Join Date: Nov 2006
Posts: 177
Thanks: 21
Thanked 7 Times in 7 Posts
Question [SOLVED] Mysql in a different host inaccessible

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:

Code:
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:
Code:
#/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:

Code:
#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:

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


>> 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:

Quote:
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

Last edited by zenny; 15th March 2010 at 16:00.
Reply With Quote
Sponsored Links
  #2  
Old 14th March 2010, 20:09
zenny zenny is offline
Senior Member
 
Join Date: Nov 2006
Posts: 177
Thanks: 21
Thanked 7 Times in 7 Posts
Default tried this too

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 :

Quote:
Unable to connect to mysql server Access denied for user 'root'@'192.168.1.101' (using password: YES)
Has anyone encountered such a problem?
Reply With Quote
  #3  
Old 15th March 2010, 14:07
zenny zenny is offline
Senior Member
 
Join Date: Nov 2006
Posts: 177
Thanks: 21
Thanked 7 Times in 7 Posts
Default Works with others, but not ispconfig3 3.0.2 installation

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)

Code:
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:
Code:
$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

Last edited by zenny; 15th March 2010 at 14:28.
Reply With Quote
  #4  
Old 15th March 2010, 16:06
zenny zenny is offline
Senior Member
 
Join Date: Nov 2006
Posts: 177
Thanks: 21
Thanked 7 Times in 7 Posts
 
Smile [SOLUTION] Mysql in a different host inaccessible

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:

Code:
#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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 14:58
smtp is error!!! fhawk Installation/Configuration 2 7th April 2009 14:17
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Postfix problem: lost connection after CONNECT from unknown fernando_torrez Server Operation 5 30th November 2007 15:17
This is %#@*&^$# embarrassing! domino Smalltalk 34 5th February 2007 22:57


All times are GMT +2. The time now is 04:05.


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