One of my nameservers is stuck in Update after I changed the ip adderss of the server and now it won't complete and not sure where to stqart looking. I ran the first command in crontab: /usr/local/ispconfig/server/server.sh and got the following: PHP: 06:52 - WARNING - There is already an instance of server.php running with pid 24963.Mon Apr 26 05:52:02 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80Mon Apr 26 05:52:02 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83Mon Apr 26 05:52:05 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83Mon Apr 26 05:52:08 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83Mon Apr 26 05:52:11 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83Mon Apr 26 05:52:15 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198Mon Apr 26 05:52:16 EST 2021 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 196Mon Apr 26 05:52:30 EST 2021 PHP Warning: mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198Mon Apr 26 05:52:31 EST 2021 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 196 What should I do first? Can I cancel the update? What file is it? Thanks!
Check that mysql / mariadb is started on the local server and check that you are able to log into MySQL from slave system to the master server e.g.by using MySQL command. Example: MySQL -h master.server.tld -u ispcsrv1 -p the hostname, ispcsrv user and password must match the data from /usr/local/ispconfig/server/lib/config.inc.php file.
Till, Forgot I had set up fw acl to secure which IP's can access my cp server port 3306. My vendor renumbered their IP ranges and I got new IP's and I had to update the acl. Thanks for tip on quick access tip using: MySQL -h master.server.tld -u ispcsrv1 -p
