Multiple server setup [MySQL Connection refused]

Discussion in 'Installation/Configuration' started by NDIS, Sep 27, 2009.

  1. NDIS

    NDIS New Member

    Hello there,

    I am trying to set up a multiple server setup.

    1. I have completed the tutorial for debian lenny on the master server
    2. I have installed evrything with th edebian lenny tutorial, but when i want to install ISPConfig3 i choose expert mode and i get stuck at this point:

    Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

    MySQL master server hostname []: srv1.ndis.nl
    MySQL master server root username [root]:
    MySQL master server root password []: password
    MySQL master server database name [dbispconfig]:

    Unable to connect to mysql server
    MySQL master server hostname []:


    I have been googling for hours, but i can't find the sollution.
    Can somebody help me? Thanks.
     
  2. vogelor

    vogelor ISPConfig Developer ISPConfig Developer

    try if you can connectt to the master-server

    this is NOT a problem of ispconfig, it is a problem of your mysql-installation.

    please open a shell an server #2 and try to connect to your db at server #1

    type

    mysql -h <<your master-server>>

    for example

    mysql -h s1.mydomains.com

    if you get a Access denied then it works! (your did not get a connection without user and pwd, but the connection itself is ok.)

    if you get a "counld not connect to host..." then you don't have the right to connect from server #2 to server #1.

    then install phpmyadmin at server #1, log in to your db and add a user "root" and the IP (use the ip!) of server #2.

    then try the connection again.

    if this works, then the multiserveer-setup works fine too!

    Olli
     
  3. NDIS

    NDIS New Member

    I've added the user on phpmyadmin

    and evrything works now! Thanks!
     
    Last edited: Sep 27, 2009
  4. NDIS

    NDIS New Member

    another question can someone tell me how to configure the 2 nameservers?

    The second server i have installed needs to be the second nameserver.

    i want this:
    ns1.ndis.nl - 194.145.200.151
    ns2.ndis.nl - 194.145.200.154

    is this easy to fix?

    And do the 2 servers work with eachother? they copy evrything between the servers?
     

Share This Page