#1  
Old 11th December 2012, 10:26
almere almere is offline
ISPConfig Developer
 
Join Date: Nov 2012
Location: Netherlands, Rotterdam
Posts: 231
Thanks: 20
Thanked 39 Times in 34 Posts
Send a message via Skype™ to almere
Question Multiserver

Hi,

I have to servers.

First - s1.
Second - s2.

At s1 i have ISPConfig 3.0.5 (Beta 1) running, and i want to add a new server, so that i can manage all servers from s1 (i want to manage server s2 and lateer s3,4,5 from s1). What i did:

Installed everything, like here at s2: http://www.howtoforge.com/perfect-se...ispconfig-3-p6. But i choose expert mode and tried to connect to s1. But it didn't succeed.

I tried mysql -h s1.example.com -u root -p (Entered right password), but i get:
ERROR 1130 (HY000): Host 's1.example.com' is not allowed to connect to this MySQL server

What i did wrong?
Reply With Quote
Sponsored Links
  #2  
Old 11th December 2012, 10:53
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,976
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
Default

Did you add 2 mysql root users on the master mysql server, the first one that is allowed to connect from the hostname of the slave and the second one which is allowed to connect from the Ip address of the slave as described in the multiserver setup guides? And di you change the /etc/hosts files on both servers as described in the multiserver setup guides so that they contain lines for the hostname of all servers that are part of this setup?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 11th December 2012, 11:05
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 265
Thanked 151 Times in 131 Posts
Default

Verry off topic, but I love your forum name.
Almere... It's the name of the placed that I live in :-)
__________________
Never execute code written on a Friday or a Monday.
Reply With Quote
  #4  
Old 11th December 2012, 19:28
i11usions i11usions is offline
Junior Member
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

you should create sql users in the master database

CREATE USER 'root'@'s2' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'s2' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
Reply With Quote
  #5  
Old 11th December 2012, 19:48
almere almere is offline
ISPConfig Developer
 
Join Date: Nov 2012
Location: Netherlands, Rotterdam
Posts: 231
Thanks: 20
Thanked 39 Times in 34 Posts
Send a message via Skype™ to almere
Default

i11usions, till thank you guys. I managed it my self. Now it works.

I saw a thread, where some person had a problem with monitoring of multiservers. Its true. I installed it and i can see Overview, but not Server State (system load, disk usage etc.). I have Debian squeeze on both of my servers.
Maybe you have some advices about it?

Thank you.

edge, check your ls
Reply With Quote
  #6  
Old 11th December 2012, 21:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,976
Thanks: 825
Thanked 5,369 Times in 4,216 Posts
 
Default

The most likely reason for this problem is that you did not had configured the /etc/hosts files correcrly on both servers before you installed ispconfig on the slave server. If the configuration is was not correct, ispconfig is not able to connect to the master later to replicate chnages and update the monitor. Take a look at the multiserver tutorials, the configuration is described there.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Multiserver / General ISPconfig Architecture KoS Installation/Configuration 5 4th August 2012 11:12
Migration from old multiserver to new multiserver johjoh2k Server Operation 0 11th July 2012 05:48
IP's for multiserver setup scottrill2 Installation/Configuration 1 31st January 2012 12:59
Installer in multiserver setup. CSsab Installation/Configuration 1 22nd November 2011 09:15
Multiserver setup design documentation agoston Developers' Forum 4 4th June 2009 13:53


All times are GMT +2. The time now is 19:36.


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