Hi everyone! A couple days ago i upgraded my debian linux server, yesterday i realize that no backups of my databases are being made since the upgrade. Even the command php /usr/local/ispconfig/server/cron_debug.php --cronjob=500-backup.inc.php give me the same error. The error is 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) OS = Debian GNU/Linux 10 (buster) Kernel = Linux 4.19.0-5-amd64 Mysql Version = mysql Ver 15.1 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Mysqldump Version = mysqldump Ver 10.17 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) Ispconfig Version = 3.1.14p2 any suggestions for my problem?? Thank you all
I updated, and run the command to execute the backup, i got the same erro. But, before the lines of error, now i got this: 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
04/09/2019 14:32 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:32 maxpro.com.br Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 04/09/2019 14:31 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:31 maxpro.com.br Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 04/09/2019 14:30 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:30 maxpro.com.br Debug Restarting httpd: systemctl restart apache2.service 04/09/2019 14:30 maxpro.com.br Debug Calling function 'restartHttpd' from module 'web_module'. 04/09/2019 14:30 maxpro.com.br Debug Processed datalog_id 822 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Network configuration disabled in server settings. 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Writing the conf file: /etc/apache2/sites-available/ispconfig.conf 04/09/2019 14:30 maxpro.com.br Debug Calling function 'server_ip' from plugin 'apache2_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Processed datalog_id 821 04/09/2019 14:32 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:32 maxpro.com.br Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 04/09/2019 14:31 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:31 maxpro.com.br Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 04/09/2019 14:30 maxpro.com.br Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 04/09/2019 14:30 maxpro.com.br Debug Restarting httpd: systemctl restart apache2.service 04/09/2019 14:30 maxpro.com.br Debug Calling function 'restartHttpd' from module 'web_module'. 04/09/2019 14:30 maxpro.com.br Debug Processed datalog_id 822 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Network configuration disabled in server settings. 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Writing the conf file: /etc/apache2/sites-available/ispconfig.conf 04/09/2019 14:30 maxpro.com.br Debug Calling function 'server_ip' from plugin 'apache2_plugin' raised by event 'server_update'. 04/09/2019 14:30 maxpro.com.br Debug Processed datalog_id 821
That lines are result of this command: php /usr/local/ispconfig/server/cron_debug.php --cronjob=500-backup.inc.php.
What you posted in #11 is the result of running the server.sh command and not from running the debug command of the backup plugin.
Ok, and how can i execute the debug command of the backup plugin? And, running the server.sh command in prompt it returns just finished.