SQL-DB Services-Unknown Status

[Greg Pangrazio]

what does the NRPE config look like on the remote end?  Are you allowed to
run commands?  What result do you get if you run

check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a
$HOSTADDRESS$

with the proper variables from the command line on your nagios server?
Greg Pangrazio




On Fri, Sep 10, 2010 at 8:49 AM, <ravishankar.gundlapali at wipro.com> wrote:

>  Hi,
>
>
>
> Please see the service definition and command definition which I am using
> for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH.
>
>
>
> Request you to provide a clue on this.
>
>
>
>
>
> define service{
>
>         use                             generic-service         ; Name of
> service template to use
>
>         host_name                      abcd
>
>         service_description             SQL-DB-LOG-USED
>
>         is_volatile                     0
>
>         check_period                    24x7
>
>         max_check_attempts              3
>
>         normal_check_interval           5
>
>         retry_check_interval            1
>
>         contact_groups                  sql-admins
>
>         notification_interval           0
>
>         notification_period             24x7
>
>         notification_options            c,r
>
>         check_command                 check_nrpe_mssql_log_used!*!50!90
>
>   }
>
>
>
>
>
>
>
> define service{
>
>         use                             generic-service         ; Name of
> service template to use
>
>         host_name                 abcd
>
>         service_description             SQL-DB-LOG-GROWTH
>
>         is_volatile                     0
>
>         check_period                    24x7
>
>         max_check_attempts              3
>
>         normal_check_interval           5
>
>         retry_check_interval            1
>
>         contact_groups                  sql-admins
>
>         notification_interval           0
>
>         notification_period             24x7
>
>         notification_options            c,r
>
>         check_command
> check_nrpe_mssql_log_growths!*!5000!9000 ; Log growth scale is 0.01 hence
> 5000 and 9000
>
>   }
>
>
>
>
>
> define command {
>
>                 command_name                    check_nrpe_mssql_log_used
>
>                 command_line                    $USER1$/check_nrpe -t 60 -H
> $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a $HOSTADDRESS$ "$ARG1$"
> "$ARG2$" "$ARG3$"
>
> }
>
>
>
>
>
> define command {
>
>                 command_name
> check_nrpe_mssql_log_growths
>
>                 command_line                    $USER1$/check_nrpe -t 60 -H
> $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a $HOSTADDRESS$ "$ARG1$"
> "$ARG2$" "$ARG3$"
>
> }
>
>
>
> Thanks,
>
> Ravi G
>
> *From:* Greg Pangrazio [mailto:pangrazi at gmail.com]
> *Sent:* Friday, September 10, 2010 6:40 PM
> *To:* Nagios Users List
> *Subject:* Re: [Nagios-users] SQL-DB Services-Unknown Status
>
>
>
> before anyone can help you we need the parts of the config that are
> important here.  Can you give us the command definition, service definition
> and any other relevant part of the config?
>
>
>  On Fri, Sep 10, 2010 at 2:28 AM, <ravishankar.gundlapali at wipro.com>
> wrote:
>
> Hi All,
>
>
>
> Request you to help me on this.
>
>
>
> Thanks,
>
> Ravi G
>
>
>
> *From:* Ravishankar Gundlapali (WT01 - Energy and Utilities)
> *Sent:* Thursday, September 09, 2010 3:42 PM
> *To:* 'Nagios Users List'
> *Subject:* SQL-DB Services-Unknown Status
>
>
>
> Hi,
>
>
>
> I am using Nagios Version 3.0.6 on a Linux server to monitor the
> SQL-DB-LOG-GROWTH and SQL-DB-LOG-USED on the Windows servers.
>
>
>
> For the many of the servers the status information is showing following
> errors. Please see the screenshots below
>
>
>
> 1)      UNKNOWN: No handler for that command
>
> 2)      Unknown - * query: No row returned.
>
> 3)      CHECK_NRPE: Received 0 bytes from daemon. Check the remote server
> logs for error messages.
>
> 4)     Unknown - No data received from WMI:
>
>
>
> I am using the following the check commands
>
>
>
> check_nrpe_mssql_log_used!*!50!90
>
> check_nrpe_mssql_log_growths!*!5000!9000
>
>
>
> Please someone let me know how can I resolve this.
>
>
>
>
>
> Thanks & Regards,
>
> *Ravi G*
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Automate Storage Tiering Simply
> Optimize IT performance and efficiency through flexible, powerful,
> automated storage tiering capabilities. View this brief to learn how
> you can reduce costs and improve performance.
> http://p.sf.net/sfu/dell-sfdev2dev
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when
> reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
>
>
>
> ------------------------------------------------------------------------------
> Automate Storage Tiering Simply
> Optimize IT performance and efficiency through flexible, powerful,
> automated storage tiering capabilities. View this brief to learn how
> you can reduce costs and improve performance.
> http://p.sf.net/sfu/dell-sfdev2dev
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when
> reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/1111e815/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 3787 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/1111e815/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3817 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/1111e815/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3787 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/1111e815/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6116 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100910/1111e815/attachment-0003.png>
-------------- next part --------------
------------------------------------------------------------------------------
Automate Storage Tiering Simply
Optimize IT performance and efficiency through flexible, powerful, 
automated storage tiering capabilities. View this brief to learn how
you can reduce costs and improve performance. 
http://p.sf.net/sfu/dell-sfdev2dev
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null