Can't log into the panel

Discussion in 'Installation/Configuration' started by Akhilleus, Aug 2, 2019.

  1. Akhilleus

    Akhilleus Member

    Hello

    When I type https://MyIP:8080 , the site gives me ERROR 500 ( after loading 30s or so )
    The same problem on my sites , I by default the maintenance page when the server is down
    Where can I see the log files with the errors , so I can fix this ?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    When you use apache, then take a look at the apache error.log. When you use nginx, look into the nginx error.log. and for the sites. look into the website error log files.
     
  3. Akhilleus

    Akhilleus Member

    @till Thanks for the reply . ( I use apache )

    [Fri Aug 02 19:09:26.814302 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814306 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814310 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814314 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 85
    [Fri Aug 02 19:09:26.814318 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814322 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814325 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814343 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814346 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 91
    [Fri Aug 02 19:09:26.814350 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] 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
    [Fri Aug 02 19:09:26.814353 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: Stack trace:
    [Fri Aug 02 19:09:26.814356 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Fri Aug 02 19:09:26.814359 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(381): app->initialize_session()
    [Fri Aug 02 19:09:26.814362 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Fri Aug 02 19:09:26.814366 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: #3 {main}
    [Fri Aug 02 19:09:26.814369 2019] [fcgid:warn] [pid 869] [client xxx.xxx.xxx.xxx:52777] mod_fcgid: stderr: thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166

    Anyway to fix the DB ? Looks like after I rebooted the server this happens
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Restart mysql (or mariadb) and check if it starts. Did you install a different PGP version recently?
     
  5. Akhilleus

    Akhilleus Member

    @till I have used this command line , knowing it's not the right thing to do . But I was hoping that the server just show , nothing to update in case everything is already installed :
    Code:
    sudo apt-get install apache2 php libapache2-mod-php php-mysql php-curl php-gd php-intl mysql-server mysql-client ffmpeg git libimage-exiftool-perl php-mbstring php-gettext python
    Trying to restart MariaDB ( looks like I don't have it anymore , but I remember that I have installed it on the ISPConfig installation )
    [email protected]:~# /etc/init.d/mariadb stop
    bash: /etc/init.d/mariadb: No such file or directory
    [email protected]:~# systemctl stop mysql.service
    [email protected]:~# systemctl stop mysql
    [email protected]:~# service mysql restart
    Job for mysql.service failed because the control process exited with error code.
    See "systemctl status mysql.service" and "journalctl -xe" for details.
    [email protected]:~# systemctl status mysql.service
    ‚óŹ mysql.service - MySQL Community Server
    Loaded: loaded (/lib/systemd/system/mysql.service; bad; vendor preset: enabled)
    Active: failed (Result: exit-code) since Fri 2019-08-02 19:29:12 EEST; 8s ago
    Process: 7946 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Control process exited, code=exited status=1
    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Aug 02 19:29:12 server1 systemd[1]: Failed to start MySQL Community Server.
    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
    Aug 02 19:29:12 server1 systemd[1]: Stopped MySQL Community Server.
    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Start request repeated too quickly.
    Aug 02 19:29:12 server1 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Aug 02 19:29:12 server1 systemd[1]: Failed to start MySQL Community Server.
    [email protected]:~# service mariadb restart
    Failed to restart mariadb.service: Unit mariadb.service not found.
     
  6. Akhilleus

    Akhilleus Member

    anyone any idea ?
     
  7. ahrasis

    ahrasis Well-Known Member

    It seems like you do not have mysql or mariadb installed. Do try to reinstall it.

    In most case we use mariadb, so run apt-get -y install mariadb-server and see what happens when you restart all relevant services.
     

Share This Page