Das Server Control Panel wird derzeit aktualisiert - 2  [GELÖST]

Haben Sie einen Bug entdeckt? Teilen Sie es uns mit.
Post Reply
User avatar
topolino
Posts: 45
Joined: Fri 4. Dec 2020, 12:57

Das Server Control Panel wird derzeit aktualisiert - 2

Post by topolino »

Ich bin sicher, dass die Ursache des Problems bei KeyHelp liegt
Server-Betriebssystem + Version: debian 12 aktuellste Versionen
Eingesetzte Server-Virtualisierung-Technologie: VMWare
KeyHelp-Version + Build-Nummer: aktuellste Version
Problembeschreibung / Fehlermeldungen
Ich habe im Forum den Beitrag mit dem gleichen Betreff gefunden und versucht, die Anleitung umzusetzen. Leider ohne Erfolg.

Erwartetes Ergebnis
Leider zeigt es mir nach wie vor die Meldung an:

Code: Select all

Das Server Control Panel wird derzeit aktualisiert
Zusätzliche Informationen
Zwischenzeitlich habe ich festgestellt, dass der Speicher langsam eng wurde (bis ca. 97 %).
Dieses Problem habe ich gelöst. Nun ist die Auslastung bei 72%.

Auszüge aus Protokolldateien:
php-error.log
Letzte Zeilen:

Code: Select all

[10-Feb-2024 06:58:20 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Feb-2024 06:58:21 UTC] PHP Warning:  file_put_contents(/etc/rspamd/local.d/dkim_signing.conf): Failed to open stream: Datei oder Verzeichnis nicht gefunden in /home/keyhelp/www/keyhelp/core-ns/Utilities/FileAccess.php on line 335
[10-Feb-2024 06:58:21 UTC] PHP Fatal error:  Uncaught Error: Class "Cli" not found in /home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php:1551
Stack trace:
#0 /home/keyhelp/www/keyhelp/cronjob/jobs/panel_update.php(460): unknown()
#1 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(443): unknown()
#2 {main}
  thrown in /home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php on line 1551

panel-update.log
Nur Zeilen mit 'INFO' gefunden:

Code: Select all

[10-Feb-2024 07:01:02] INFO | maintenance log okay
[10-Feb-2024 07:01:02] INFO | trying to connect to updateserver
[10-Feb-2024 07:01:02] INFO | set correct tmp-directories mount for update
[10-Feb-2024 07:01:42] INFO | new version detected - starting update process from "23.2.1" to "24.0"
[10-Feb-2024 07:01:42] INFO | first update step: "24.0" | total steps to reach latest version: 
[10-Feb-2024 07:01:42] INFO | create folder for panel update "/home/keyhelp/www/keyhelp_tmp/"
[10-Feb-2024 07:01:42] INFO | start download of "https://install.keyhelp.de/files/releases/24.0/24.0-php82.tar.gz"
[10-Feb-2024 07:01:44] INFO | file saved to "/home/keyhelp/www/keyhelp_tmp/24.0.tar.gz"
[10-Feb-2024 07:01:44] INFO | checksum check successful
[10-Feb-2024 07:01:44] INFO | lock panel
[10-Feb-2024 07:01:44] INFO | log out all users
[10-Feb-2024 07:01:44] INFO | run --force-update one last time before new files and db structure may change things
[10-Feb-2024 07:01:47] INFO | checking running maintenance intervals ...
[10-Feb-2024 07:01:47] INFO | all maintenance intervals finished, so we can go on
[10-Feb-2024 07:01:48] INFO | archive extraction finished
[10-Feb-2024 07:01:48] INFO | changed owner of "/home/keyhelp/www/keyhelp_tmp/" to "keyhelp"
[10-Feb-2024 07:01:48] INFO | Setup backup directory "/home/keyhelp/keyhelp.backup/panel_updates"
[10-Feb-2024 07:01:49] INFO | Database backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-10_07-01-48.sql"
[10-Feb-2024 07:01:54] INFO | File backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-10_07-01-48.tar.gz"
[10-Feb-2024 07:01:55] INFO | remove old keyhelp folder
[10-Feb-2024 07:01:58] INFO | copy from "/home/keyhelp/www/keyhelp_tmp/" to "/home/keyhelp/www/keyhelp/" 
[10-Feb-2024 07:01:59] INFO | remove "/home/keyhelp/www/keyhelp_tmp/"
[10-Feb-2024 07:02:00] INFO | run update file "/home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php"
[10-Feb-2024 07:02:00] INFO | [database] update length of key and regular fields
[10-Feb-2024 07:02:00] INFO | [database] update charset and collate for all KeyHelp tables
[10-Feb-2024 07:02:04] INFO | [database] update structure of `mail_users`
[10-Feb-2024 07:02:04] INFO | [database] update structure of `mail_aliases`
[10-Feb-2024 07:02:16] INFO | [database] update structure of `users_password_change_requests`
[10-Feb-2024 07:02:16] INFO | [database] update structure of `databases`
[10-Feb-2024 07:02:16] INFO | [database] update structure of `ftp_users`
[10-Feb-2024 07:02:16] INFO | [database] update structure of `ftp_users`
[10-Feb-2024 07:02:16] INFO | [database] update structure of `php_settings`
[10-Feb-2024 07:02:19] INFO | [awstats] add database flag for DNS lookup
[10-Feb-2024 07:02:19] INFO | [domains] add traffic / month feature
[10-Feb-2024 07:02:22] INFO | [white_label] update field names
[10-Feb-2024 07:02:22] INFO | [database] rename table `mail_aliases` -> `mail_routing`
[10-Feb-2024 07:02:25] INFO | [postfix] rename table `mail_aliases` -> `mail_routing`
[10-Feb-2024 07:02:27] INFO | [rspamd] move DKIM paths
====
[10-Feb-2024 07:03:02] INFO | maintenance log okay
[10-Feb-2024 07:03:02] INFO | trying to connect to updateserver
[10-Feb-2024 07:03:03] INFO | set correct tmp-directories mount for update
Mit freundlichen Grüssen / Best regards
Walter Richner

**************************************************************
OEKOMATIK - EDV Richner
Reitibuechstrasse 16 - CH-5636 Benzenschwil
https://www.oekomatik.ch
**************************************************************
User avatar
topolino
Posts: 45
Joined: Fri 4. Dec 2020, 12:57

Re: Das Server Control Panel wird derzeit aktualisiert - 2

Post by topolino »

Weitere Analysen haben ergeben:
  • Das Problem begann während dem automatischen Update auf die Version 24.0
  • Seither läuft der Updateprozesse immer wieder von vorne durch, macht aber wegen Fehlern nicht fertig.
  • Im Verzeichnis /home/keyhelp/.lock ist nur der Prozess panel-update.lock ausgewiesen
Die aktuellsten Fehlermeldungen in der Datei php-error.log

Code: Select all

[11-Feb-2024 09:37:03 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:04 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:05 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:05 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:06 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:07 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:08 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:08 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:09 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:10 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:11 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:11 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:12 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:13 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:14 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:14 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:15 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:16 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:17 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:17 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:18 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:19 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:20 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:20 UTC] PHP Warning:  MySQL - Query Error: Can't DROP INDEX `id_user_2`; check that it exists (1091) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:21 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:22 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:23 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:23 UTC] PHP Warning:  MySQL - Query Error: Duplicate column name 'traffic' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:24 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:25 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:26 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[11-Feb-2024 09:37:26 UTC] PHP Warning:  MySQL - Query Error: Table 'keyhelp.mail_aliases' doesn't exist (1146) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[11-Feb-2024 09:37:27 UTC] PHP Warning:  file_put_contents(/etc/rspamd/local.d/dkim_signing.conf): Failed to open stream: Datei oder Verzeichnis nicht gefunden in /home/keyhelp/www/keyhelp/core-ns/Utilities/FileAccess.php on line 335
[11-Feb-2024 09:37:27 UTC] PHP Fatal error:  Uncaught Error: Class "Cli" not found in /home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php:1551
Stack trace:
#0 /home/keyhelp/www/keyhelp/cronjob/jobs/panel_update.php(460): unknown()
#1 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(443): unknown()
#2 {main}
  thrown in /home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php on line 1551

Und die Datei panel-update.log

Code: Select all

[11-Feb-2024 09:36:01] INFO | maintenance log okay
[11-Feb-2024 09:36:01] INFO | trying to connect to updateserver
[11-Feb-2024 09:36:02] INFO | set correct tmp-directories mount for update
[11-Feb-2024 09:36:42] INFO | new version detected - starting update process from "23.2.1" to "24.0"
[11-Feb-2024 09:36:42] INFO | first update step: "24.0" | total steps to reach latest version: 
[11-Feb-2024 09:36:42] INFO | create folder for panel update "/home/keyhelp/www/keyhelp_tmp/"
[11-Feb-2024 09:36:42] INFO | start download of "https://install.keyhelp.de/files/releases/24.0/24.0-php82.tar.gz"
[11-Feb-2024 09:36:51] INFO | file saved to "/home/keyhelp/www/keyhelp_tmp/24.0.tar.gz"
[11-Feb-2024 09:36:51] INFO | checksum check successful
[11-Feb-2024 09:36:51] INFO | lock panel
[11-Feb-2024 09:36:51] INFO | log out all users
[11-Feb-2024 09:36:51] INFO | run --force-update one last time before new files and db structure may change things
[11-Feb-2024 09:36:53] INFO | checking running maintenance intervals ...
[11-Feb-2024 09:36:53] INFO | all maintenance intervals finished, so we can go on
[11-Feb-2024 09:36:54] INFO | archive extraction finished
[11-Feb-2024 09:36:54] INFO | changed owner of "/home/keyhelp/www/keyhelp_tmp/" to "keyhelp"
[11-Feb-2024 09:36:54] INFO | Setup backup directory "/home/keyhelp/keyhelp.backup/panel_updates"
[11-Feb-2024 09:36:54] INFO | Database backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-11_09-36-54.sql"
[11-Feb-2024 09:36:57] INFO | File backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-11_09-36-54.tar.gz"
[11-Feb-2024 09:36:58] INFO | remove old keyhelp folder
[11-Feb-2024 09:37:00] INFO | copy from "/home/keyhelp/www/keyhelp_tmp/" to "/home/keyhelp/www/keyhelp/" 
[11-Feb-2024 09:37:01] INFO | remove "/home/keyhelp/www/keyhelp_tmp/"
[11-Feb-2024 09:37:02] INFO | run update file "/home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php"
[11-Feb-2024 09:37:02] INFO | [database] update length of key and regular fields
[11-Feb-2024 09:37:02] INFO | [database] update charset and collate for all KeyHelp tables
[11-Feb-2024 09:37:05] INFO | [database] update structure of `mail_users`
[11-Feb-2024 09:37:05] INFO | [database] update structure of `mail_aliases`
[11-Feb-2024 09:37:17] INFO | [database] update structure of `users_password_change_requests`
[11-Feb-2024 09:37:17] INFO | [database] update structure of `databases`
[11-Feb-2024 09:37:17] INFO | [database] update structure of `ftp_users`
[11-Feb-2024 09:37:17] INFO | [database] update structure of `ftp_users`
[11-Feb-2024 09:37:17] INFO | [database] update structure of `php_settings`
[11-Feb-2024 09:37:20] INFO | [awstats] add database flag for DNS lookup
[11-Feb-2024 09:37:20] INFO | [domains] add traffic / month feature
[11-Feb-2024 09:37:23] INFO | [white_label] update field names
[11-Feb-2024 09:37:23] INFO | [database] rename table `mail_aliases` -> `mail_routing`
[11-Feb-2024 09:37:26] INFO | [postfix] rename table `mail_aliases` -> `mail_routing`
[11-Feb-2024 09:37:27] INFO | [rspamd] move DKIM paths
====
[11-Feb-2024 09:38:02] INFO | maintenance log okay
[11-Feb-2024 09:38:02] INFO | trying to connect to updateserver
[11-Feb-2024 09:38:02] INFO | set correct tmp-directories mount for update
[11-Feb-2024 09:38:42] INFO | new version detected - starting update process from "23.2.1" to "24.0"
[11-Feb-2024 09:38:42] INFO | first update step: "24.0" | total steps to reach latest version: 
[11-Feb-2024 09:38:42] INFO | create folder for panel update "/home/keyhelp/www/keyhelp_tmp/"
[11-Feb-2024 09:38:42] INFO | start download of "https://install.keyhelp.de/files/releases/24.0/24.0-php82.tar.gz"
[11-Feb-2024 09:38:44] INFO | file saved to "/home/keyhelp/www/keyhelp_tmp/24.0.tar.gz"
[11-Feb-2024 09:38:44] INFO | checksum check successful
[11-Feb-2024 09:38:44] INFO | lock panel
[11-Feb-2024 09:38:44] INFO | log out all users
[11-Feb-2024 09:38:44] INFO | run --force-update one last time before new files and db structure may change things
[11-Feb-2024 09:38:47] INFO | checking running maintenance intervals ...
[11-Feb-2024 09:38:47] INFO | all maintenance intervals finished, so we can go on
[11-Feb-2024 09:38:47] INFO | archive extraction finished
[11-Feb-2024 09:38:48] INFO | changed owner of "/home/keyhelp/www/keyhelp_tmp/" to "keyhelp"
[11-Feb-2024 09:38:48] INFO | Setup backup directory "/home/keyhelp/keyhelp.backup/panel_updates"
[11-Feb-2024 09:38:48] INFO | Database backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-11_09-38-48.sql"
[11-Feb-2024 09:38:50] INFO | File backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-11_09-38-48.tar.gz"
[11-Feb-2024 09:38:51] INFO | remove old keyhelp folder
[11-Feb-2024 09:38:54] INFO | copy from "/home/keyhelp/www/keyhelp_tmp/" to "/home/keyhelp/www/keyhelp/" 
[11-Feb-2024 09:38:54] INFO | remove "/home/keyhelp/www/keyhelp_tmp/"
[11-Feb-2024 09:38:56] INFO | run update file "/home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php"
[11-Feb-2024 09:38:56] INFO | [database] update length of key and regular fields
Mit freundlichen Grüssen / Best regards
Walter Richner

**************************************************************
OEKOMATIK - EDV Richner
Reitibuechstrasse 16 - CH-5636 Benzenschwil
https://www.oekomatik.ch
**************************************************************
User avatar
Alexander
Keyweb AG
Posts: 3842
Joined: Wed 20. Jan 2016, 02:23

Re: Das Server Control Panel wird derzeit aktualisiert - 2

Post by Alexander »

Hallo,

schick mir mal die Zugangsdaten per PM, dann kann ich das reparieren.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
Alexander
Keyweb AG
Posts: 3842
Joined: Wed 20. Jan 2016, 02:23

Re: Das Server Control Panel wird derzeit aktualisiert - 2  [GELÖST]

Post by Alexander »

Der Server wurde erstmal wieder repariert, so das KeyHelp wieder erreichbar ist.

Auf dem Server sind noch ein paar andere Sachen im Argen, aber topolino weiß nun Bescheid.

-> Damit setzte ich den Beitrag auf gelöst.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Post Reply