SQL-DB Services-Unknown Status

[Greg Pangrazio]

Did you write get_mssql_log_used?  It does not seem to be returning
according to the standard nagios requirements.

see http://nagiosplug.sourceforge.net/developer-guidelines.html

Greg Pangrazio




On Mon, Sep 13, 2010 at 4:21 AM, <ravishankar.gundlapali at wipro.com> wrote:

>  Hi All,
>
>
>
> Request you to provide any clue on this.
>
>
>
> Thanks,
>
> Ravi G
>
>
>
> *From:* Ravishankar Gundlapali (WT01 - Energy and Utilities)
> *Sent:* Friday, September 10, 2010 9:43 PM
> *To:* Nagios Users List
> *Cc:* 'pangrazi at gmail.com'
> *Subject:* RE: [Nagios-users] SQL-DB Services-Unknown Status
>
>
>
> When I ran the command ./check_nrpe -t 60 -H <Hostname> -p 5666
> get_mssql_log_used
>
>
>
>  I got the below output….
>
> I (0.3.5.1 2008-09-24) seem to be doing fine...
>
>
>
> Please provide any clue…
>
>
>
> Regards,
>
> Ravi G
>
>
>
>
>
> *From:* Greg Pangrazio [mailto:pangrazi at gmail.com]
> *Sent:* Friday, September 10, 2010 8:22 PM
>
> *To:* Nagios Users List
> *Subject:* Re: [Nagios-users] SQL-DB Services-Unknown Status
>
>
>
> 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
>
>
>
> * Please do not print this email unless it is absolutely necessary. *
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100915/d1366ec6/attachment.html>
-------------- 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/20100915/d1366ec6/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/20100915/d1366ec6/attachment-0001.png>
-------------- 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/20100915/d1366ec6/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/20100915/d1366ec6/attachment-0003.png>
-------------- next part --------------
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-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