aims team mailing list archive

[Launchpad Bug Tracker <995587@xxxxxxxxxxxxxxxxxx>]

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.