check_replication.pl


#1

I have been trying to get this plugin to work, but I keep getting the message: " **ePN /usr/local/nagios/libexec/check_replication.pl: “DBD::mysql::st execute failed: Access denied: you need the SUPER,REPLICATION CLIENT privilege for this operation at (eval 1) line 58,”

I have tried to run this through command line but get the same results when passing the same arguments. Any help would be much appreciated.


#2

Need to add permissions for the show slave status and show master status commands in mysql. You need the permissions GRANT PROCESS, FILE, SUPER, REPLICATION CLIENT for that user. I have the same user on each server with these permissions and it works. How to use grant
dev.mysql.com/doc/refman/5.0/en/grant.html