The check_mssql.pl is from the op5 dev team as per the start of the file:
# License: GPL
# Copyright (c) 2005-2008 op5 AB
# Author: op5 dev team <[email protected]>
#
# For direct contact with any of the op5 developers send a mail to
# [email protected]
# Discussions are directed to the mailing list [email protected],
# see http://lists.op5.com/mailman/listinfo/op5-users
My Command/Service definition is:
define command{
command_name van-sql01_DB_Test
command_line $USER1$/check_mssql -H van-sql01 -U USER -P PASSWD -o
-D Test
}
define service{
use generic-service
host_name van-sql01
service_description Database: Test
check_command van-sql01_DB_Test
}
r...@van-nagios-new:/usr/local/nagios/libexec# ls -l check_mssql.pl
-rwxrwxrwx 1 nagios nagios 9702 2009-07-27 11:16 check_mssql.pl
Nagios is configured to run under nagios/nagios, I can run the command from
shell under the "nagios" user as per below (su - nagios):
nag...@van-nagios-new:/usr/local/nagios/libexec$ ./check_mssql.pl -H van-sql01
-U ***** -P ***** -o -D DWH
OK - Database DWH is online. |online=1
But if I try to get Nagios to do this, all I get is a "null" result.
I can also successfully connect to my SQL server using tsql form the Ubuntu
8.04 box.
Thanks.
-----Original Message-----
From: Marc Powell [mailto:[email protected]]
Sent: July/29/2009 2:07 PM
To: Nagios Users Mail-list
Subject: Re: [Nagios-users] Check result from check_mssql.pl returns "null"
from nagios, but OK from shell ??
Sorry, also include your test+output, your host{}, service{} and the
command{} definitions.
--
Marc
On Jul 29, 2009, at 4:04 PM, Marc Powell wrote:
>
> On Jul 29, 2009, at 3:48 PM, Mirza Dedic wrote:
>
>> I am trying to use the check plug-in:
>>
>> Check_mssql.pl
>
> Which check_mssql.pl?
>
>> If I run it from the shell, using ./check_mssql.pl using my
>> parameters, everything works OK and the DBs report Online.
>
> As the nagios user?
>
>>
>> When I run this in Nagios, it reports "null" for all of my checks
>> using check_mssql.pl
>
> Usually a permissions, path or environment issue. We'd need to know
> which check_mssql.pl you're using to help figure out which.
>
> --
> Marc
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Nagios-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Nagios-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.
::: Messages without supporting info will risk being sent to /dev/null
