Pretty Sure This Has Been Covered Numerous Times But To Many Post's With Mixed Ways Of Doing Things On The Multiserver Setup ISPConfig3 Getting Me Confused.. I Have ISPCONFIG 3 Setup On One Of My Servers.. Wish To Add Two More Servers. Cant Get Server 2, Or Any Others To Show On The Main Panel. Installing, Selected Expert For Server 2, Main Server #1 named: s1.mydomain.com - IP Example: 192.168.1.10 SERVER #2 s2.mydomain.com IP Example: 192.168.1.11 Instaleld ISPCONFIG FINE SERVER 1. NO PROBS.. installing on server 2, Selected, expert Upon Combining With Server #1 Keep getting.. Unable to connect to mysql server. i can put the s1.mydomain.com and nothing. same prob with ip and pass. Will not connect. but typing server 2 IP which is the system im adding. it will connect no probs. been @ it a while trying to get my other servers in one panel.. Def need some help on this. is there something needed to add to server 1, before trying to connect server 2 or adding the server 2. if so can someone please explain step by step with examples of what there entering.. would def help me out alot.. thanks in advance for any help on resolving my issue.
Either you did not configure the /etc/hosts files on all servers as decribed in the multiserver installation guide or you did not add the mysql root user for IP and hostname in the master database as described in the multiserver install guide. Thats described in detail in the multiserver installation guides like this one: http://www.howtoforge.com/multiserv...se-servers-on-debian-squeeze-with-ispconfig-3
sorry didn't notice the guide on multi-server setup.. i believe both mentioned, are my problem. i only added server 1, to the host file since i originally only had installed one server with panel.. server 2, hasn't been added to the mysql or host file.. thanks for link. going back to the drawing board.. ill make changes to my systems following the guide. will post if i get it running.. thanks again for taking the time out to help and for the fast response...
ok, added both servers ips, to host file.. vi /etc/hosts looks like 127.0.0.1 localhost 192.168.1.10 s1.mydomain.com 192.168.1.11 s2.mydomain.com added server 2 to the main servers mysql.. (not sure if this is correct?) s2.mydomain.com root *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 192.168.1.11 root *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx server 1 is already entered in mysql, with the ISPconfig3 Install. still receiving the same error.. Unable to connect to mysql server am i entering it correctly?
Please check if you edited the mysql my.cnf file so that mysql listens on all interfaces as described in the guide and that you dont block the mysql port with a firewall.
thanks for the help and response... I HAVE THE SERVERS SETUP NOW IN ONE PANEL. sorry for the noobish questions... just wanted to make sure, before plunging and touching the master server that was already live.. thanks again for the snappy responses...
