On 05/17/2012 06:44 PM, Daniel Andersson wrote: > Package: automysqlbackup > Version: 2.6+debian-2 > Severity: normal > > Since upgrade to mysql-server-5.5 (and mysql-client-5.5 and so on), I started > getting mails from cron each morning at 07:35 when automysqlbackup is run: > >> Subject: ERRORS REPORTED: MySQL Backup error Log for d-f05 - >> >> mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'debian- > sys-maint'@'localhost' for table 'cond_instances' when using LOCK TABLES > > , but all backups seem to be OK.
Hi Daniel, First, thanks for the report. What is this table cond_instances? Something specific to your setup? Normally, debian-sys-maint is a standard account in Debian, with root access to every database. The /etc/default/automysqlbackup setup is using what is stored in /etc/mysql/debian.cnf to connect to your MySQL db by default. So if this account doesn't have access to this table, or if this table isn't lockable, then this is somehow to expect. But I will not be able to know until you tell me what this table is. I have installed MySQL 5.5 on my SID test box, and I didn't see any table called like this... Please let me know, Thomas Goirand (zigo) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
