[Nagiosplug-devel] check_mysql should support a command line option for a MySQL defaults file

Wolfram Schlich lists at wolfram.schlich.org
Fri Nov 24 00:37:46 CET 2006


IMHO check_mysql currently lacks a command line option to specify an
alternate MySQL defaults file (aka ~/.my.cnf).
The 'mysql' command line program for example supports --defaults-file.

'check_mysql --help' itself warns about using '--password' in order
to supply a password for MySQL authentication.

Thus, the only secure and sane way to supply a password,
and even more important, *different* passwords for checking *multiple*
databases or MySQL servers, is via multiple specific MySQL
defaults files.

Example using '-f' as a possible command line option name:

	define command{
		command_name check_mysql
		command_line $USER1$/check_mysql -H $HOSTADDRESS$ -P $ARG1$ -u $ARG2$ -d $ARG3$ -f $ARG4$

	define service{
		host_name db1.example.com
		check_command check_mysql!3306!nagios!mysql!/var/nagios/mysql.db1.example.com.cnf

	define service{
		host_name db2.example.com
		check_command check_mysql!3306!nagios!mysql!/var/nagios/mysql.db2.example.com.cnf

Comments, please :-)
Wolfram Schlich <wschlich at gentoo.org>
Gentoo Linux * http://dev.gentoo.org/~wschlich/

More information about the Devel mailing list