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.
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.
It is a two node setup yes, i ran the script on the host which is not the mirror of the other one yeah.
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
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.
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.
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.
