check_mssql_health

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
pentiumone133
Posts: 13
Joined: Tue Mar 29, 2016 2:48 pm

check_mssql_health

Post 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
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: check_mssql_health

Post 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/
Be sure to check out our Knowledgebase for helpful articles and solutions!
pentiumone133
Posts: 13
Joined: Tue Mar 29, 2016 2:48 pm

Re: check_mssql_health

Post 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.
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: check_mssql_health

Post by lmiltchev »

Let us know if you have any more questions/issues. Thanks!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked