Fehler beim Update auf Version 24  [GELÖST]

Haben Sie einen Bug entdeckt? Teilen Sie es uns mit.
Post Reply
User avatar
Flummi
Posts: 3
Joined: Thu 8. Feb 2024, 12:18

Fehler beim Update auf Version 24

Post by Flummi »

Ich bin sicher, dass die Ursache des Problems bei KeyHelp liegt
(Probleme ohne KeyHelp-Bezug gehören ins Offtopic-Forum)
Ja(?)

Server-Betriebssystem + Version
(z.B. Ubuntu 20.04)
jeweils Debian 12

Eingesetzte Server-Virtualisierung-Technologie
(z.B. keine, OpenVZ, KVM, XEN, etc.)
KVM (und eine weitere Instanz ohne Virtualisierung)

KeyHelp-Version + Build-Nummer
(z.B. 22.0 - Build 2366)
23.2.1 - Build 3220

Problembeschreibung / Fehlermeldungen
Update auf Version 24 schlägt fehl.
Im Ordner /home/keyhelp/.lock existiert nur die Datei panel-update.lock.

systemctl status mariadb spuckt folgende Zeile aus:

Code: Select all

2024-02-08 13:03:41 91 [Warning] Aborted connection 91 to db: 'keyhelp' user: 'keyhelp' host: 'localhost' (Got an error reading communication packets)
Passwörter für keyhelp und keyhelp_root (aus /etc/keyhelp/config/config.json) funktionieren.

Erwartetes Ergebnis
Update läuft wie normalerweise immer fehlerfrei durch.

Tatsächliches Ergebnis
Update läuft nicht durch.

Schritte zur Reproduktion
Update wurde automatisch angeleiert.

Zusätzliche Informationen
(z.B. kürzlich durchgeführte Änderungen am Server, Auszüge aus Protokolldateien (/var/log/*, /var/log/keyhelp/php-error.log, etc.))
php-error.log:

Code: Select all

[08-Feb-2024 12:08:16 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:17 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:18 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:18 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
[08-Feb-2024 12:08:19 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:20 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:21 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:21 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
[08-Feb-2024 12:08:22 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:23 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:24 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:24 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
[08-Feb-2024 12:08:25 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:26 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:27 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:27 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
[08-Feb-2024 12:08:28 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:29 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:30 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:30 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
[08-Feb-2024 12:08:31 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:32 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:33 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:33 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
[08-Feb-2024 12:08:34 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:35 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:36 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:36 UTC] PHP Warning:  MySQL - Query Error: Duplicate column name 'traffic' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[08-Feb-2024 12:08:37 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:38 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:39 UTC] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 178
[08-Feb-2024 12:08:39 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
[08-Feb-2024 12:08:39 UTC] PHP Warning:  file_put_contents(/etc/rspamd/local.d/dkim_signing.conf): Failed to open stream: No such file or directory in /home/keyhelp/www/keyhelp/core-ns/Utilities/FileAccess.php on line 335
[08-Feb-2024 12:08:39 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
In der panel-update.log sehe ich keine Unauffälligkeiten.

Gibt es die Möglichkeit den Updateprozess zu stoppen, damit 1. das Controlpanel wieder funktioniert und ich 2. das Autoupdate deaktivieren kann?
Da dies auf zwei Servern auftritt, frage ich mich natürlich, was genau da schiefgelaufen ist, und ob es an mir liegt? :D

edit: Hab doch mal etwas weitergegegraben. Hier erstmal die Ausgabe von panel-update.log:

Code: Select all

[08-Feb-2024 12:23:01] INFO | maintenance log okay
[08-Feb-2024 12:23:01] INFO | trying to connect to updateserver
[08-Feb-2024 12:23:02] INFO | set correct tmp-directories mount for update
[08-Feb-2024 12:23:02] INFO | new version detected - starting update process from "23.2.1" to "24.0"
[08-Feb-2024 12:23:02] INFO | first update step: "24.0" | total steps to reach latest version: 
[08-Feb-2024 12:23:02] INFO | create folder for panel update "/home/keyhelp/www/keyhelp_tmp/"
[08-Feb-2024 12:23:02] INFO | start download of "https://install.keyhelp.de/files/releases/24.0/24.0-php82.tar.gz"
[08-Feb-2024 12:23:03] INFO | file saved to "/home/keyhelp/www/keyhelp_tmp/24.0.tar.gz"
[08-Feb-2024 12:23:03] INFO | checksum check successful
[08-Feb-2024 12:23:03] INFO | lock panel
[08-Feb-2024 12:23:03] INFO | log out all users
[08-Feb-2024 12:23:03] INFO | run --force-update one last time before new files and db structure may change things
[08-Feb-2024 12:23:06] INFO | checking running maintenance intervals ...
[08-Feb-2024 12:23:06] INFO | all maintenance intervals finished, so we can go on
[08-Feb-2024 12:23:06] INFO | archive extraction finished
[08-Feb-2024 12:23:06] INFO | changed owner of "/home/keyhelp/www/keyhelp_tmp/" to "keyhelp"
[08-Feb-2024 12:23:06] INFO | Setup backup directory "/home/keyhelp/keyhelp.backup/panel_updates"
[08-Feb-2024 12:23:06] INFO | Database backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-08_12-23-06.sql"
[08-Feb-2024 12:23:07] INFO | File backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_23.2.1_2024-02-08_12-23-06.tar.gz"
[08-Feb-2024 12:23:08] INFO | remove old keyhelp folder
[08-Feb-2024 12:23:10] INFO | copy from "/home/keyhelp/www/keyhelp_tmp/" to "/home/keyhelp/www/keyhelp/" 
[08-Feb-2024 12:23:10] INFO | remove "/home/keyhelp/www/keyhelp_tmp/"
[08-Feb-2024 12:23:11] INFO | run update file "/home/keyhelp/www/keyhelp/install/updates/update_23.2.1.php"
[08-Feb-2024 12:23:11] INFO | [database] update length of key and regular fields
[08-Feb-2024 12:23:11] INFO | [database] update charset and collate for all KeyHelp tables
[08-Feb-2024 12:23:15] INFO | [database] update structure of `mail_users`
[08-Feb-2024 12:23:15] INFO | [database] update structure of `mail_aliases`
[08-Feb-2024 12:23:27] INFO | [database] update structure of `users_password_change_requests`
[08-Feb-2024 12:23:27] INFO | [database] update structure of `databases`
[08-Feb-2024 12:23:27] INFO | [database] update structure of `ftp_users`
[08-Feb-2024 12:23:27] INFO | [database] update structure of `ftp_users`
[08-Feb-2024 12:23:27] INFO | [database] update structure of `php_settings`
[08-Feb-2024 12:23:30] INFO | [awstats] add database flag for DNS lookup
[08-Feb-2024 12:23:30] INFO | [domains] add traffic / month feature
[08-Feb-2024 12:23:33] INFO | [white_label] update field names
[08-Feb-2024 12:23:33] INFO | [database] rename table `mail_aliases` -> `mail_routing`
[08-Feb-2024 12:23:36] INFO | [postfix] rename table `mail_aliases` -> `mail_routing`
[08-Feb-2024 12:23:36] INFO | [rspamd] move DKIM paths
Also, mail_aliases kann es natürlich nicht mehr geben, weil die in mail_routing umbenannt wurde.
In der php-error.log steht, dass er nichts in die Datei /etc/rspamd/local.d/dkim_signing.conf schreiben konnte, diese existiert auch wirklich nicht.
Sollte ich die Datei mit touch mal anlegen?

Gruß Flummi
User avatar
Flummi
Posts: 3
Joined: Thu 8. Feb 2024, 12:18

Re: Fehler beim Update auf Version 24  [GELÖST]

Post by Flummi »

Tja, hat sich erledigt.

rspamd war nicht mal installiert, da hab ich beim letzten Update wohl geschlafen. Hätte er das nicht automatisch installieren müssen?
Hab mir da nichts bei gedacht, da die Spamtags etc im Mailheader gesetzt waren.

Naja, 'tschuldigung für die Störung. :D

Gruß Flummi
Post Reply