...<br>check_command <b>check_mysql_cmdlinecred!user!pass</b> << correct phrase<br>...<br><br>solved...<br><br><br><br><div class="gmail_quote">On Thu, May 5, 2011 at 12:51 PM, The Sinner <span dir="ltr"><<a href="mailto:littlesinner@gmail.com">littlesinner@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">did as in the manual but still no luck at all.<br><br>check this:<br><br>:/usr/lib/nagios/plugins$ ./check_mysql -u nagios -p mypass<br>
Uptime: 93 Threads: 1 Questions: 198 Slow queries: 0 Opens: 1069 Flush tables: 1 Open tables: 64 Queries per second avg: 2.129<br>
<br>the command works fine when i run it on console.<br><br>but it doesn't work when i define it in my services.cfg:<div class="im"><br><br><b>> check_mysql!-H localhost -d mysql -u nagios -p mypass<br>
</b><b>> check_mysql!-H localhost!-d mysql!-u nagios!-p mypass</b><br>
<br></div>i think something wrong with the syntax above. which one is correct? both wrong? what is all "!" about?<div><div></div><div class="h5"><br><br><br><div class="gmail_quote">On Thu, May 5, 2011 at 1:35 AM, John Lewis <span dir="ltr"><<a href="mailto:lewilists@gmail.com" target="_blank">lewilists@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>Reading <a href="http://dev.mysql.com/doc/refman/5.1/en/adding-users.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/adding-users.html</a> it seems like the user for nagios@localhost needs to be created in the database you are trying to grant it access to.</div>
<div><br></div>Did you create the user nagios@localhost in the database?<br><div><div><div><div><br></div><div>Lewis</div><div><div></div><div><div><br></div><div>On May 4, 2011, at 3:16 PM, The Sinner wrote:</div>
<br><blockquote type="cite">hi all,<div><br></div><div>i receive <b>access denied for user 'nagios'@'localhost' (using password no)</b> error.</div><div><br></div><div>what i did so far:</div><div><br></div>
<div>logged in to mysql and selected mysql database then:</div>
<div>> grant all privileges on *.* to 'nagios'@'localhost' identified by 'mypass';</div></blockquote></div></div><blockquote type="cite"><div><div></div><div><div>> flush privileges;</div>
<div><br></div><div>then wrote a service to run the check_mysql command.</div>
<div><br></div><div>the service is like:</div><div><br></div><div>...</div><div>... <b>check_mysql!-H localhost -d mysql -u nagios -p mypass</b></div><div>...<br clear="all"><br></div><div>how should i modify the bold part in my service definition not to receive the error above? do i miss something or write a wrong check_mysql service command?</div>
<div><br></div><div>thanks in advance.</div><div><br>-- <br>The Sinner<br>
</div></div></div>
------------------------------------------------------------------------------<br>WhatsUp Gold - Download Free Network Management Software<br>The most intuitive, comprehensive, and cost-effective network <br>management toolset available today. Delivers lowest initial <br>
acquisition cost and overall TCO of any competing solution.<br><a href="http://p.sf.net/sfu/whatsupgold-sd_______________________________________________" target="_blank">http://p.sf.net/sfu/whatsupgold-sd_______________________________________________</a><br>
Nagiosplug-help mailing list<br><a href="mailto:Nagiosplug-help@lists.sourceforge.net" target="_blank">Nagiosplug-help@lists.sourceforge.net</a><br><a href="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</a><br>
::: Please include plugins version (-v) and OS when reporting any issue. <br>::: Messages without supporting info will risk being sent to /dev/null<br></blockquote></div><br></div></div></div><br>------------------------------------------------------------------------------<br>
WhatsUp Gold - Download Free Network Management Software<br>
The most intuitive, comprehensive, and cost-effective network<br>
management toolset available today. Delivers lowest initial<br>
acquisition cost and overall TCO of any competing solution.<br>
<a href="http://p.sf.net/sfu/whatsupgold-sd" target="_blank">http://p.sf.net/sfu/whatsupgold-sd</a><br>_______________________________________________<br>
Nagiosplug-help mailing list<br>
<a href="mailto:Nagiosplug-help@lists.sourceforge.net" target="_blank">Nagiosplug-help@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/nagiosplug-help" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagiosplug-help</a><br>
::: Please include plugins version (-v) and OS when reporting any issue.<br>
::: Messages without supporting info will risk being sent to /dev/null<br>
<br></blockquote></div><br><br clear="all"><br></div></div>-- <br><font color="#888888">The Sinner<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>The Sinner<br>