Not adopting changes, datalog_status_u: 4

Discussion in 'General' started by jimpanse, Dec 22, 2016.

  1. jimpanse

    jimpanse New Member

    Hi Folks,
    red badge in ISPConfig 3.1.1.p1 is saying that there are 4 changes not adopted by all servers with the message:
    datalog_status_u_server: 4
    Added a new website, a new database and a new ftp user for a client.
    Not getting behind what is actually stuck here.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. jimpanse

    jimpanse New Member

    Hmmm... set log level to debug, uncommented the cron job and ran it manually. All i got back was following:
    Code:
    23.12.2016-08:47 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    23.12.2016-08:47 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.
    
    The output of the htf Script is as follows:

    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    IP-address(es) (as per ifconfig): ***.***.***.***
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.1p1
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 5.6.29-0+deb8u1
    [INFO] php-cgi (used for cgi php in default vhost!) is version 5.6.29-0+deb8u1
    
    ##### PORT CHECK #####
    
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [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 connections 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) connections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 29422)
    [INFO] I found the following mail server(s):
            Postfix (PID 1892)
    [INFO] I found the following pop3 server(s):
            Courier Mailserver (PID 913)
    [INFO] I found the following imap server(s):
            Courier Mailserver (PID 894)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 1849)
    
    ##### LISTENING PORTS #####
    Server)         ()
    Local           (Address)
    [localhost]:8999                (1540/php-fpm.conf))
    [localhost]:10024               (1633/amavisd-new)
    [localhost]:10025               (1892/master)
    [anywhere]:3306         (1496/mysqld)
    [localhost]:10026               (1633/amavisd-new)
    [localhost]:10027               (1892/master)
    [anywhere]:111          (609/rpcbind)
    [anywhere]:8080         (29422/apache2)
    [anywhere]:80           (29422/apache2)
    [anywhere]:8081         (29422/apache2)
    [anywhere]:53905                (666/rpc.statd)
    [anywhere]:21           (1849/pure-ftpd)
    ***.***.***.***:53              (761/named)
    [localhost]:53          (761/named)
    [anywhere]:22           (759/sshd)
    [anywhere]:3000         (1533/ntop)
    [anywhere]:25           (1892/master)
    [localhost]:953         (761/named)
    [anywhere]:443          (29422/apache2)
    *:*:*:*::*:44192                (666/rpc.statd)
    *:*:*:*::*:993          (891/couriertcpd)
    *:*:*:*::*:995          (922/couriertcpd)
    [localhost]10           (913/couriertcpd)
    [localhost]43           (894/couriertcpd)
    [localhost]11           (609/rpcbind)
    *:*:*:*::*:21           (1849/pure-ftpd)
    *:*:*:*::*:53           (761/named)
    *:*:*:*::*:22           (759/sshd)
    *:*:*:*::*:25           (1892/master)
    
    
    
    
    ##### 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
    
    Do not care about the warning errors regarding email cause eMail is not used nor reachable from the outside to this server.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Is this a multiservers etup? If yes, did you run the script on the right server?
     
  5. jimpanse

    jimpanse New Member

    It is a two node setup yes, i ran the script on the host which is not the mirror of the other one yeah.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Then run it on the other node as the problem is not on the node where you executed it.
     
  7. jimpanse

    jimpanse New Member

    Seems that there is a mysql connection error from Host B to Host A, getting this errors if i try to run the server.sh.

    Code:
    PHP Warning:  mysqli_connect(): (HY000/2003): Can't connect to MySQL server on 'xxxxxxx' (110) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    
    If i try to connect with mysql client from Host B to Host A i am getting a timeout. Server is accessible otherwise from the other side (ssh, web, ping, nslookup resolves correclty etc.)

    MySQL Server is running on both servers. Replication is also working according to show slave status and show master status.

    Thought that maybe there is a grant issue cause mysql servers are both listening on 0.0.0.0:3306 and iptables is not blocking it.

    A SHOW GRANTS gives me following:
    Code:
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'SOMEHASH' WITH GRANT OPTION 
    
    Tried to set a grant on both servers with each other servers IP adress instead of localhost using the following:

    Code:
    On server BBB.BBB.BBB.BBB
    GRANT ALL ON *.* TO 'root'@'AAA.AAA.AAA.AAA' IDENTIFIED BY 'SPECIALPASSWORD' WITH GRANT OPTION;
    
    On Server AAA.AAA.AAA.AAA
    GRANT ALL ON *.* TO 'root'@'BBB.BBB.BBB.BBB' IDENTIFIED BY 'SPECIALPASSWORD' WITH GRANT OPTION;
    
    MySQL tells me

    Code:
    Query OK, 0 rows affected (0.01 sec)
    
    and if i do a FLUSH PRIVILEGES; and a SHOW GRANTS; again i get again
    Code:
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'SOMEHASH' WITH GRANT OPTION 
    
    What am i doing wrong?

    Code:
    HTS Script from Mirror Node
    
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    IP-address(es) (as per ifconfig): ***.***.***.***
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.1p1
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 5.6.29-0+deb8u1
    [INFO] php-cgi (used for cgi php in default vhost!) is version 5.6.29-0+deb8u1
    
    ##### PORT CHECK #####
    
    [WARN] Port 8080 (ISPConfig) seems NOT to be listening
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [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 connections 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) connections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 7811)
    [INFO] I found the following mail server(s):
            Postfix (PID 7419)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 733)
    [INFO] I found the following imap server(s):
            Unknown process (init) (PID 1)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 1569)
    
    ##### LISTENING PORTS #####
    Server)         ()
    Local           (Address)
    [anywhere]:22           (714/sshd)
    [anywhere]:25           (7419/master)
    [localhost]:953         (717/named)
    [anywhere]:443          (7811/apache2)
    [anywhere]:993          (1/init)
    [anywhere]:995          (733/dovecot)
    [localhost]:10024               (1422/amavisd-new)
    [localhost]:10025               (7419/master)
    [anywhere]:3306         (1355/mysqld)
    [localhost]:10026               (1422/amavisd-new)
    [localhost]:10027               (7419/master)
    [anywhere]:110          (733/dovecot)
    [anywhere]:143          (1/init)
    [anywhere]:80           (7811/apache2)
    [anywhere]:8081         (7811/apache2)
    ***.***.***.***:53              (717/named)
    [anywhere]:21           (1569/pure-ftpd)
    [localhost]:53          (717/named)
    *:*:*:*::*:22           (714/sshd)
    *:*:*:*::*:25           (7419/master)
    *:*:*:*::*:993          (1/init)
    *:*:*:*::*:995          (733/dovecot)
    [localhost]10           (733/dovecot)
    [localhost]43           (1/init)
    *:*:*:*::*:21           (1569/pure-ftpd)
    *:*:*:*::*:53           (717/named)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    fail2ban-dovecot-pop3imap  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 110,995,143,993
    fail2ban-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 21
    fail2ban-ssh  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 22
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination
    
    Chain fail2ban-dovecot-pop3imap (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-pureftpd (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-ssh (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    
     
  8. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    can you connect to the remote sql-server with the credentials from /usr/local/ispconfig/server/lib/mysql_clientdb.conf? Maybe your are blocking port 3306 in the firewall.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig uses the ispcsrv* user that you can find in the file /usr/local/ispconfig/server/lib/config.inc.php on the slave to connect to the master server

    Get the username, hostname and password from that file and test the connection with the mysql command.
     
  10. jimpanse

    jimpanse New Member

    Jesus... i've had a false entry in my /etc/hosts file, fqdn of first server did resolve to the load balancer ip and not to the first server instance, using ispcsrv2 user with IP of "master server" did work, changed /etc/hosts now everything seems to work.
    Thank you guys, and merry christmans and a happy new year.

    Dankeschön und ein Frohes Fest und ein schönes neues Jahr falls man sich nicht mehr liest.
    Und danke für den fixen Service jungs. Spitzenklasse.
     
    till likes this.

Share This Page