check_mssql_health

[eddiez]

When I tried to run/test this check plugin I received the following. I don't know why its asking for Sybase.pm when we are not using Sybase and its going to a mssql server.


[root@utlp1362 libexec]# ./check_mssql_health --server=RDBP5140.ad.ama-assn.org --username=nagios --password=nagios23 --mode=cpu-bus
y
CRITICAL - cannot connect to RDBP5140.ad.ama-assn.org. install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC conta
ins: . /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr
/share/perl5) at (eval 15) line 3.
Perhaps the DBD::Sybase perl module hasn't been fully installed,
or perhaps the capitalisation of 'Sybase' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Multiplex, Proxy, Sponge, mysql.
at ./check_mssql_health line 3273

[gormank]

I seem to recall when reading the perl DBI book long ago that MSSQL when it was young was Sybase, or related, so DBD uses the Sybase driver. In any case, it looks like you need to get the driver.

I don't recall the yum syntax but maybe:

yum install perl-dbd-sybase -y

Or maybe:

perl -MCPAN -e shell
> install DBD::Sybase

Edit, I see there's a cpan script at /usr/bin/cpan, so this looks easier:

cpan install DBD::Sybase

[eddiez]

Will give that a try, thanks

[bwallace]

Some more info here:

http://pkgs.org/centos-6/repoforge-x86_ ... 4.rpm.html

Let us know how it works out.