Hi all,
I've been banging my head against this for days, and Googled my eyes
out to no avail, so I think it is time to bring this to the list.
I have written a plugin in Python which connects to a database on
another host, runs an arbitrary query, and (depending on the options
passed to it) returns an appropriate Nagios return code. Here is a
typical invocation of this script from the command line:
[EMAIL PROTECTED]:~$ /usr/local/lib/nagios/plugins/dbmon.py -H 10.0.2.9
-u monitor -p password -d testdb -w 10: -c 20: "select count(*) from
users"
OK: 24
As you can see, I'm running this as the Nagios user with no problems.
Here is my command definition:
define command{
command_name check-db-count
command_line /usr/local/lib/nagios/plugins/dbmon.py
-H $HOSTADDRESS$ -u $USER3$ -p $USER4$ -d $ARG1$ -w $ARG3$ -c $ARG4$
$ARG2$
}
$USER3$ and $USER4$ are set in resource.cfg to the appropriate values.
Here is my service definition:
define service{
use generic-service
host_name data.zicasso.com
service_description Example DB Monitor
check_command check-db-count!testdb!"select count(*)
from users"!10:!20:
contact_groups sysadmin
}
I would expect this to work, but the plugin returns '(No output!)'
Basic debugging step is to make sure the command is being run the way
I think it is. So I changed my command definition to:
define command{
command_name check-db-count
command_line echo
/usr/local/lib/nagios/plugins/dbmon.py -H $HOSTADDRESS$ -u $USER3$ -p
$USER4$ -d $ARG1$ -w $ARG3$ -c $ARG4$ $ARG2$ >> /tmp/nagios.log
}
And here is what I see:
/usr/local/lib/nagios/plugins/dbmon.py -H 10.0.2.9 -u monitor -p
password -d testdb -w 10: -c 20: select count(*) from users
Somewhere, the quotes around the SQL statement disappear. And no
amount of backslashing, double-quoting, or anything else will convince
nagios to pass those quotes along to the plugin! I am using Nagios 2.6
on Debian Etch.
I'm also going somewhat nuts over this issue. Any help would be much
appreciated.
Thanks,
Paul
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Nagios-users mailing list
Nagios-users@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
