nagiosxi and check_postgres question

[jellydog]

Hi, I am having trouble configuring Nagios XI to use check_postgres_locks. I am running NagiosXI in Amazon EC2 and have installed monitoring wizards from Nagios Exchange. In particular, I installed Postgres Database Monitoring Wizard which I believe is using check_postgres.pl. Choosing the wizard gives me a limited number of items to monitor including Connection Status, Database Size, Table Sizes, Relational Sizes and Sequences. I successfully am using the Connection Status but now want to use one for monitoring locks (check_postgres_locks). I cannot seem to get the syntax correct to make this check work.
I created a Service monitor in nagios core config manager and applied the template xiwizard_postgresdb_service. I set the check command to check_xi_postgres_db, set ARG1$=check_postgres_locks and ARG2$= -H {my host ip address} --warning=200 --critical="total=250;waiting=5;exclusive=20"

Applying the configuration succeeds but when I check the status, it appears in a 'warning' state and the word 'null' appears.
Is there more information I need to provide in the arguments or am I going about this all wrong?

thanks for any assistance.

[yancy]

jellydog,

I'm not very familiar with Amazon EC2, but generally when i'm troubleshooting a plugin, I test from the command line if i'm having trouble. Do you have the ability to SSH to the VM?

if so, you can run the commands from a shell

Code: Select all

 cd /usr/local/nagios/libexec
./check_postgres.pl check_postgres_locks check_postgres_locks  --warning=200 --critical="total=250;waiting=5;exclusive=20" 

does that return expected output?

-Yancy