Error restore website [5009]

[rek]

I did this:

02 - Upgrading CyberPanel

Upgrading CyberPanel The following command can be used to upgrade to the latest version. sh <(curl https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh || wget -O - https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh) If using a sudo user rather than root, try this: sudo su - -c "sh <(curl https://raw.githubusercontent.com/usmannasir/cyberpanel/stable/preUpgrade.sh || wget -O - https://raw.githubusercontent.com/usmannasir/cyberpanel/stable…

And then:

sh: 0: Can’t open /dev/fd/63
info@cyberpanel-2-vm:/home$ % Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 396 100 396 0 0 2212 0 --:–:-- --:–:-- --:–:-- 2212
(23) Failed writing body

[rek]

Just to give more info, it’s a right now installed vm from Google Cloud, the Official Cyberpanel.

[die2mrw007]

Do not install cyberpanel using the provided image in google cloud. Use SSH method to install cyberpanel from scratch.

[cynogen]

Hello @die2mrw007,
While restoring a backup on the latest cyberpanel, it throws [736][5009].

Error-log:
(1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET PASSWORD FOR ‘U4Hgdy0M07UhaG’@‘localhost’ = ‘*A41A8B7C84C13D94BFD54AF0527…’ at line 1”)[restoreDatabaseBackup]

I haven’t changed mySQL password and I already have checked the same at both places:

1. /etc/cyberpanel/mysqlPassword
2. /usr/local/CyberCP/CyberCP/settings.py

Now, what is the possible solution?

[die2mrw007]

The password() function may have changed in latest mariadb version and hence such error

Do u remember what was the cyberpanel version or mariadb version when you created this backup?

[cynogen]

As cyberpanel version does not change automatically, the previous version was as same as current one.

[die2mrw007]

So, how is the backup file structure? Does it has sql file in it?
If so, you can open it in SQL editor and then change/reset the password using ALTER command for user ‘U4Hgdy0M07UhaG’
and then later try to restore your backup which should successfully execute.

[soweto.io]

Hello,

When I try to retrieve a backup I get this error: Compressed file ended before the end-of-stream marker was reached [736][5009].

I have not changed the mysql password.

In the logs I only get this:

[06.16.2024_12-33-39] /home/almamarket.com/backup/
[06.16.2024_12-33-39] /home/almamarket.com/backup/backup-almamarket.com-06.16.2024_12-33-39
[06.16.2024_14-03-56] Compressed file ended before the end-of-stream marker was reached [startRestore] [06.16.2024_14-03-59] /home/almamarket.com/backup/backup-almamarket.com
[06.16.2024_14-11-53] Compressed file ended before the end-of-stream marker was reached [startRestore].

Any solution?

Thank you,