Second dns server not updating

Hi. I did this tutorial for Ubuntu 16.04:
https://www.howtoforge.com/how-to-r...and-secondary-with-ispconfig-3-debian-squeeze
I used packages from:
https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/

I added a second dns server but I have this error at the top of my panel:
The following changes are not yet populated to all servers:
datalog_status_u_server: 1

Jobqueue

ns2.mydomain.com Update server

root@ns1:~# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

##### SCRIPT FINISHED #####
Results can be found in htf_report.txt
To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console.

If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug).

root@ns1:~# cat htf_report.txt | more

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
IP-address(es) (as per ifconfig): ***.***.***.***
[WARN] ip addresses from hostname differ from ifconfig output. Please check your
ip settings.
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.1dev


##### VERSION CHECK #####

[INFO] php (cli) version is 7.0.22-0ubuntu***.***.***.***

##### PORT CHECK #####


##### MAIL SERVER CHECK #####


##### RUNNING SERVER PROCESSES #####

[INFO] I found the following web server(s):
Apache 2 (PID 1658)
[INFO] I found the following mail server(s):
Postfix (PID 2297)
[INFO] I found the following pop3 server(s):
Dovecot (PID 1267)
[INFO] I found the following imap server(s):
Dovecot (PID 1267)
[INFO] I found the following ftp server(s):
PureFTP (PID 2179)

##### LISTENING PORTS #####
(only ()
Local (Address)
[anywhere]:993 (1267/dovecot)
[anywhere]:995 (1267/dovecot)
[localhost]:10023 (1462/postgrey.pid)
[localhost]:10024 (2449/amavisd-new)
[localhost]:10025 (2297/master)
[localhost]:10026 (2449/amavisd-new)
[localhost]:10027 (2297/master)
[anywhere]:587 (2297/master)
[localhost]:11211 (1210/memcached)
[anywhere]:110 (1267/dovecot)
[anywhere]:143 (1267/dovecot)
[anywhere]:465 (2297/master)
[anywhere]:21 (2179/pure-ftpd)
***.***.***.***:53 (1223/named)
[localhost]:53 (1223/named)
[anywhere]:22 (1229/sshd)
[anywhere]:25 (2297/master)
[localhost]:953 (1223/named)
*:*:*:*::*:443 (1658/apache2)
*:*:*:*::*:993 (1267/dovecot)
*:*:*:*::*:995 (1267/dovecot)
*:*:*:*::*:10023 (1462/postgrey.pid)
*:*:*:*::*:10024 (2449/amavisd-new)
*:*:*:*::*:10026 (2449/amavisd-new)
*:*:*:*::*:3306 (1612/mysqld)
*:*:*:*::*:587 (2297/master)
[localhost]10 (1267/dovecot)
[localhost]43 (1267/dovecot)
*:*:*:*::*:8080 (1658/apache2)
*:*:*:*::*:80 (1658/apache2)
*:*:*:*::*:465 (2297/master)
*:*:*:*::*:8081 (1658/apache2)
*:*:*:*::*:21 (2179/pure-ftpd)
*:*:*:*::*:53 (1223/named)
*:*:*:*::*:22 (1229/sshd)
*:*:*:*::*:25 (2297/master)
*:*:*:*::*:953 (1223/named)




##### IPTABLES #####
Chain INPUT (policy ACCEPT)
target prot opt source destination
f2b-dovecot-pop3imap tcp -- [anywhere]/0 [anywhere]/0 m
ultiport dports 110,995,143,993
f2b-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport
dports 21
f2b-postfix-sasl tcp -- [anywhere]/0 [anywhere]/0 multi
port dports 25
f2b-sshd tcp -- [anywhere]/0 [anywhere]/0 multiport dp
orts 22

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

Chain f2b-dovecot-pop3imap (1 references)
target prot opt source destination
RETURN all -- [anywhere]/0 [anywhere]/0

Chain f2b-postfix-sasl (1 references)
target prot opt source destination
RETURN all -- [anywhere]/0 [anywhere]/0

Chain f2b-pureftpd (1 references)
target prot opt source destination
RETURN all -- [anywhere]/0 [anywhere]/0

Chain f2b-sshd (1 references)
target prot opt source destination
RETURN all -- [anywhere]/0 [anywhere]/0


root@ns2:~# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php
PHP Warning: file_get_contents(/etc/postfix/master.cf): failed to open stream: No such file or directory in /root/htf-common-issues.php on line 254

##### SCRIPT FINISHED #####
Results can be found in htf_report.txt
To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console.

If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug).

root@ns2:~# cat htf_report.txt | more

##### SERVER #####
IP-address (as per hostname): ***.***.***.***
IP-address(es) (as per ifconfig): ***.***.***.***
[WARN] ip addresses from hostname differ from ifconfig output. Please check your
ip settings.
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.1dev


##### VERSION CHECK #####

[INFO] php (cli) version is 7.0.22-0ubuntu***.***.***.***

##### PORT CHECK #####

[WARN] Port 8080 (ISPConfig) seems NOT to be listening
[WARN] Port 8081 (ISPConfig Apps) seems NOT to be listening
[WARN] Port 80 (Webserver) seems NOT to be listening
[WARN] Port 443 (Webserver SSL) seems NOT to be listening
[WARN] Port 143 (IMAP server) seems NOT to be listening
[WARN] Port 993 (IMAP server SSL) seems NOT to be listening
[WARN] Port 110 (POP3 server) seems NOT to be listening
[WARN] Port 995 (POP3 server SSL) seems NOT to be listening
[WARN] Port 25 (SMTP server) seems NOT to be listening
[WARN] Port 465 (SMTP server SSL) seems NOT to be listening
[WARN] Port 21 (FTP server) seems NOT to be listening
[WARN] Port 25 (SMTP server) seems NOT to be listening

##### MAIL SERVER CHECK #####

[WARN] I found no "smtp" entry in your postfix master.cf
[WARN] I found no "submission" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer port 587 for smtp connecti
ons you have to enable this.
[WARN] I found no "smtps" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) con
nections you have to enable this.

##### RUNNING SERVER PROCESSES #####

[WARN] I could not determine which web server is running.
[WARN] I could not determine which mail server is running.
[WARN] I could not determine which pop3 server is running.
[WARN] I could not determine which imap server is running.
[WARN] I could not determine which ftp server is running.

##### LISTENING PORTS #####
(only ()
Local (Address)
[localhost]:3306 (1584/mysqld)
***.***.***.***:53 (1273/named)
[localhost]:53 (1273/named)
[anywhere]:22 (1272/sshd)
[localhost]:953 (1273/named)
*:*:*:*::*:53 (1273/named)
*:*:*:*::*:22 (1272/sshd)
*:*:*:*::*:953 (1273/named)




##### IPTABLES #####
Chain INPUT (policy ACCEPT)
target prot opt source destination

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

 

How do I fix it?
root@ns2:~# crontab -e
crontab: installing new crontab
root@ns2:~# /usr/local/ispconfig/server/server.sh
21.01.2018-11:27 - WARNING - There is already a lockfile set, but no process running with this pid (15409). Continuing.
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200
DB::query -> reconnectUnable to load the server configuration from database.PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'47-47-194-72.static.slid.la.charter.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!root@ns2:~#

 

Any help on fixing my problem after debugging my fresh install? I can't upload my websites untill I find out how to fix this problem.

 

I don't understand. I only have ns1 and ns2. How can I fix this error post install or do I have to reinstall both server from the beginning?

 

Check that you have run the MYSQL shell commands for CREATE USER. Since there are lots of access denied, those users or passwords may be wrong.Or maybe the hostname or IP-number. Try mysql command with those usernames or paswords from command line to check more directly what works and what does not work.
You may also purchace the ISPConfig manual, it explains how to setup multiserver in ISPConfig.

 

Ok... So it could most likely typos? If so Then that's a good thing. I'll try the commands from the tutorial again and tell you if it works.
p.s. I already purchased the manual but everything is with debian 6. It's outdated just like the tutorial I used to add the second server.

 

Ok Thank you.

 

root@ns1:~# /usr/local/ispconfig/server/server.sh


24.01.2018-13:15 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
24.01.2018-13:15 - DEBUG - Found 2 changes, starting update process.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Network configuration disabled in server settings.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'xmpp_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Processed datalog_id 7
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Network configuration disabled in server settings.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Calling function 'update' from plugin 'xmpp_plugin' raised by event 'server_update'.
24.01.2018-13:15 - DEBUG - Processed datalog_id 8
24.01.2018-13:15 - DEBUG - Calling function 'restartHttpd' from module 'web_module'.
24.01.2018-13:15 - DEBUG - Restarting httpd: systemctl restart apache2.service
24.01.2018-13:15 - DEBUG - Calling function 'restartXMPP' from module 'xmpp_module'.
24.01.2018-13:15 - DEBUG - Restarting xmpp: systemctl restart metronome.service
24.01.2018-13:15 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.
root@ns1:~#

 

I did the commands with my info and it's still not working...
mysql -u root -p

On the MySQL shell, run the following queries:

CREATE USER 'root'@'1.2.3.5' IDENTIFIED BY 'yourrootsqlpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'1.2.3.5' IDENTIFIED BY 'yourrootsqlpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE USER 'root'@'server2.example.com' IDENTIFIED BY 'yourrootsqlpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'server2.example.com' IDENTIFIED BY 'yourrootsqlpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

FLUSH PRIVILEGES;

quit;

 

Do you think something is wrong with my install...?

 

Ok I'll try again

 

hi zustudios,
did you get it working again? i recently failed when changing the hostname.

 

No. I still have the same error and when I changed my ips it doesn't update. I'm having two update errors. When Softaculous checks my install they always say I have missing packages or extensions not activated. My sites work just not the second server. Both servers show up fine. I just can't get rid of those errors.

 

Thank you for your detailed explanation. I understand a lot better. I will try again.

 

That was probably me. We did that. server.sh went without errors but jobqueue did not get processed. We found some other database entries (not ony the users) that have the hostname hardcoded as well ... after that we gave up.