Page 1 of 1

check_mssql_monitor show unknown

Posted: Sun Mar 03, 2013 8:26 pm
by cjimmy1977
wanna to ask, i succesfuly install nagios and wanna to monitoring SQL server , so i download the plugins name check_mssql_monitor from http://exchange.nagios.org/directory/Pl ... or/details

i'm using root and copy to /usr/local/nagios/libexec and make it executable with chmod 777 check_mssql_monitor

in the terminal, i success use this plugin to check the SQL, with syntax ./check_mssql_monitor -H 10.1.10.91 -p 1433 -U jimmy -P jim123# -w 80 -c 90 and success show the result in terminal.

now, i try to put in commands.cfg and windows.cfg in nagios

in the commands.cfg:

{
define command
command_name check_mssql_monitor
command_line $USER1$/check_mssql_monitor -H $HOSTADDRESS$ -p 1433 -U jimmy -P jim123# --cpuwarning --cpucritical -w $ARG1$ -c $ARG2$
}

in windows.cfg:

{
define service
use generic service
host_name 10.1.10.91
service_description SQL Server CPU Process
check_command check_mssql_monitor!80!90!30

after i do the compile with /usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg show no error and i restart the nagios service with /etc/init.d/nagios restart.

after restart i see the nagios front end , and the result show "UNKNOWN" Usage: check_mssql_monitor -H hostname [ -p port ] [ -t timeout ]

any help for this...
thanks

Re: check_mssql_monitor show unknown

Posted: Mon Mar 04, 2013 11:11 am
by abrist
cjimmy1977 wrote:check_command check_mssql_monitor!80!90!30
Where does the "30" come from? I only count 2 arguments in the following:
cjimmy1977 wrote:./check_mssql_monitor -H 10.1.10.91 -p 1433 -U jimmy -P jim123# -w 80 -c 90
You could try:

Code: Select all

check_command check_mssql_monitor!80!90