Page 1 of 1

check_mssql_health

Posted: Wed Feb 10, 2016 1:07 pm
by 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

Re: check_mssql_health

Posted: Wed Feb 10, 2016 1:30 pm
by 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

Re: check_mssql_health

Posted: Wed Feb 10, 2016 1:50 pm
by eddiez
Will give that a try, thanks

Re: check_mssql_health

Posted: Wed Feb 10, 2016 2:00 pm
by bwallace
Some more info here:

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

Let us know how it works out.