check mssql health

[braindope]

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

[rhassing]

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

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

[scottwilkerson]

Yep, did you install the freetds libraries?

[braindope]

@ scottwilkerson

Yes i already install it

[braindope]

@ 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

[Box293]

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

[braindope]

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

[tgriep]

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/

[braindope]

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

[tgriep]

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