[SOLVED] Error : Database connection failed / Database server not accessible!

Hello HTF friends,

Setup : Multi-server
OS : Ubuntu 20.04
Server type : Nginx
Databse : mySql

Slave mail server

I have been fighting with my mail server, trying to solve the issue. Searching only lead me to some who reinstalled or restore a backup. I have tested the ispconfig@localhost account. Able to login to MySQL with ispconfig user, i am also able to login to the master server with the data from /usr/local/ispconfig/interface/lib/config.inc.php

I put the server in debug mode; disabled the server.php cron. Running the script manually produces the following :

Code:

 WARNING - There is already a lockfile set, but no process running with this pid (2806). Continuing.
Database connection failed Database connection failed Database connection failed Database connection failed ^XDatabase connection failed Zugriff 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

Can't seem to trace the error back to anything else

 

Correct, but not the standard connection data. I used the data from "master_db_user", "master_db_pass", can't remember the exact variable names. After re-running the "ispconfig_update.sh" script, i got the error of unknown database authentication method. I thought the server was 20.04 but was actually 18.04 (got mixed up with another server) so i had to alter the default authentication method of the master server MySQL to "mysql_native_password". This probably wouldn't be necessary if i first updated the OS.