Backup Error

Discussion in 'General' started by Caio.Henrique, Sep 4, 2019.

  1. Caio.Henrique

    Caio.Henrique New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Update to ISPConfig 3.1.15.
     
  3. Caio.Henrique

    Caio.Henrique New Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, I'll try to reproduce that on Debian 10.
     
  5. Caio.Henrique

    Caio.Henrique New Member

    Ok, thank you
     
  6. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Could you please enable debug mode so we can see the complete command that is executed?
     
  7. Caio.Henrique

    Caio.Henrique New Member

    In loglevel i select debug?
     
  8. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

  9. Caio.Henrique

    Caio.Henrique New Member

  10. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

     
  11. Caio.Henrique

    Caio.Henrique New Member

    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
     
  12. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Doesn't seem you have run the backup command that causes the error you mentioned.
     
  13. Caio.Henrique

    Caio.Henrique New Member

    what command?
     
  14. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    That one.
     
  15. Caio.Henrique

    Caio.Henrique New Member

    That lines are result of this command: php /usr/local/ispconfig/server/cron_debug.php --cronjob=500-backup.inc.php.
     
  16. Croydon

    Croydon ISPConfig Developer ISPConfig Developer

    Yes … I know. So guess which command I'd like you to issue in debug mode?
     
  17. Caio.Henrique

    Caio.Henrique New Member

    But i ran this command before i send you the results
     
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  19. Caio.Henrique

    Caio.Henrique New Member

    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.
     
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    php /usr/local/ispconfig/server/cron_debug.php --cronjob=500-backup.inc.php
     

Share This Page