I see the following error in email from /root/scripts/automysqlbackup
Code: Select all
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
http://support.nagios.com/forum/viewtop ... 39&p=32489
and this forum post
http://support.nagios.com/forum/viewtop ... 52&p=36865
However, the table name is different.
I first saw the same error with the dbase information_schema reported by other forum members.
I edited /root/scripts/automysqlbackup to exclude information_schema and that specific error went away.
The error now shows up in a second dbase named performance_schema in a table cond_instances
I have edited /root/scripts/automysqlbackup to also exclude performance_schema and I will see if that resolves the issue.
Code: Select all
# List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
DBEXCLUDE="information_schema performance_schema"Code: Select all
[root@nagiosxi-dev-mtl ~]# mysql --version
mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
[root@nagiosxi-dev-mtl ~]#
http://exchange.nagios.org/directory/Do ... se/details
and run this script mentioned there
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
This does not appear to have resolved the issue.
David Sloboda