Backup Error

The result of this command are in #1

 

This command should be executed in a specific directory?

 

Not really. Please check the /var/log/ispconfig/*.log files too, if there is anything debugged in it.

 

The cron.log shows me the same error. The auth and ispconfig log are empty.

 

Hello.

I have a similar problem on Ubuntu 16.04, after update a week ago backup stopped working. In the cron log i got this "php warning: chmod () permission denied in /usr/local/ispconfig/server/lib/classen/cron.d/500-backup.inc.php on line 74"
if from terminal run "php /usr/local/ispconfig/server/cron_debug.php --cronjob = 500-backup.inc.php" same error is displayed.
when run "php /usr/local/ispconfig/server/cron_debug.php --cronjob = 500-backup_mail.inc.php"
got the same error but mail backup runs
help me please :|

 

Hi everyone!!
Any news about my problem?

 

Please check if in your /usr/local/ispconfig/server/lib/config.inc.php the log_priority entry is also set to debug before you run the cron debug command.

 

No, in panel is setted to debug, but in this file no. I change to 0 in file and run the command. And the result is:


Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock


10.09.2019-10:02 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
10.09.2019-10:02 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.

 

Again you run the server.sh script, but we need the output of the backup cron debug script as already stated multiple times.

 

what command then?

 

Dear, I am near to not replying anymore. Please read the thread again, especially #20.

 

Called run() for class cronjob_backup
Job has schedule: 00 0 * * *
Called onPrepare() for class cronjob_backup
Called onBeforeRun() for class cronjob_backup
Jobs next run is 2019-09-11 00:00:00
Date compare of 1568170800 and 1568120885 is -1
10.09.2019-10:08 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web22' && sudo -u 'web22' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web22/web22_2019-09-10_10-08.zip' -@ - return code: 0
10.09.2019-10:08 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web22' && sudo -u 'web22' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web22/web22_2019-09-10_10-08.zip' -@ - return code: 12
10.09.2019-10:08 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web22' - return code: 0
10.09.2019-10:08 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web22' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web7' && sudo -u 'web7' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web7/web7_2019-09-10_10-08.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web7' && sudo -u 'web7' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web7/web7_2019-09-10_10-08.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web7' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web7' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web14' && sudo -u 'web14' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web14/web14_2019-09-10_10-09.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web14' && sudo -u 'web14' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web14/web14_2019-09-10_10-09.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web14' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web14' - return code: 0
^[[17~10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web6' && sudo -u 'web6' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web6/web6_2019-09-10_10-09.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web6' && sudo -u 'web6' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web6/web6_2019-09-10_10-09.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web6' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web6' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web3' && sudo -u 'web3' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web3/web3_2019-09-10_10-09.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web3' && sudo -u 'web3' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web3/web3_2019-09-10_10-09.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web3' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web3' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web4' && sudo -u 'web4' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web4/web4_2019-09-10_10-09.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web4' && sudo -u 'web4' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web4/web4_2019-09-10_10-09.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web4' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web4' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web5' && sudo -u 'web5' find . -group 'client0' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --symlinks '/var/backup/web5/web5_2019-09-10_10-09.zip' -@ - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: cd '/var/www/clients/client0/web5' && sudo -u 'web5' find . -user 'www-data' -print 2> /dev/null | zip -b '/tmp' --exclude=./backup\* --update --symlinks '/var/backup/web5/web5_2019-09-10_10-09.zip' -@ - return code: 12
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web5' - return code: 0
10.09.2019-10:09 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web5' - return code: 0
mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'db_name'': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PACKAGE STATUS WHERE Db = 'db_name'' at line 1 (1064)
10.09.2019-10:09 - DEBUG - safe_exec cmd: mysqldump -h 'localhost' -u 'user' -p'pass' -c --add-drop-table --create-options --quick --max_allowed_packet=512M --routines --result-file='/var/backup/web3/db_db_name_2019-09-10_10-09.sql' 'db_name' - return code: 2

 

Either you have changed the backup mode from tar to user-owned zip on the server or this is not the server the error you specified in the first posts occured. Additionally the ISPConfig seems to not be 3.1.15 otherwise the PACKAGE STATUS error should not be there.

 

I changed to web directory with root owner. And the results are:


Jobs next run is 2019-09-11 00:00:00
Date compare of 1568170800 and 1568121865 is -1
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web22' . --exclude=./backup\* | pigz > '/var/backup/web22/web22_2019-09-10_10-24.tar.gz' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web22' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web22' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web7' . --exclude=./backup\* | pigz > '/var/backup/web7/web7_2019-09-10_10-24.tar.gz' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web7' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web7' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:24 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web14' . --exclude=./backup\* | pigz > '/var/backup/web14/web14_2019-09-10_10-24.tar.gz' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web14' - return code: 0
10.09.2019-10:24 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web14' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web6' . --exclude=./backup\* | pigz > '/var/backup/web6/web6_2019-09-10_10-24.tar.gz' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web6' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web6' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web3' . --exclude=./backup\* | pigz > '/var/backup/web3/web3_2019-09-10_10-25.tar.gz' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web3' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web3' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web4' . --exclude=./backup\* | pigz > '/var/backup/web4/web4_2019-09-10_10-25.tar.gz' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web4' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web4' - return code: 0
tar: The following options were used after any non-optional arguments in archive create or update mode. These options are positional and affect only arguments that follow them. Please, rearrange them properly.
tar: --exclude “./backup*” has no effect
tar: Saindo com status de falha em razão de erros anteriores
10.09.2019-10:25 - DEBUG - safe_exec cmd: tar pcf - --directory '/var/www/clients/client0/web5' . --exclude=./backup\* | pigz > '/var/backup/web5/web5_2019-09-10_10-25.tar.gz' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr -i '/var/www/clients/client0/web5' - return code: 0
10.09.2019-10:25 - DEBUG - safe_exec cmd: chattr +i '/var/www/clients/client0/web5' - return code: 0
mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'db_name'': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PACKAGE STATUS WHERE Db = 'db_name'' at line 1 (1064)
10.09.2019-10:25 - DEBUG - safe_exec cmd: mysqldump -h 'localhost' -u 'user' -p'pass' -c --add-drop-table --create-options --quick --max_allowed_packet=512M --routines --result-file='/var/backup/web3/db_db_name_2019-09-10_10-25.sql' 'db_name' - return code: 2


And the version of ispconfig is 3.1.15 and the server is the same.

 

Finally this is the output that we requested. So we can look into it now.

 

https://git.ispconfig.org/ispconfig/ispconfig3/issues/5393

 

Sorry, I didn't understand

 

@Croydon pointed to the bug report on your issue, that was created today. Or at least modified today.
You can follow the progress of that bug to see when it may get fixed.