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-server-debian-squeeze-with-bind-and-dovecot-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?
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?
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 ;
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
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.
