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 ?
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.
@till Thanks for the reply . ( I use apache ) Expand: Error.log [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
@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 ) Expand: Error of restart root@server1:~# /etc/init.d/mariadb stop bash: /etc/init.d/mariadb: No such file or directory root@server1:~# systemctl stop mysql.service root@server1:~# systemctl stop mysql root@server1:~# 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. root@server1:~# 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. root@server1:~# service mariadb restart Failed to restart mariadb.service: Unit mariadb.service not found.
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.
