View Single Post
  #6  
Old 6th April 2013, 06:26
darinpeterson darinpeterson is offline
HowtoForge Supporter
 
Join Date: Nov 2011
Posts: 149
Thanks: 35
Thanked 13 Times in 13 Posts
Default

Hi senkron24,

Here is some information that might help more...

Please make sure that you are performing these commands on your mysql database, and NOT the ISPConfig database. You can do this by installing your primary server first, login to phpmyadmin, click on the mysql database and run the following for every server except your primary server.

Say your primary server is on 192.168.1.151 (and say this is the mail server running the ISPConfig Control panel, which is mail.myserver.com).

Say you have three other servers:

192.168.1.152 web.myserver.com
192.168.1.153 db.myserver.com
192.168.1.154 ns.myserver.com


Entry for web.myserver.com
Code:
CREATE USER 'root'@'192.168.1.152' IDENTIFIED BY 'PA$$WORD';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.152' IDENTIFIED BY 'PA$$WORD' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'root'@'web.myserver.com' IDENTIFIED BY 'PA$$WORD';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'web.myserver.com' IDENTIFIED BY 'PA$$WORD' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Entry for db.myserver.com
Code:
CREATE USER 'root'@'192.168.1.153' IDENTIFIED BY 'PA$$WORD1';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.153' IDENTIFIED BY 'PA$$WORD1' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'root'@'db.myserver.com' IDENTIFIED BY 'PA$$WORD1';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'db.myserver.com' IDENTIFIED BY 'PA$$WORD1' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Entry for ns.server.com
Code:
CREATE USER 'root'@'192.168.1.154' IDENTIFIED BY 'PA$$WORD2';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.1.154' IDENTIFIED BY 'PA$$WORD2' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'root'@'ns.myserver.com' IDENTIFIED BY 'PA$$WORD1';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'ns.myserver.com' IDENTIFIED BY 'PA$$WORD1' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Now that you have created the user database records for your other servers, go ahead and install them and run IPSConfig installation on them. Make sure when you are asked if you want to join a multi-server setup you say "y" and the name of the multi-server setup is "mail.myserver.com".

I hope this helps...

Good luck,
Darin
Reply With Quote