Page 1 of 1

MS-SQL database monitoring issue.

Posted: Thu Sep 19, 2019 12:01 pm
by vinish098
Hi,

I'm monitoring MS-SQL database in NagiosXI. I'm using check_mssql_health plugin to monitor the requested services of MS-SQL database.
After successful installation and configuration of Perl module DBD::Sybase. I'm trying to monitor the databases from cmd its working and giving the output. But the same thing when I'm trying to monitor from NagiosXI GUI after the creation of command. I'm getting critical error.
Pls, find the error below.

CRITICAL: could not load perl module DBD::Sybase.

Pls, find the attached documents which show the output from CMD and GUI.

Re: MS-SQL database monitoring issue.

Posted: Fri Sep 20, 2019 9:09 am
by mbellerue
That looks like it could be an issue of the nagios user not having access to DBD::Sybase. When you're running the command at the terminal, you're running it as root, so it would have to try pretty hard to fail. At the terminal, try,

Code: Select all

su - nagios
And then run your check command. I bet it fails. Which means we'll have to take a look at the Perl modules directory to see if there's a permissions issue or something.

Re: MS-SQL database monitoring issue.

Posted: Mon Sep 23, 2019 2:20 am
by vinish098
Hi mbellerue,

Yes you r right I tried to run same command from Nagios user and getting same error.

I have given permission on DBD-Sybase-1.15 directory for Nagios user.

But after assigned full permission also I'm getting same error.

Need your help to fix the issue.

Re: MS-SQL database monitoring issue.

Posted: Mon Sep 23, 2019 10:11 am
by mbellerue
Okay, can you post the path to the DBD-Sybase-1.15 directory? What OS and version is this?