Bug#831043: backup-manager: mysql backup function unsuccessfully tries to lock information_schema table

[root <christoph@kling.org>]

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