Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
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)
Does the query work without the warning and critical thresholds?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
You most likely need to define the valtype if you want to use thresholds with value types other than integers: http://bucardo.org/check_postgres/check ... stom_query
Are you trying to compare the returned value from the query to your thresholds?
What is the intent of the thresholds?
If the id column from the bank table is not an integer, that would explain the type error.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.