check_mssql_monitor show unknown

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
cjimmy1977
Posts: 1
Joined: Sun Mar 03, 2013 8:21 pm

check_mssql_monitor show unknown

Post 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
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: check_mssql_monitor show unknown

Post 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
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Locked