DB LB ERROR OF MSSQL monitoring

[gselvakumar]

Hi team,
We have configured Master MSSQL Database time,MSSQL conection time,MSSQL Deadlocks per sec parameters as part of MSSQL monitoring. But for few servers we getting this error "DB-Lib error message 20009, severity 9:".
Can anyone help us in removing this error.


Thanks & regards
Gomathyshankar Selvakumar

[rkennedy]

Can you please post the check command that is running for the services in question here?

[gselvakumar]

For master MSSQL Database Size:check_xi_mssql_database!-U 'nagios' -P 'password' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000

For MSSQL Connection Time:check_xi_mssql_server!-U 'nagios' -P 'password' -p 1433 --time2connect --warning 1 --critical 5

For MSSQL Deadlocks Per Sec:check_xi_mssql_server!-U 'nagios' -P 'password' -p 1433 --deadlocks --warning 20 --critical 30

[gselvakumar]

And for few server I am getting this error msg also "SQL Server message 18456, severity 14, state 1, line 1:" for the parameters mentioned in the question

[tgriep]

The "SQL Server message 18456, severity 14, state 1, line 1" error message could be caused by the plugin needing to have the database set to have SQL Authentication enabled.
Another possibility are special characters in the username and password. Do you have any in the username or password?

[gselvakumar]

I have "@" in my password.So how to rectify the error??
And what does error ""DB-Lib error message 20009, severity 9:" mean because I getting this for few servers for the below mentioned parameters.

For master MSSQL Database Size:check_xi_mssql_database!-U 'nagios' -P 'password' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000

For MSSQL Connection Time:check_xi_mssql_server!-U 'nagios' -P 'password' -p 1433 --time2connect --warning 1 --critical 5

For MSSQL Deadlocks Per Sec:check_xi_mssql_server!-U 'nagios' -P 'password' -p 1433 --deadlocks --warning 20 --critical 30

[tgriep]

I tested the examples that you posted and they failed when I used the "-p" port option but passed when I used the "-I" Instance option.
It looks like those plugins do not work when using the port but only when using the Instance.
Can you try that and see if that works for you?

[gselvakumar]

Hi,

When I used the "-I" Instance option I Am getting this error "<class 'pymssql.InterfaceError'>"

[tgriep]

Can you post how you ran the command here so we can see the full output?
I asked earlier but is the SQL server setup to use SQL authentication?
The plugin requires a local account to work.
Are you using a local username and password in the check?

[gselvakumar]

Hi,
The command used is given below:

COMMAND: /usr/local/nagios/libexec/check_mssql_database.py -H uUSRCDXX1M00.fossil.com -U 'nagios' -P 'Raam@123' -T 'master' -p 1433 --datasize --warning 10000 --critical 100000
OUTPUT: DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist
Net-Lib error during Connection refused Error 111 - Connection refused