Multiple server setup [MySQL Connection refused]

[NDIS]

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.

[vogelor]

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

[NDIS]

I've added the user on phpmyadmin

and evrything works now! Thanks!

[NDIS]

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?