[Nagiosplug-devel] [ nagiosplug-Patches-1851035 ] check_mysql_query -- Check value of specified column

[SourceForge.net]

Patches item #1851035, was opened at 2007-12-14 20:37
Message generated for change (Comment added) made by pcervicek
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=1851035&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Enhancement
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Greg Wittel (glwittel)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_mysql_query -- Check value of specified column

Initial Comment:
Currently check_mysql_query only reads the value from the first column of the first row.  This patch lets you specify the column number to read the result from instead.  

This is useful since some queries (like the 'show') queries do not give you control over the columns returned.

If the column argument is not given, the current behavior of reading the first column is used.  This patch numbers columns starting from '0', but that is easy enough to change.

----

Patch against Plugin Version (-V output): check_mysql_query N/A (nagios-plugins 1.4.11)

Plugin Name: check_mysql_query

Example Plugin Commandline:
./check_mysql_query -H test -q 'show slave status' --column 32

Tested on operating system: Linux robotron 2.6.10-1.770
Tested on architecture: i686
Tested with compiler: gcc version 3.3.3 20040412 (Red Hat Linux 3.3.3-7)

Diff generated vs. SVN revision: 1590 off trunk.

----------------------------------------------------------------------

Comment By: Patrick Cervicek (pcervicek)
Date: 2007-12-21 12:13

Message:
Logged In: YES 
user_id=1963684
Originator: NO

A Typo in print_help() "unless -c says otherwise"
it should be a big -C (or --column)


----------------------------------------------------------------------

Comment By: Greg Wittel (glwittel)
Date: 2007-12-14 20:39

Message:
Logged In: YES 
user_id=1297361
Originator: YES

Forgot to attach the diff ;o)

Generated via: diff -Naur

File Added: check_mysql_query.c.diff

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=1851035&group_id=29880