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 <br><br><span style="font-size: 10pt; color: rgb(31, 73, 125);">check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a
$HOSTADDRESS$<br><br>with the proper variables from the command line on your nagios server?<br clear="all"></span>Greg Pangrazio<br><br><br>
<br><br><div class="gmail_quote">On Fri, Sep 10, 2010 at 8:49 AM, <span dir="ltr"><<a href="mailto:ravishankar.gundlapali@wipro.com">ravishankar.gundlapali@wipro.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Hi,</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Please see the service definition and command definition which I
am using for SQL-DB-LOG-USED and SQL-DB-LOG-GROWTH.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Request you to provide a clue on this.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">define service{</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> use generic-service
; Name of service template to use</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> host_name abcd</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> service_description SQL-DB-LOG-USED</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> is_volatile 0</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> check_period 24x7</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> max_check_attempts 3</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> normal_check_interval 5</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> retry_check_interval 1</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> contact_groups sql-admins</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_interval 0</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_period 24x7</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_options c,r</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> check_command
check_nrpe_mssql_log_used!*!50!90</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> }</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">define service{</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> use generic-service
; Name of service template to use</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> host_name abcd</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> service_description SQL-DB-LOG-GROWTH</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> is_volatile 0</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> check_period 24x7</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> max_check_attempts 3</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> normal_check_interval 5</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> retry_check_interval 1</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> contact_groups sql-admins</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_interval 0</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_period 24x7</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> notification_options c,r</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> check_command check_nrpe_mssql_log_growths!*!5000!9000
; Log growth scale is 0.01 hence 5000 and 9000</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> }</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">define command {</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> command_name
check_nrpe_mssql_log_used</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> command_line
$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_used -a
$HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">}</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">define command {</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> command_name
check_nrpe_mssql_log_growths</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> command_line
$USER1$/check_nrpe -t 60 -H $HOSTADDRESS$ -p 5666 -c get_mssql_log_growth -a
$HOSTADDRESS$ "$ARG1$" "$ARG2$" "$ARG3$"</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">}</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Thanks,</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Ravi G</span></p>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Greg Pangrazio
[mailto:<a href="mailto:pangrazi@gmail.com" target="_blank">pangrazi@gmail.com</a>] <br>
<b>Sent:</b> Friday, September 10, 2010 6:40 PM<br>
<b>To:</b> Nagios Users List<br>
<b>Subject:</b> Re: [Nagios-users] SQL-DB Services-Unknown Status</span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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?<br>
<br>
<br>
</p>
<div>
<p class="MsoNormal">On Fri, Sep 10, 2010 at 2:28 AM, <<a href="mailto:ravishankar.gundlapali@wipro.com" target="_blank">ravishankar.gundlapali@wipro.com</a>>
wrote:</p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Hi All,</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Request you to help me on this.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Thanks,</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);">Ravi G</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-color: -moz-use-text-color;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
Ravishankar Gundlapali (WT01 - Energy and Utilities) <br>
<b>Sent:</b> Thursday, September 09, 2010 3:42 PM<br>
<b>To:</b> 'Nagios Users List'<br>
<b>Subject:</b> SQL-DB Services-Unknown Status</span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hi,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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<span style="color: rgb(31, 73, 125);"> </span>Windows
servers<span style="color: rgb(31, 73, 125);">.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">For
the many of the servers the status information is showing following errors.
Please see the screenshots below</p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p>1)<span style="font-size: 7pt;"> </span>UNKNOWN:
No handler for that command </p>
<p>2)<span style="font-size: 7pt;"> </span>Unknown
- * query: No row returned. </p>
<p>3)<span style="font-size: 7pt;"> </span>CHECK_NRPE:
Received 0 bytes from daemon. Check the remote server logs for error messages.</p>
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">4)</span><span style="font-size: 7pt; color: rgb(31, 73, 125);"> </span>Unknown -
No data received from WMI: </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">I
am using the following the check commands </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">check_nrpe_mssql_log_used!*!50!90</p>
<p class="MsoNormal">check_nrpe_mssql_log_growths!*!5000!9000</p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">Please
someone let me know how can I resolve this. </p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image001.png@01CB511D.091602D0" height="64" width="672" border="0"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image002.png@01CB511D.091602D0" height="62" width="671" border="0"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image003.png@01CB511D.091602D0" height="127" width="674" border="0"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"><img src="cid:image004.png@01CB511D.091602D0" height="67" width="654" border="0"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;">Thanks
& Regards,</span></p>
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;">Ravi G</span></b></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Book Antiqua","serif"; color: black;"> </span></p>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><br>
------------------------------------------------------------------------------<br>
Automate Storage Tiering Simply<br>
Optimize IT performance and efficiency through flexible, powerful,<br>
automated storage tiering capabilities. View this brief to learn how<br>
you can reduce costs and improve performance.<br>
<a href="http://p.sf.net/sfu/dell-sfdev2dev" target="_blank">http://p.sf.net/sfu/dell-sfdev2dev</a><br>
_______________________________________________<br>
Nagios-users mailing list<br>
<a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>
::: Please include Nagios version, plugin version (-v) and OS when reporting
any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null</p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
<br>------------------------------------------------------------------------------<br>
Automate Storage Tiering Simply<br>
Optimize IT performance and efficiency through flexible, powerful,<br>
automated storage tiering capabilities. View this brief to learn how<br>
you can reduce costs and improve performance.<br>
<a href="http://p.sf.net/sfu/dell-sfdev2dev" target="_blank">http://p.sf.net/sfu/dell-sfdev2dev</a><br>_______________________________________________<br>
Nagios-users mailing list<br>
<a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><br>
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null<br></blockquote></div><br>