Package: backup-manager Version: 0.7.12-1 Severity: normal Dear Maintainer,
if you turn on the (relatively) new BM_MYSQL_SEPARATELY option, backup-manager tries to LOCK the information_schema table, which fails for lack of permission: mysqldump: Got error: 1044: Access denied for user 'backup'@'localhost' to database 'information_schema' when using LOCK TABLES This in turn generates these syslog log lines: Jul 13 03:28:10 xxxxx backup-manager[23538]: warning * Unable to exec first piped command /usr/bin/nice -n 10 /usr/bin/mysqldump --defaults-extra-file=/root/.backup-manager_my.cnf --opt -uxxxxxx -hlocalhost -P3306 info rmation_schema; check /backup/tmp/bm-command.YQZ5rz Jul 13 03:28:10 xxxxx backup-manager[23538]: error * Unable to find /xxxxxxxxx-mysql-information_schema.20160713.sql.bz2 backup-manager then returns with error code 1. Solution: backup-manager should skip that table. Best, Christoph -- System Information: Debian Release: stretch/sid APT prefers testing APT policy: (990, 'testing'), (500, 'unstable'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 4.6.0-1-amd64 (SMP w/8 CPU cores) Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages backup-manager depends on: ii debconf [debconf-2.0] 1.5.59 ii perl 5.22.2-1 ii ucf 3.0036 backup-manager recommends no packages. Versions of packages backup-manager suggests: pn anacron <none> pn backup-manager-doc <none> pn dar <none> pn dvd+rw-tools <none> pn genisoimage <none> ii gettext-base 0.19.8.1-1 pn libnet-amazon-s3-perl <none> ii openssh-client 1:7.2p2-5 pn wodim <none> ii zip 3.0-11 -- debconf information: backup-manager/upload-passwd: (password omitted) backup-manager/want_to_upload: true backup-manager/encryption_recipient: backup-manager/time-to-live: 32 backup-manager/enable_encryption: false backup-manager/filetype: tar.gz backup-manager/upload-user-ftp: xxxxxxxx backup-manager/dump_symlinks: false * backup-manager/repo_group: root backup-manager/burning-maxsize: backup-manager/name-format: long backup-manager/burning-device: backup-manager/burning-enabled: false * backup-manager/directories: /xxxxxxxxxx backup-manager/transfert_mode: ftp backup-manager/upload-user-scp: backup-manager/burning-method: backup-manager/cron_d_remove_deprecated: false * backup-manager/repo_user: root backup-manager/upload-dir: backup backup-manager/blacklist: /xxxxxxx * backup-manager/backup-repository: /xxxxxxx backup-manager/upload-hosts: xxxxxxx backup-manager/upload-key: backup-manager/cron_frequency: daily
