[Nagiosplug-help] i need help with check_mysql?

[The Sinner]

did as in the manual but still no luck at all.

check this:

:/usr/lib/nagios/plugins$ ./check_mysql -u nagios -p mypass
Uptime: 93  Threads: 1  Questions: 198  Slow queries: 0  Opens: 1069  Flush
tables: 1  Open tables: 64  Queries per second avg: 2.129

the command works fine when i run it on console.

but it doesn't work when i define it in my services.cfg:

*> check_mysql!-H localhost -d mysql -u nagios -p mypass
**> check_mysql!-H localhost!-d mysql!-u nagios!-p mypass*

i think something wrong with the syntax above. which one is correct? both
wrong? what is all "!" about?


On Thu, May 5, 2011 at 1:35 AM, John Lewis <lewilists at gmail.com> wrote:

> Reading http://dev.mysql.com/doc/refman/5.1/en/adding-users.html it seems
> like the user for nagios at localhost needs to be created in the database you
> are trying to grant it access to.
>
> Did you create the user nagios at localhost in the database?
>
> Lewis
>
> On May 4, 2011, at 3:16 PM, The Sinner wrote:
>
> hi all,
>
> i receive *access denied for user 'nagios'@'localhost' (using password no)
> * error.
>
> what i did so far:
>
> logged in to mysql and selected mysql database then:
> > grant all privileges on *.* to 'nagios'@'localhost' identified by
> 'mypass';
>
> > flush privileges;
>
> then wrote a service to run the check_mysql command.
>
> the service is like:
>
> ...
> ...                 *check_mysql!-H localhost -d mysql -u nagios -p mypass
> *
> ...
>
> 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?
>
> thanks in advance.
>
> --
> The Sinner
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
>
> http://p.sf.net/sfu/whatsupgold-sd_______________________________________________
> Nagiosplug-help mailing list
> Nagiosplug-help at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagiosplug-help
> ::: Please include plugins version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
>
>
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today.  Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd
> _______________________________________________
> Nagiosplug-help mailing list
> Nagiosplug-help at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagiosplug-help
> ::: Please include plugins version (-v) and OS when reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
>


-- 
The Sinner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-plugins.org/archive/help/attachments/20110505/cba2d661/attachment.html>