Page 1 of 1

check_mssql_health

Posted: Mon Apr 04, 2016 9:44 am
by pentiumone133
I'm trying to install the plugin check_mssql_health since it allows monitoring of SQL server backup age, which I don't think the built-in checks can do.

The installation completes fine, but when I attempt to run manually from the command line I encounter the following errors. Seems that a perl module is missing but google is coming up blank for me. I figure at least a few people must be utilizing this plugin on XI, how did you get it working? I also want to avoid doing anything that will break the included MSSQL checks since I will still be using those for other things.

Code: Select all

[root@nagiosxi libexec]# ./check_mssql_health --hostname=10.131.100.3 --username=test --password=test --mode=database-backup-age
CRITICAL - cannot connect to 10.131.100.3. install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC contains: . /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 19) 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, Proxy, Sponge, mysql.
 at ./check_mssql_health line 3273

Re: check_mssql_health

Posted: Mon Apr 04, 2016 10:50 am
by lmiltchev
The author of check_mssql_health states:
This Plugin requires the installation of the Perl-module DBD::Sybase.
https://labs.consol.de/nagios/check_mssql_health/

You will need to install the DBD::Sybase perl module on your Nagios XI box. On RHEL/CentOS 6, you should be able to run:

Code: Select all

yum install perl-DBD-Sybase
On RHEL/CentOS 7, you may need to compile it. Here's a guide I found that may be useful:

http://thibs.skynetblogs.be/rhel7/

Re: check_mssql_health

Posted: Mon Apr 04, 2016 2:27 pm
by pentiumone133
lmiltchev wrote:The author of check_mssql_health states:
This Plugin requires the installation of the Perl-module DBD::Sybase.
https://labs.consol.de/nagios/check_mssql_health/

You will need to install the DBD::Sybase perl module on your Nagios XI box. On RHEL/CentOS 6, you should be able to run:

Code: Select all

yum install perl-DBD-Sybase
On RHEL/CentOS 7, you may need to compile it. Here's a guide I found that may be useful:

http://thibs.skynetblogs.be/rhel7/

Thanks! I was trying to install the module through CPAN.

Re: check_mssql_health

Posted: Mon Apr 04, 2016 3:37 pm
by lmiltchev
Let us know if you have any more questions/issues. Thanks!