DNS Records not being synced to slave DNS server: datalog_status_u_server: 1

Discussion in 'ISPConfig 3 Priority Support' started by Kevin S, May 21, 2020.

  1. Kevin S

    Kevin S New Member

    I have set up two servers. One master and second one slave. As per the configuration, the DNS zones created at the Master server should automatically be synced to the slave server but that is not happening and it throws datalog_status_u_server: 1 error.

    Code:
    /usr/local/ispconfig/server/server.sh
    Throws below error

    Code:
    21.05.2020-16:30 - WARNING - There is already an instance of server.php running with pid 17871.
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Database connection failedPHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Database connection failedPHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Database connection failedPHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Database connection failedPHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'2400:6180:0:d0::90c:5001' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Database connection failedZugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!root@slave
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That#s an installation error, most likely the /etc/hosts records on both servers do not contain the hostnames of both nodes or you entered an IP address for the master server when the installer asked for the hostname of the master server, entering an Ip will not work and the system will not be able to sync afterwards. Check the hosts files and correct them if needed and then check /usr/local/ispconfig/server/lib/config.inc.php if the master server hostname that is set there is really the hostname and not an IP address and fix that if needed. Afterwards, run an ispconfig update on the slave server and choose to reconfigure permissions in master database.
     
  3. Kevin S

    Kevin S New Member

    @till

    Thank a lot. I added both the host details to /etc/hosts and also checked the /usr/local/ispconfig/server/lib/config.inc.php file and it does contain master server details. Now do I need to run ispconfig_update.sh ?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Normally yes, but as you run already the current version, it won't work. Instead, use these commands:

    Code:
    cd /tmp
    wget https://www.ispconfig.org/downloads/ISPConfig-3.1.15p3.tar.gz
    tar xvfz ISPConfig-3.1.15p3.tar.gz
    cd ispconfig3_install/install
    php -q update.php
     

Share This Page