You have been subscribed to a public bug by Jan Groenewald (jan-aims):
Release: 12.04
automysqlbackup:
Installed: 2.6+debian-2
Candidate: 2.6+debian-2
Version table:
*** 2.6+debian-2 0
500 http://us.archive.ubuntu.com/ubuntu/ precise/universe amd64 Packages
100 /var/lib/dpkg/status
After a remove --purge, reinstall of automysqlbackup, and configure in
/etc/defaults/automysqlbackup, I am emailed the following error when cron runs
/usr/sbin/automysqlbackup:
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
'debian-sys-maint'@'localhost' for table 'cond_instances' when using
LOCK TABLES
it seems that the default on ubuntu is to use the user debian-sys-maint
to run this backup, however debian-sys-maint doesn't have full
permissions. Some say that these tables are not necessary to backup and
recommend the flag " --skip-add-locks" OR "--skip-lock-tables":
http://serverfault.com/questions/268566/cant-backup-the-mysql-table-
with-mysqldump-select-lock-tabl-command-denied-for
I managed to get the error to go away by adding "--skip-lock-tables" to
/usr/sbin/automysqlbackup:
if [ -z "${USERNAME}" -o -z "${PASSWORD}" ] ; then
mysqldump --defaults-file=/etc/mysql/debian.cnf $NEWOP\
T --skip-lock-tables $1 > $2
else
mysqldump --user=$USERNAME --password=$PASSWORD --host\
=$DBHOST --skip-lock-tables $NEWOPT $1 > $2
fi
return 0
** Affects: automysqlbackup (Ubuntu)
Importance: Undecided
Status: Confirmed
--
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user
'debian-sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES
https://bugs.launchpad.net/bugs/995587
You received this bug notification because you are a member of AIMS, which is
subscribed to the bug report.
--
Mailing list: https://launchpad.net/~aims
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aims
More help : https://help.launchpad.net/ListHelp
