View Single Post
  #1  
Old 28th October 2012, 21:08
webguyz webguyz is offline
Member
 
Join Date: Oct 2012
Location: Earth
Posts: 83
Thanks: 27
Thanked 8 Times in 8 Posts
Default Multiuser setup unable to attach to MySQL DB

I am setting up a POC test using 2 servers, control.test.com and web01.test.com.

Installed ISP Manager on Debian as per the How-Tos and installed just the ISPConfig website on the server named control. That works just fine and I can access the website with no problem

When I go to attach the second server (web01) and going thru the install script it asks if this is an exisiting multisuer sertup and I answer yes. I then try to connect to the DB on the control server control.test.com and I give it the corerct login/passwpord info but it fails.

If I do a 'telnet control.test.com 3306' I get the error:
'Host 'xx.xxx.59.199' is not allowed to connect to this MySQL serverConnection closed by foreign host.'

On the control.webguyz.net in /etc/mysql/my.cnf I have commented out
#bind-address = 127.0.0.1

Did I miss a step somewhere? Normall when I see this error I have to do something like add a user with a % into the mysql db. Does that need to be done here?

Thanks!

UPDATE! Disregard. I mis-read the section on having to create entries for each remote server. Works fine now.

Last edited by webguyz; 29th October 2012 at 06:16.
Reply With Quote
Sponsored Links