The panel cannot be updated

murzik · Post by **murzik** » Tue 10. Sep 2024, 10:03

Hello!
The panel does not update, it gives errors. The system is clogged with backups. Have to clean it manually.

System information:

Code: Select all

Processor                 : AMD EPYC 7663 56-Core Processor (amd64)
CPU cores                 : 1 @ 2.00 GHz
System virtualization     : KVM

Disk space                : Free:   11.51 GB     Used:    7.04 GB     Total:   19.57 GB
Memory                    : Free:  643.44 MB     Used:  337.78 MB     Total:  981.22 MB
Swap space                : Free:        0 B     Used:  228.45 MB     Total:  228.45 MB

Operating system          : Ubuntu 20.04 (64-bit)
KeyHelp                   : 24.0 (DB), 24.2 (File), 3326 (Build)
Kernel                    : Kernel 5.4.0-29-generic
Web server                : Apache 2.4.41
DNS server                : BIND 9.18.28
PHP                       : PHP 7.4.3
Database server           : MariaDB 10.3.39
FTP server                : ProFTPD 1.3.6c
Mail Transfer Agent (MTA) : Postfix 3.4.13
Mail Delivery Agent (MDA) : Dovecot 2.3.7.2
MTA content filter        : Amavisd-new 2.11.0
Spam filter               : SpamAssassin 3.4.4
Virus scanner             : ClamAV 0.103.11
Database administration   : phpMyAdmin 5.2.1
Webmail                   : Roundcube 1.6.6
Cryptography              : OpenSSL 1.1.1f
Data transfer             : curl 7.68.0
Backup software           : Restic 0.16.4
Backup data transfer      : Rclone 1.66.0

Updating information and errors:

Code: Select all

[PID-210926] [10-Sep-2024 10:36:39] INFO | forced to run "panel_update.php"
[PID-210926] [10-Sep-2024 10:36:39] ERROR | panel update should be running (database flag), but corresponding PID is not running anymore, rescheduling panel update...
[PID-210926] [10-Sep-2024 10:36:39] INFO | jobs to run: panel_update.php
[PID-210926] [10-Sep-2024 10:36:39] INFO | >>> trying to run "panel-update"
[PID-210926] [10-Sep-2024 10:36:39] WARN | last run died abruptly
[PID-210926] [10-Sep-2024 10:36:39] INFO | lock "panel-update" acquired
[PID-210926] [10-Sep-2024 10:36:39] INFO | processing the job ...
[10-Sep-2024 10:36:39] INFO | maintenance log okay
[10-Sep-2024 10:36:39] INFO | trying to connect to updateserver
[10-Sep-2024 10:36:39] INFO | set correct tmp-directories mount for update
[10-Sep-2024 10:36:39] INFO | new version detected - starting update process from "24.0" to "24.2"
[10-Sep-2024 10:36:39] INFO | first update step: "24.2" | total steps to reach latest version:
[10-Sep-2024 10:36:39] INFO | create folder for panel update "/home/keyhelp/www/keyhelp_tmp/"
[10-Sep-2024 10:36:39] INFO | start download of "https://install.keyhelp.de/files/releases/24.2/24.2-php71.tar.gz"
/home/keyhelp/www/keyhelp_tmp/24.2. 100%[================================================================>]  19.69M  10.2MB/s    in 1.9s
[10-Sep-2024 10:36:42] INFO | file saved to "/home/keyhelp/www/keyhelp_tmp/24.2.tar.gz"
[10-Sep-2024 10:36:42] INFO | checksum check successful
[10-Sep-2024 10:36:42] INFO | lock panel
[10-Sep-2024 10:36:42] INFO | log out all users
[10-Sep-2024 10:36:42] INFO | run --force="update" one last time before new files and db structure may change things
[10-Sep-2024 10:36:44] INFO | checking running maintenance intervals ...
[10-Sep-2024 10:36:44] INFO | all maintenance intervals finished, so we can go on
[10-Sep-2024 10:36:45] INFO | archive extraction finished
[10-Sep-2024 10:36:45] INFO | changed owner of "/home/keyhelp/www/keyhelp_tmp/" to "keyhelp"
[10-Sep-2024 10:36:45] INFO | Setup backup directory "/home/keyhelp/keyhelp.backup/panel_updates"
[10-Sep-2024 10:36:45] INFO | Database backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_24.0_2024-09-10_10-36-45.sql"
[10-Sep-2024 10:36:47] INFO | File backup saved to "/home/keyhelp/keyhelp.backup/panel_updates/keyhelp_24.0_2024-09-10_10-36-45.tar.gz"
[10-Sep-2024 10:36:48] INFO | remove old keyhelp folder
[10-Sep-2024 10:36:50] INFO | copy from "/home/keyhelp/www/keyhelp_tmp/" to "/home/keyhelp/www/keyhelp/"
[10-Sep-2024 10:36:50] INFO | remove "/home/keyhelp/www/keyhelp_tmp/"
[10-Sep-2024 10:36:51] INFO | run update file "/home/keyhelp/www/keyhelp/install/updates/update_24.0.php"
[10-Sep-2024 10:36:51] INFO | [database] update field names

Warning: MySQL - Query Error: Unknown column 'change_personal_data' in 'users' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338

Warning: MySQL - Query Error: Unknown column 'change_personal_data' in 'account_templates' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:51] INFO | [database] update column order in php_settings
[10-Sep-2024 10:36:51] INFO | [ftp] add settings for FTP naming scheme
[10-Sep-2024 10:36:51] INFO | [database] remove unused settings fields
[10-Sep-2024 10:36:51] INFO | [database] add php_extra_directives_immutable & php_extra_directives_mutable

Warning: MySQL - Query Error: Unknown column 'php_additional_settings' in 'account_templates' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338

Warning: MySQL - Query Error: Duplicate column name 'php_extra_directives_mutable' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338

Warning: MySQL - Query Error: Unknown column 'additional_settings' in 'php_settings' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338

Warning: MySQL - Query Error: Duplicate column name 'extra_directives_mutable' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:51] INFO | [database] remove unused settings fields

Warning: MySQL - Query Error: Duplicate column name 'delete_main_domains' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:51] INFO | [database] update domains_* tables structure

Warning: MySQL - Query Error: Unknown column 'force_https' in 'domains' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338

Warning: MySQL - Query Error: Table 'domains_cgi' already exists (1050) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:52] INFO | [tools] install keyhelp-php-domain
[10-Sep-2024 10:36:52] INFO | [tools] set executable flag to KeyHelp tools
[10-Sep-2024 10:36:52] INFO | [disable_functions] update default settings
[10-Sep-2024 10:36:52] INFO | [disable_functions] update unlimited template
[10-Sep-2024 10:36:52] INFO | [background tasks] change column name status -> state

Warning: MySQL - Query Error: Unknown column 'status' in 'background_tasks' (1054) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:52] INFO | [backup] add pid property to backup operations

Warning: MySQL - Query Error: Duplicate column name 'pid' (1060) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 338
[10-Sep-2024 10:36:52] INFO | [dns] add DMARC + DKIM record to KeyHelp DNS config file
[10-Sep-2024 10:36:52] INFO | [keyhelp] update sudoers config
[10-Sep-2024 10:36:52] INFO | [logrotate] update config
[10-Sep-2024 10:36:52] INFO | [rclone] update to 1.66.0
/tmp/keyhelp/rclone.zip             100%[================================================================>]  20.16M  10.2MB/s    in 2.0s
[10-Sep-2024 10:36:55] INFO | [restic] update to 0.16.4
/tmp/keyhelp/restic.bz2             100%[================================================================>]   7.95M  4.26MB/s    in 1.9s
[10-Sep-2024 10:36:58] INFO | [SourceGuardian] update loaders
/tmp/keyhelp/sourceguardian.tar.gz  100%[================================================================>]   1.61M  3.85MB/s    in 0.4s
[10-Sep-2024 10:36:59] INFO | PHP-FPM (php7.4-fpm): syntax ok
[10-Sep-2024 10:36:59] INFO | PHP-FPM (php7.4-fpm): reloading php-fpm
[10-Sep-2024 10:36:59] INFO | PHP-FPM (keyhelp-php56-fpm): syntax ok
[10-Sep-2024 10:36:59] INFO | PHP-FPM (keyhelp-php56-fpm): reloading php-fpm
[10-Sep-2024 10:36:59] INFO | [postsrsd] installation and configuration
[10-Sep-2024 10:37:00] INFO | [snappymail] install snappymail version 2.36.3

Fatal error: Uncaught Error: Class 'PasswordGenerator' not found in /home/keyhelp/www/keyhelp/install/updates/update_24.0.php:480
Stack trace:
#0 /home/keyhelp/www/keyhelp/cronjob/jobs/panel_update.php(463): unknown()
#1 /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php(465): unknown()
#2 {main}
  thrown in /home/keyhelp/www/keyhelp/install/updates/update_24.0.php on line 480

 All tasks completed.

Help me, please!

Post by **Alexander** » Tue 10. Sep 2024, 10:32

Hello,

there seems to be one update which did not run smoothly.
Now it is stuck in a loop and cannot finish it, even if you start the update again.

Can you restore a backup from before the update?
I could fix it, but that would costs some time.

---

By the way, there is a template for posts in this Bugs / Issues area, it is mandatory to fill this out...

murzik · Post by **murzik** » Tue 10. Sep 2024, 10:39

Thank you, Alexander!

Alexander wrote: ↑Tue 10. Sep 2024, 10:32 Can you restore a backup from before the update?

I didn't find information about restoring from backup. How it to do? And how to disable auto update?

Post by **Alexander** » Tue 10. Sep 2024, 10:56

murzik wrote: ↑Tue 10. Sep 2024, 10:39
Alexander wrote: ↑Tue 10. Sep 2024, 10:32 Can you restore a backup from before the update?
I didn't find information about restoring from backup.

This depends on you backup strategy. Do you even have a backup?

murzik wrote: ↑Tue 10. Sep 2024, 10:39 How it to do? And how to disable auto update?

In the KeyHelp admin area - navigate to "Maintenance Intervals" -> Click on the pen behind "Update control panel" and tick the checkbox "Is enabled"

murzik · Post by **murzik** » Tue 10. Sep 2024, 11:56

Alexander wrote: ↑Tue 10. Sep 2024, 10:56 In the KeyHelp admin area - navigate to "Maintenance Intervals" -> Click on the pen behind "Update control panel" and tick the checkbox "Is enabled"

Admin area is not available.
Now I only connect via SSH. I have some archives in /home/keyhelp/keyhelp.backup/panel_updates/. Can I restore them?

Post by **Alexander** » Tue 10. Sep 2024, 12:08

Yes you can.

You may want to look into /var/log/keyhelp/cronjob/panel-update.log.*,
to see, which was the last update which run smooth. Than pick the backup .tar.gz and .sql from before the "crash".

omexlu · Post by **omexlu** » Tue 10. Sep 2024, 12:14

Alexander wrote: ↑Tue 10. Sep 2024, 12:08 Yes you can.

You may want to look into /var/log/keyhelp/cronjob/panel-update.log.*,
to see, which was the last update which run smooth. Than pick the backup .tar.gz and .sql from before the "crash".

OT: Here it would be nice to have a feature where an older panel backup could be restored via the toolbox-cli.

Sorry for offtopic

murzik · Post by **murzik** » Tue 10. Sep 2024, 12:37

omexlu wrote: ↑Tue 10. Sep 2024, 12:14 OT: Here it would be nice to have a feature where an older panel backup could be restored via the toolbox-cli.

I support you!

murzik · Post by **murzik** » Tue 10. Sep 2024, 12:57

Alexander wrote: ↑Tue 10. Sep 2024, 12:08 Than pick the backup .tar.gz and .sql from before the "crash".

Thanks!
1) How to disable auto update?
I didn't find jobs in crontab.
2) Can I restore DB-dump via phpmyadmin?

Post by **Alexander** » Tue 10. Sep 2024, 13:57

1) How to disable auto update?
I didn't find jobs in crontab.

The panel-update is not handled by the crontab directly. Via Crontab, you only can disable all background tasks of KeyHelp by comment out /etc/cron.d/keyhelp.
The other option via the UI I described above.

Can I restore DB-dump via phpmyadmin?

You can, but i highly advise to do it via the CLI.

murzik · Post by **murzik** » Tue 10. Sep 2024, 14:46

Alexander wrote: ↑Tue 10. Sep 2024, 13:57 You can, but i highly advise to do it via the CLI.

Got it.
Thank you!

omexlu · Post by **omexlu** » Tue 10. Sep 2024, 14:49

murzik wrote: ↑Tue 10. Sep 2024, 14:46
Alexander wrote: ↑Tue 10. Sep 2024, 13:57 You can, but i highly advise to do it via the CLI.
Got it.
Thank you!

Did you fixed the issue? When yes how exaclty (im interested in such things)

murzik · Post by **murzik** » Tue 10. Sep 2024, 15:41

Copied files from backup, restored dump.
Unfortunately, I still get the same message:

"The control panel is currently being updated"

It seems I killed all the processes.

Post by **Alexander** » Tue 10. Sep 2024, 15:54

If you are sure, this is not the case:

Change the "value" field from '1' to '0' in the KeyHelp database, table `settings`, where `category` = 'update' and `name` = 'in_progress'.

murzik · Post by **murzik** » Tue 10. Sep 2024, 16:02

Alexander wrote: ↑Tue 10. Sep 2024, 15:54 Change the "value" field from '1' to '0' in the KeyHelp database, table `settings`, where `category` = 'update' and `name` = 'in_progress'.

Yahoo!! It works!
Thank you very much!

I could fix it, but that would costs some time.

P.S.: when can I expect the update error to be fixed?

The panel cannot be updated [SOLVED]

The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated

Re: The panel cannot be updated