The ISPConfig interface is not accessible with 500 internal error

Discussion in 'Installation/Configuration' started by thioky, Oct 15, 2019.

  1. thioky

    thioky New Member

    Hello everyone, i have a 500 error with ISPConfig, the ISPConfig interface is not accessible but other sites work well. Here is the log :
    Code:
    [Tue Oct 15 15:22:37.457729 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: PHP Warning:  mysqli_real_connect(): (HY000/2002): Permission denied in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 85
    [Tue Oct 15 15:22:37.457793 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: PHP Warning:  mysqli_real_connect(): (HY000/2002): Permission denied in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Tue Oct 15 15:22:37.457918 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: PHP Fatal error:  Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Tue Oct 15 15:22:37.457926 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: Stack trace:
    [Tue Oct 15 15:22:37.457933 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Tue Oct 15 15:22:37.457941 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(381): app->initialize_session()
    [Tue Oct 15 15:22:37.457949 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Tue Oct 15 15:22:37.457957 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr: #3 {main}
    [Tue Oct 15 15:22:37.457965 2019] [fcgid:warn] [pid 20072:tid 140601752266496] [client 154.125.214.220:57637] mod_fcgid: stderr:   thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166
    
    Thank you in advance
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if you replaced PHP on your server and the new php lacks mysql support.
     
  4. thioky

    thioky New Member

    Ah how to check that? Knowing that i activated php7.2-fpm this morning. I had to add it for my other sites but now ISPConfig is not working.
    Regards
     
  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  6. thioky

    thioky New Member

    Thank you, I have one warning and no error, here is the warning:
    ##### SERVER #####
    IP-address (as per hostname): ***. ***. ***. ***
    [WARN] could not determine server's ip address by ifconfig
     
  7. thioky

    thioky New Member

    I have this at ports level:
    Code:
    [localhost]:3306       (370/mysqld)
    [localhost]:10026       (732/amavisd-new)
    [localhost]:10027       (529/master)
    [anywhere]:587       (529/master)
    [localhost]:11211       (158/memcached)
    [localhost]10       (201/dovecot)
    [localhost]43       (201/dovecot)
    *:*:*:*::*:80       (27387/apache2)
    *:*:*:*::*:8080       (27387/apache2)
    
    Is this normal asterisks at the port: 8080 ?
     
  8. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Seems you refuse to reveal the information needed to give you help.
    Then do it the hard way:
    • Replace default PHP version to the original that comes with your operating system
     
  9. thioky

    thioky New Member

    Same error when replace default PHP version.
     
  10. Steini86

    Steini86 Active Member

    No, that is apache2 on that port. That is correct, it serves the ispconfig page.

    The provided information is not enough to help you.
    - Distribution (Debian/CentOS?)
    - PHP version
    - PHP modules
    - ISPconfig Version

    This information, you can find in the report, which you looked at but don't want to share with us ...

    Basically, ispconfig cannot connect to the database. Possible causes:
    - MYSQL server is not running
    - MYSQL server is not listening
    - MYSQL password is wrong
    - PHP is not allowed to connect to MYSQL server (restrictions, e.g. SELinux)
    - PHP is not able (no module) to connect to MYSQL server
    ...

    Have you done any other changes than switching the PHP version?
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    Use the perfect server guide to install the original PHP version with all its modules and next time be more careful, there are tutorials available here at howtoforge on how to install additional PHP versions correctly and how to switch back the default version to the original version when using PHP packages from e.g. sury.org.
     

Share This Page