Page 1 of 1
Check_MSSQL_Server.py plugin not function
Posted: Thu May 24, 2012 3:40 pm
by gm_rajkumar
I have tried the check_mssql_server.py its not working properly, getting CRITICAL:Unable to access SQL Server message.
I have cross checked with check_mssql and check_mssql_database.py to connect the server, its working fine. please check the plugin or let me know if any changes required..
Regards,
Raj.
Re: Check_MSSQL_Server.py plugin not function
Posted: Thu May 24, 2012 4:39 pm
by lmiltchev
Can you run your check command in a command line and show us the output?
Re: Check_MSSQL_Server.py plugin not function
Posted: Fri May 25, 2012 1:48 am
by gm_rajkumar
Please find the below result.
[root@monitoring libexec]# /usr/local/nagios/libexec/check_mssql_server.py -H '172.16.4.12' -U 'sa' -P 'ABC@123$' -I 'MSSQLSERVER'
CRITICAL:Unable to access SQL Server.
--------------------------------------------------------------------------------
[root@monitoring libexec]# /usr/local/nagios/libexec/check_mssql_database.py -H '172.16.4.12' -U 'sa' -P 'ABC@123$' -T 'WSS_Content_80' -p 1433 --datasize -w 80 -c 90
CRITICAL:Size of database is 3135744KB|Size_of_database=3135744KB;;;;
[root@monitoring libexec]#
Let me know if you need further details on this.
Regards,
Raj.
Re: Check_MSSQL_Server.py plugin not function
Posted: Fri May 25, 2012 9:26 am
by nscott
Ah yes, I had found a bug in that, please download this:
http://support.nagios.com/forum/downloa ... hp?id=1579
And use the plugin inside of that one.
Re: Check_MSSQL_Server.py plugin not function
Posted: Fri May 25, 2012 10:01 am
by gm_rajkumar
Hi,
I have removed the old plugin and tried this new one, it returns the same issue.
Could you please check this once.
CRITICAL:Unable to access SQL Server.
Regards,
Raj.
Re: Check_MSSQL_Server.py plugin not function
Posted: Fri May 25, 2012 10:02 am
by scottwilkerson
Locking ticket as it is also being worked via email support