Your message dated Thu, 25 Oct 2007 08:28:37 +0200
with message-id <[EMAIL PROTECTED]>
and subject line [Pkg-nagios-devel] Bug#447529: nagios-plugins: 
check_mysql_cmdlinecred command line syntax error
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---
Package: nagios-plugins
Version: 1.4.5-1
Severity: important
Tags: patch


mysql.cfg appears to assume that "-H hostname" specifies a host and "-p 
password" specifies a password. In fact "-H" specifes "use HTML output", 
the $HOSTADDRESS$ value is treated as a database name, "-p" specifies 
"prompt me for a password" and $ARG2$ would be another database name if 
it weren't a syntax error to specify two of them.

The correct command line syntax for MySQL 5 (as shipped with Etch) is:
/usr/lib/nagios/plugins/check_mysql -h $HOSTADDRESS$ -u $ARG1$ -p$ARG2$

(which uses $HOSTADDRESS$ as the host, $ARG1$ as the username and $ARG2$ 
as the password).

To make this as simple as possible to fix I have also included a patch 
that corrects the arguments:

--- /tmp/mysql.cfg      2007-10-21 19:08:14.000000000 -0300
+++ mysql.cfg   2007-10-21 19:11:16.000000000 -0300
@@ -7,5 +7,5 @@
 # 'check_mysql_cmdlinecred' command definition
 define command{
        command_name    check_mysql_cmdlinecred
-       command_line    /usr/lib/nagios/plugins/check_mysql -H $HOSTADDRESS$ -u 
$ARG1$ -p $ARG2$
+       command_line    /usr/lib/nagios/plugins/check_mysql -h $HOSTADDRESS$ -u 
$ARG1$ -p$ARG2$
 }


-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-5-686
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)

Versions of packages nagios-plugins depends on:
ii  nagios-plugins-basic          1.4.5-1    Plugins for the nagios network mon
ii  nagios-plugins-standard       1.4.5-1    Plugins for the nagios network mon

nagios-plugins recommends no packages.

-- no debconf information
--- /tmp/mysql.cfg      2007-10-21 19:08:14.000000000 -0300
+++ mysql.cfg   2007-10-21 19:11:16.000000000 -0300
@@ -7,5 +7,5 @@
 # 'check_mysql_cmdlinecred' command definition
 define command{
        command_name    check_mysql_cmdlinecred
-       command_line    /usr/lib/nagios/plugins/check_mysql -H $HOSTADDRESS$ -u 
$ARG1$ -p $ARG2$
+       command_line    /usr/lib/nagios/plugins/check_mysql -h $HOSTADDRESS$ -u 
$ARG1$ -p$ARG2$
 }

--- End Message ---
--- Begin Message ---
On Monday 22 October 2007 12:21:15 am Chris Watt wrote:
> mysql.cfg appears to assume that "-H hostname" specifies a host and "-p
> password" specifies a password. In fact "-H" specifes "use HTML output",
> the $HOSTADDRESS$ value is treated as a database name, "-p" specifies
> "prompt me for a password" and $ARG2$ would be another database name if
> it weren't a syntax error to specify two of them.

er, no, -H *does* specify the hostname for *check_mysql*, which is not the 
same thing as the mysql cmdline client.  have you actually tried this before 
reporting it?



        sean

Attachment: signature.asc
Description: This is a digitally signed message part.


--- End Message ---

Reply via email to