Hi, I try to access my server today, but it was not possible at the first try. After several attempts It worked, and the php-error.log has a lot of this lines
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(75): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 286
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 111
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 112
[02-Sep-2022 01:53:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 122
[02-Sep-2022 01:53:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 131
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 286
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[02-Sep-2022 01:53:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 111
My virtual server
KVM Virtual system (VPS)
KeyHelp 22.2
Debian 11.5 (64-bit)
MariaDB 10.5.15
Apache 2.4.54
PHP 7.4.30
Hi, again happend . I try to access my server today, but it was not possible because the MariaDB was down, and the php-error.log has a lot of this lines
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:45:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:45:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:45:04 America/New_York] PHP Notice: Undefined index: version in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 426
[04-Nov-2022 07:45:04 America/New_York] PHP Warning: Database error: SQLSTATE[HY000] [2002] Connection refused in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 490
[04-Nov-2022 07:45:04 America/New_York] PHP Fatal error: Uncaught Error: Call to a member function prepare() on null in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php:244
Stack trace:
#0 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(334): DatabaseConnection->query()
#1 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(604): DatabaseConnection->fetchColumn()
#2 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(172): DatabaseConnection->loadServerInformation()
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(50): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:01 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:02 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:46:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:46:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:46:04 America/New_York] PHP Notice: Undefined index: version in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 426
[04-Nov-2022 07:46:04 America/New_York] PHP Warning: Database error: SQLSTATE[HY000] [2002] Connection refused in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 490
[04-Nov-2022 07:46:04 America/New_York] PHP Fatal error: Uncaught Error: Call to a member function prepare() on null in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php:244
Stack trace:
#0 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(334): DatabaseConnection->query()
#1 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(604): DatabaseConnection->fetchColumn()
#2 /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php(172): DatabaseConnection->loadServerInformation()
#3 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(50): DatabaseConnection->__construct()
#4 {main}
thrown in /home/keyhelp/www/keyhelp/core/Database/DatabaseConnection.php on line 244
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:47:02 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:47:03 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[04-Nov-2022 07:47:03 America/New_York] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[04-Nov-2022 07:47:04 America/New_York] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[04-Nov-2022 07:47:04 America/New_York] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
My virtual server
KVM Virtual system (VPS)
KeyHelp 22.2
Debian 11.5 (64-bit)
MariaDB 10.5.15
Apache 2.4.54
PHP 7.4.30
Domains: 5
check the logs of the mysql server and dmsg. Maybe the MySQL was killed by the OOM killer. Run mysqltuner to see if the settings of your MySQL server are OK.
But this is no Keyhelp related error.
Mit freundlichen Grüßen / Best regards
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
24unix, thanks for you response, Indeed I can connect without problems with the credentials.
The problem is that sometimes the Mysql goes down and I don't understand the reason.
I can't find the mysql server log (/var/log/mysql/ --> doesn't show anything), Where can I find this log file?
by the way, the dmesg command does not show anything related to mysql