Check_mysql plugins problems


#1

Hi,

Attracted by this project, I install nagios server on fedora 7 and nrpe on other test machine (fedora and debian host). Ping, sip account, disk space, memory, website or ssh check seems to work as require. But I got a problem with check_mysql command:
Nagios is reporting: “Uptime: 1382441 Threads: 4 Questions: 26464 Slow queries: 0 Opens: 168 Flush tables: 1 Open tables: 64 Queries per second avg: 0.019” whereas nrpe.cfg on host contains:
" command[check_mysql]=/usr/local/nagios/libexec/check_mysql "
I don’t undertand how check_mysql can send info without login on mysql …

On shell I got for ./check_msql (on /usr/local/nagios/libexec)
Access denied for user ‘root’@‘localhost’ (using password: NO) It is normal

So I tried to edit nrpe.cfg : " command[check_mysql]=/usr/local/nagios/libexec/check_mysql -d test -H localhost -u root -p ‘test’ " and i received the same answer on nagios web interface.

So I decided to install MySQL proxy on port 4040 and it work but with nrpe no log appears whereas I changed nrpe file : " command[check_mysql]=/usr/local/nagios/libexec/check_mysql -d test -H localhost -P 4040 -u root -p ‘test’. but I always received a good info.

mysql need password to be used and to obtain its Status… How it is possible, dit I make something wrong ?

If someone can give me example or some help :slight_smile: Thank and sorry for my bad english.

RAPY