check_mysql messed up by passwd, $ appended to request.

Andreas Ericsson ae at op5.se
Tue Oct 25 22:08:44 CEST 2005


John Stile wrote:
> I'm trying to use check_nrpe to run check_mysql on a monitored client.
> It seems that the mysql passwd is messing up check_mysql.
> 
> On the client to be monitored, I get a vaid response from: 
> /usr/lib/nagios/plugins/check_mysql -uroot -p'Blr$3%' -P3306
> or 
> /usr/lib/nagios/plugins/check_mysql -uroot -pBlr\$3\% -P3306
> 
> I setup nrpe.conf on the client, and turned on debugging.
> nrpe.conf has:
> command[check_mysql]=/usr/lib/nagios/plugins/check_mysql -uroot -pBlr\$3\%c -P3306
> 
> When I issue the check_nrpe from the nagios server, a '$' is appended to
> the end of the line once the request (seen in debug output on client).
> This does not happen for the other checks in nrpe.conf
> 

This is due to a bug in the macro interpolation code (which was 
inherited from Nagios). It doesn't recognize the fact that it failed to 
find a complete macro, so it adds a closing dollar-sign at the end of 
the command if they aren't in even pairs. You can escape dollar-signs 
with another dollar-sign, like so;

check_mysql -uroot -p'Blr$$3%c'

and it should work. The single quotes are to escape the dollar-signs for 
the shell.

Granted, it shouldn't touch it in the first place, and I'll have this 
fixed by the end of the week. In the meantime the double-dollar sign 
escape thing is the way to go. That syntax will be maintained for 
backwards compatibility btw, so nothing will break later if you add it.

>>From the server:
>  /usr/lib/nagios/plugins/check_nrpe -H bugzilla.stilen.com -c check_mysql 
> 
> On the client debug log:
> Oct 25 11:13:20 bugzilla nrpe[15494]: Connection from 192.168.0.195 port 25005
> Oct 25 11:13:20 bugzilla nrpe[15494]: Host address checks out ok
> Oct 25 11:13:20 bugzilla nrpe[15494]: Handling the connection...
> Oct 25 11:13:20 bugzilla nrpe[15494]: Host is asking for command 'check_mysql' to be run...
> Oct 25 11:13:20 bugzilla nrpe[15494]: Running command: /usr/lib/nagios/plugins/check_mysql -uroot -pBlr\$3\%c -P3306$
> Oct 25 11:13:20 bugzilla nrpe[15494]: Command completed with return code 2 and output: Access denied for user 'root'@'localhost' (using password: YES)
> Oct 25 11:13:20 bugzilla nrpe[15494]: Return Code: 2, Output: Access denied for user 'root'@'localhost' (using password: YES)
> Oct 25 11:13:20 bugzilla nrpe[15494]: Connection from 192.168.0.195 closed.
> 
> I have been playing with the nrpe.conf configuration trying to find the
> correct thing to do.  Any help would be appreciated.  
> 
> This is a list of the nrpe.conf lines I've tired:
> command[check_mysql]=/usr/lib/nagios/plugins/check_mysql -H localhost -u root -p 'Blr$3%'
> command[check_mysql]=/usr/lib/nagios/plugins/check_mysql --hostname='localhost' --username='root' --password='Blr$3%'
> command[check_mysql]=/usr/lib/nagios/plugins/check_mysql -u 'root' -p 'Blr$3%'
> command[check_mysql]=/usr/lib/nagios/plugins/check_mysql -H 'localhost' -u 'root' -p 'Blr$e%'
> 
> I have also tried to pass the username and passwd as arguments from the
> nagios server, also with no luck. 
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> 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
> 

-- 
Andreas Ericsson                   andreas.ericsson at op5.se
OP5 AB                             www.op5.se
Tel: +46 8-230225                  Fax: +46 8-230231


-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
Free Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
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





More information about the Users mailing list