Nagios Support Forum

Hi Everyone,

Kindly please help me on my error below, im trying to monitor my sql database using check_mssql_health via nagios.

CRITICAL - cannot connect to XX.XX.XX.XX install_driver(Sybase) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: libct.so.4: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at (eval 13) line 3
Compilation failed in require at (eval 13) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/nagios/libexec/check_mssql_health line 1977

I must admit it not my best document, but maybe it helps?

http://mona.deltics.info/?page_id=49

Yep, did you install the freetds libraries?

@ scottwilkerson

Yes i already install it

@ rhassing

Thank for the link the previous error is now gone, however now i have another error below:

CRITICAL - cannot connect to xx.xx.xx.xx DBI connect(':host=xx.xx.xx.xx:port=1433','root',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (44)
Server , database
Message String: Server name not found in configuration files.
OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (45)
Server , database
Message String: Unknown host machine name.
at /usr/local/nagios/libexec/check_mssql_health line 1981

Can you please test this from the command line and show us the command and results.

Hi All,

I have successfully resolved my issue , i just edit my freetds config as show below.
[global]
# TDS protocol version
; tds version = 8


[sqlhost1]
server = xx.xx.xx.xx
port = 1433
tds version = 8.0

then i edit my command check from <host> to <server>

Last question, how can i add another server in my freetds.conf? i tried several approached but none were working

Message String: Unable to connect: Adaptive Server is unavailable or does not exist

above's the new error for the server's that i want to add
Please note that my other server is using 30127 port

Here is the link to the check_mssql_health plugin and it has an example on how to add another instance to the /etc/freetds.conf file.
Try that to see if you can add another server instead of another instance.
http://labs.consol.de/nagios/check_mssql_health/

@ tgriep

I've have read and try several editing based on the link that you gave me, however none have been successful

some of the discussion is in other language.

Could you post what you added to the /etc/freetds.conf file and how you ran the check_mssql check command?