Hello, I have a multi-server setup. For the two name servers -- "NS1" and "NS2" -- I created NS2 to be a mirror of NS1. Everything was working fine: zones that were created were getting created on NS1 and NS2, but now it seems that any changes I make in DNS are being made on NS1 but not synchronizing over to NS2. My NS2 remote from the other servers in the cluster, but it has tcp/3306 open to the external IPs my Control Panel and NS1 hosts are on, though I also have NS2 connected by VPN to the firewall the other servers are behind, so NS2 can reach them all on their internal IPs also. I am not sure what to check to see if there are any errors synchronizing with NS2. The '/var/log/ispconfig/ispconfig.log' files on the Control Panel, NS1, and NS2 do not show any such errors. Thanks, in advance, for your insight and pointing me in the right direction to diagnose (and hopefully fix) this issue. Edit: Clarification that NS2 is a mirror of NS1 rather than a slave.
In almost all cases, such sync issues are caused by problems with database access from slave to master. Login to the slave not, get the exact login details for the master server database from /usr/local/ispconfig/server/lib/config.inc.php and then test it with mysql command. Example: Code: mysql -h master.server.tld -u ispcsrv1 -p dbispconfig and enter the password when requested by the command.
I see a 'ispcsrv5' user for my NS2 server, but I don't seem to know what the password (it is different from the 'root' user I added when I first set this up). If I were to UPDATE this password to something I do know, what else would I have to do, other than the MySQL "UPDATE USER" command?
