Multi Server Setup

Greetings all
Please could someone perhaps point out to me what I have missed. I am trying to get a simple multi server setup configured. I currently have 3 servers, they are all running on Debian 10.
cp01 - I have all services installed on this machine
ns01 - I have mysql webserver and dns installed on this machine
ns02 - I have mysql webserver and dns installed on this machine

Firstly I tried the lazy way and used the auto install script, Everything goes fine until the second server tries to connect to the master server, and I get a error "Unable to connect to mysql server Access denied for user 'root'@'ns01".
Then I went through the tutorials and followed these two links
https://www.howtoforge.com/perfect-...onfig-3-1/#-install-apache-web-server-and-php
https://www.howtoforge.com/how-to-r...-secondary-with-ispconfig-3-debian-squeeze-p2

So I gather there is a permission issue on the master sql server not having the correct permissions for my ns01 server. The strange thing is that if I go to phpmyadmin I can see that all relevant user accounts have all privileges on the ispconfig database. I have also added the relevant details needed in the hosts file to all servers



What have I missed?

Thanks in advance

 

Hi Till
Ok, so ive really tried to do this without asking with no success.
1) I have made sure that that all the entries are in the hosts file

Code:

127.0.0.1       localhost

54.39.235.237   cp01.zacp.online        cp01
165.255.254.115 cp02.zacp.online        cp02
51.161.9.126    ns01.zadns.online       ns01
158.69.63.247   ns02.zadns.online       ns02

::1     localhost       ip6-localhost   ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters


#127.0.1.1      debian.example.com
#127.0.1.1      vps260361       vps260361
#127.0.1.1      vps260361.vps.ovh.ca    vps260361

#127.0.1.1       vps260361.vps.ovh.ca    vps260361

2) I have edited /etc/mysql/mariadb.conf.d/50-server.cnf file and commented out the bind address on cp01

Code:

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Basic Settings
#
user                    = mysql
pid-file                = /run/mysqld/mysqld.pid
socket                  = /run/mysqld/mysqld.sock
#port                   = 3306
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
#skip-external-locking

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address            = 127.0.0.1

#

3) When running the command mysql -h cp01.zacp.online -u root -p
I get authentication, But when I use the master sql root password, its not excepting it and I get the error

Code:

ERROR 1045 (28000): Access denied for user 'root'@'ns01.zadns.online' (using password: YES)

I can however login with the above command if I use the slave mysql root password.


What am I missing?

 

My guess is the database users for hosts are missing nor not set up adequately. Check again those tutorials or consult ISPConfig Manual.