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
That's only a small part of the settings of a MySQL user, MySQL users can consist of records in many different tables. Do not edit it in the user table directly, use e.g. the user editor in phpmyadmin to change the IP as it will correctly change all related tables. So the best is, you undo your change in the user table, and then change it again, but this time use the MySQL user editor in phpmyadmin and then flush privileges. In addition to that, don't forget to change the hosts file on master and slave server.
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.
The server for which you showed debug output doesn't think it has any jobs stuck. Maybe you have a mixup in server ids (eg. jobs queued for a server which no longer exists?) or inconsistency in the server.updated counter (so the server is looking for a job with a higher id number and ignores the existing jobs). Examine the sys_datalog table (on your master server) to verify the server id and compare datalog_id to the server.updated counter for mx1.
