check_postgres.pl - Invalid format returned by custom query
Posted: Tue Aug 19, 2014 1:57 am
Hi,
I want to use custom query with check_postgres.pl but have a problem query return Invalid format returned by custom query and add warning and critical value to result (15,20)
I want to use custom query with check_postgres.pl but have a problem query return Invalid format returned by custom query and add warning and critical value to result (15,20)
Code: Select all
root@ubuntu:/usr/local/nagios/libexec# check_postgres.pl -H 192.168.1.100 -p 5333 -db XXX -dbuser postgres -dbpass XXX -w 15 -c 20 --action custom_query --query="select id from bank where column1='ZZZ'"Code: Select all
POSTGRES_CUSTOM_QUERY UNKNOWN: DB "XXX" (host:192.168.1.100) (port=5333) Invalid format returned by custom query | time=0.32s id=10;15;20