Multiuser setup unable to attach to MySQL DB

Discussion in 'Installation/Configuration' started by webguyz, Oct 28, 2012.

  1. webguyz

    webguyz Member HowtoForge Supporter

    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: Oct 29, 2012

Share This Page