ISPconfig on different MySQL server

Discussion in 'Installation/Configuration' started by Gofni, Jun 20, 2019.

  1. Gofni

    Gofni New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This file is not used by the interface. The interface uses the connection from /usr/local/ispconfig/interface/lib/config.inc.php
     
  3. Gofni

    Gofni New Member

    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,
     
  4. ahrasis

    ahrasis Well-Known Member

    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.
     

Share This Page