MS-SQL database monitoring issue.

[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.

[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.

[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.

[mbellerue]

Okay, can you post the path to the DBD-Sybase-1.15 directory? What OS and version is this?