Second dns server not updating

Discussion in 'Installation/Configuration' started by zustudios, Jan 21, 2018.

  1. zustudios

    zustudios Member

    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

    [email protected]:~# 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).

    [email protected]:~# 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


    [email protected]:~# 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).

    [email protected]:~# 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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. zustudios

    zustudios Member

    How do I fix it?
    [email protected]:~# crontab -e
    crontab: installing new crontab
    [email protected]:~# /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 [email protected]:~#
     
  4. zustudios

    zustudios Member

    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.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely you did not set the hostnames consistently on all servers as described in the Debian guide, so that a wrong hostname is used now for the ispcsrv* user in the mysql database on the master.
     
  6. zustudios

    zustudios Member

    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?
     
  7. Taleman

    Taleman Active Member HowtoForge Supporter

    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.
     
  8. zustudios

    zustudios Member

    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.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Then your purchase must have been many years ago, the guides in the current manual are for Debian 8 and not Debian 6.
     
  10. zustudios

    zustudios Member

    Ok Thank you.
     
  11. zustudios

    zustudios Member

    [email protected]:~# /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.
    [email protected]:~#
     
  12. zustudios

    zustudios Member

    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;
     
  13. zustudios

    zustudios Member

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

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig does not use the root user to connect from slave to master, it uses the ispcsrv* user., see my post #5. The root user is only used during installation and update. You have to adjust the hostname of the server or the hostname part of the ispcsrv2 user to match your real setup to get it working.
     
  15. zustudios

    zustudios Member

    Ok I'll try again
     
  16. Rabenkind

    Rabenkind Member

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

    zustudios Member

    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.
     
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    The guy's from Softaculous are no experts for ISPConfig systems, so I doubt that they are able to help you with such a problem. If you need help by remote login for an ISPConfig problem, then better contact Florian from Schaal @IT as he is familar with ISPConfig and multiserver setups: https://www.ispconfig.org/get-support/?type=ispconfig

    Back to the original problem: The connection between slave and master servers is really simple and easy to debug. On the master server, there are two ispcsrv* users in mysql for each slave node, one for the IP address and one for the hostname of the server. * in this case is the ID of the server. The slave server connects with the login credentials of this user from slave to master and when a slave is unable to fetch changes, then most likely this connection is broken. You can find the exact details to test the connection in the config.inc.php file from ISPconfig on the slave. To test the connection, use the mysql command. example:

    mysql -h master.host.name -u ispcsrv2 -p dbispconfig

    and to test the IP user, use:

    mysql -h 1.2.3.4 -u ispcsrv2 -p dbispconfig

    where 1.2.3.4 is the IP of the master. The commands will ask for the password, which you can find in the config.inc.php file.

    And as someone asked how to change the hostname, this is pretty easy on Linux and not ISPConfig specific:
    Change the hostname in /etc/hostname, /etc/hosts and /etc/hostname and restart the server. The only ISPConfig specific part is that you have to change the hostname of the ispcsrv* user of that node in MySQL on the master as well, this can be done e.g. with the user editor in phpmyadmin.
     
    Last edited: Feb 22, 2018
  19. zustudios

    zustudios Member

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

    Rabenkind Member

    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.
     

Share This Page