ISPconfig on different MySQL server

Hello All,

I installed ISPconfig on dedicated server without MySQL service.
For MySQL i have dedicated 3 nodes (Gallera cluster).
Problem is when i open panel it is very slow (looks like many loop by rewrite) and sometimes panel open with when i can login.
I can't login.
I checked databases and i see there dbispconfig with tables.
PHP logs informed me:

Code:

[Thu Jun 20 18:08:50.177402 2019] [fcgid:warn] [pid 14449] [client x.x.x.x:56876] mod_fcgid: stderr: PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 242
[Thu Jun 20 18:08:50.177417 2019] [fcgid:warn] [pid 14449] [client x.x.x.x:56876] mod_fcgid: stderr: PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispconfig'@'X.X.X.Y' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 244
[Thu Jun 20 18:08:50.177402 2019] [fcgid:warn] [pid 14449] [client x.x.x.x:56876] mod_fcgid: stderr: PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 242
[Thu Jun 20 18:08:50.177417 2019] [fcgid:warn] [pid 14449] [client x.x.x.x:56876] mod_fcgid: stderr: PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispconfig'@'X.X.X.Y' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 244

Ip X.X.X.Y is for IPSConfig server. I think that it try to connect to local database (I don't have local database).
In /usr/local/ispconfig/server/lib/mysql_clientdb.conf is right addres for database server Y.Y.Y.Y

ISPconfig server:
9 (stretch)
PHP 7.0.33

I can temporary install proxy to move traffic from port 3306 to Galera CLuster but this is not the case.

Do you have any suggestion ?

Best regards,
Gofni

 

Hi Till,

I checked /usr/local/ispconfig/interface/lib/config.inc.php and there are right ip address of mysql server (Y.Y.Y.Y).

Do you have any other idea ?

Best regards,

 

ISPConfig would prefer for its database to be on the same server, but I think it should work fine with external database. At least it works during my test some times ago. Check if you have set database properly during ISPConfig installation via the said config file. Proper access should also be given to / from both servers.