[Systems] [Systems-logs] Cron <root at sunjammer> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )

[Bernie Innocenti]

On 02/29/2016 12:22 AM, Cron Daemon wrote:
> /etc/cron.daily/system-remote-backup:
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'activities' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'activitiesdevel' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'activitiestesting' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'agendav' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'ar_sugarlabswiki' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'azucar_drupal' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'co_sugarlabswiki' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'fc_ole_org' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'km0r3' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'mysql' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'ole_org_moodle' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'oledrupal_gallery' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'olenepal_sitedb' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'pe_sugarlabswiki' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'pydocweb' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'squeakland_wiki' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'sugarlabsdrupal' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'sugarlabswiki' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'sugarlabswikidevel' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'sugarwiki_cl' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'testlink' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'wordpress' (1044)
> mysqldump: Couldn't execute 'show events': Access denied for user 'backup'@'localhost' to database 'wp_walterbender' (1044)

Added the missing privilege:

mysql> GRANT EVENT ON *.* TO 'backup'@'localhost';
Query OK, 0 rows affected (0.02 sec)

-- 
 _ // Bernie Innocenti
 \X/  http://codewiz.org