check_mysql

Nagios
1

hello

when i give check_mysql command i get access denied err.

heres wht i get

root@server [/usr/local/nagios/libexec]# ./check_mysql
Access denied for user: ‘root@localhost’ (Using password: NO)

Can anyone help with it

Thanks

2

As usual, start with the plugin --help and work from there

./check_mysql --help
check_mysql (nagios-plugins 1.4) 1.24
Copyright © 1999-2004 Nagios Plugin Development Team
[email protected]

This program tests connections to a mysql server
Usage: check_mysql -d database] -H host] -P port] -u user] -p password] -S
]

Options:
-h, --help
Print detailed help screen
-V, --version
Print version information
-H, --hostname=ADDRESS
Host name or IP Address
-P, --port=INTEGER
Port number (default: 3306)
-d, --database=STRING
Check database with indicated name
-u, --username=STRING
Connect using the indicated username
-p, --password=STRING
Use the indicated password to authenticate the connection
==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==
Your clear-text password will be visible as a process table entry
-S, --check-slave
Check if the slave thread is running properly.

There are no required arguments. By default, the local database with
a server listening on MySQL standard port 3306 will be checked

3

Thanks redtom
i will try this out and let you know
Thanks again

4

Re: " root@server [/usr/local/nagios/libexec]# ./check_mysql
Access denied for user: ‘root@localhost’ (Using password: NO)
"
That tells me that you are trying to access a mysql database as root user and that you have supplied no login password. Surely, the root user has a password, so if you corrected that, it should work. BTW, you should run the scripts as the nagios user, since that is how NAGIOS will run them. Don’t run them as root, since that is not a true test of the script.