monitor database queries from url

[rnjie]

we are currently migrating from sitscope to nagios, and we would like to monitor some db queries, i have seen a couple of plugins but they dont seem to do the job, please see screenshot of how its been monitored on sitescope and advice on how to do same on nagios

[mcapra]

Pretty sure the Oracle Query Wizard can do this.

Instructions for getting the Oracle dependencies configured on Nagios XI:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[lmiltchev]

You could probably use the Oracle Query wizard, which ships with XI. It's going to create a check, similar to the one below:

Code: Select all

. /usr/local/nagiosxi/etc/configwizards/oracle/oracle && /usr/local/nagios/libexec/check_oracle_health --connect 'x.x.x.x:1521/xe' --username 'xxx' --password 'xxx' --mode sql --name="<your query>" --warning 50 --critical 200

Once you have one check working, you could clone it in the CCM, add a new/different query in order to monitor something else, save it, and apply configuration.

Read more on installing and configuring Oracle client and plugins here:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf