nrpe problem using check_mysql_all k- connections with MYSQL 5.5+

[GoogleCodeExporter]

Hi,

in a remote server the command "check_mysql_all -K connections --username=root 
--password='pass' -w 80% -c 90%" works fine.
[COMMAND OUTPUT: OK: 2/215 (1%) connections are 
used|connections=2;172;193;0;215]

If i try to use the same command with nrpe "check_nrpe -H remote_hostname -c 
check_mysql_conn" i'll get the following output
[NRPE COMMAND OUTPUT: UNKNOWN: 'critical' should contain a positive integer (in 
percent]

below the command definition in nrpe.cfg file:

command[check_mysql_conn]=/usr/lib64/nagios/plugins/check_mysql_all -K 
connections --username=root --password='pass' -w 80% -c 90%

Environnement info:
mysql --version: 5.5.27
NRPE version 2.12

Original issue reported on code.google.com by andrea.s...@bdsconsulting.it on 31 Oct 2012 at 1:32

[GoogleCodeExporter]

Hi all,

if i use normal check - not nrpe - the behavior is the same:
Command in localhost server bash: check_mysql_all -K connections 
--username=root --password='pass' -w 80% -c 90%
Command output: OK: 15/145 (10%) connections are 
used|connections=15;116;130;0;145]

Command in file commands.cfg: $USER1$/check_mysql_all -K connections 
--username=root --password='pass' -w 80% -c 90%
Command output in nagios web console: UNKNOWN: 'critical' should contain a 
positive integer (in percent).

Environnemento info: nagios core Version 3.2.3
Thz

Original comment by andrea.s...@bdsconsulting.it on 31 Oct 2012 at 3:13