check_mssql_health nagios

drsketch1 · 02-11-2011, 01:27 PM

anyone have the check_mssql_health working on a Centos55 nagios 3 server?

I have perl-Nagios-Plugin perl-DBD-Sybase freetds all installed still not working...

any help would be greatly appreciated.

EricTRA · 02-12-2011, 12:32 AM

Hello,

It would be a lot of help to us if you can indicate what error messages you get when executing the script. Try as nagios user to execute it manually and post messages here please. The more information you provide the better we can help you.

Kind regards,

Eric

drsketch1 · 02-14-2011, 08:14 AM

Quote:

Originally Posted by EricTRA

Hello,

It would be a lot of help to us if you can indicate what error messages you get when executing the script. Try as nagios user to execute it manually and post messages here please. The more information you provide the better we can help you.

Kind regards,

Eric

When I run the plugin through /usr/bin/perl -w I get no error, however no matter what command I put in, all that returns is as if I ran the --help command.

When I run though /usr/local/nagios/bin/p1.pl -w I get

Code:

 
[root@nagios libexec]# ./check_mssql_health --help
./check_mssql_health: line 4: syntax error near unexpected token `('
./check_mssql_health: line 4: `my %ERRORS=( OK => 0, WARNING => 1, CRITICAL => 2, UNKNOWN => 3 );'

EricTRA · 02-14-2011, 08:38 AM

Hi,

What's on line 4 of the script check_mssql_health? I don't have access to a Nagios nor have that particular plugin installed.

Kind regards,

Eric

drsketch1 · 02-14-2011, 11:03 AM

Quote:

Originally Posted by EricTRA

Hi,

What's on line 4 of the script check_mssql_health? I don't have access to a Nagios nor have that particular plugin installed.

Kind regards,

Eric

Here are the first several lines.

Code:

# /usr/bin/perl -w
#! /usr/local/nagios/bin/p1.pl -w

my %ERRORS=( OK => 0, WARNING => 1, CRITICAL => 2, UNKNOWN => 3 );
my %ERRORCODES=( 0 => 'OK', 1 => 'WARNING', 2 => 'CRITICAL', 3 => 'UNKNOWN' );
package DBD::MSSQL::Server::Memorypool;

use strict;

our @ISA = qw(DBD::MSSQL::Server);