ispcsrv failed connections to MySQL database

Hi everyone,
I'm having a hard time solving this error after running php -q update.php. One of the dedicated slaves run into hardware error and I had to reinstall ISPConfig 3.1.15p3 on Ubuntu 18.04.5. I have tried to manually update the authentication string using the string from /usr/local/ispconfig/server/lib/config.inc.php for the respective slave on phpmyadmin on the master database but alas. Any help/pointers would be highly appreciated.

Code:

root@mail-20:~# /usr/local/ispconfig/server/server.sh
10.04.2021-22:47 - WARNING - There is already a lockfile set, but no process running with this pid (23967). Continuing.
PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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!PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on boolean in /usr/local/ispconfig/server/server.php:64
Stack trace:
#0 {main}
  thrown in /usr/local/ispconfig/server/server.php on line 64
PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv2'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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'@'mail-20.srv.mtn.co.ug' (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@mail-20:~#

 

I decided to uninstall and reinstall ISPConfig. Managed to clear those errors. Server is now able to send mail but not able to receive mail so I'll post another thread for that.

 

Hello everyone,
I'm facing the same issue after having changed the IP address of a slave server :

Code:

[root@mx1 ~]# /usr/local/ispconfig/server/server.sh
PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv10'@'ip247.ip-X-X-X.eu' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85

I have already changed the IP in the "user" table for the user ispcsrv10 on the master server.
Any help would be highly appreciated

 

Thank you Till, it worked I don't have the errors anymore, but my changes in queue on the master are still stuck.

 

Follow instructions in
https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
Especially the part about "not writing changes to disk".

 

Hello Taleman,
Thank you for your answer, I followed your instructions but it doesn't fix the problem :

Code:

[root@mx1 ~]# /usr/local/ispconfig/server/server.sh
14.11.2021-22:15 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
14.11.2021-22:15 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished server.php.

 

Did you run the server.sh on the slave that has the job items stuck in the queue?

 

Yes mx1 is the slave server where the 7 jobs are stuck.