Page 1 of 1
monitor database queries from url
Posted: Fri Feb 14, 2020 10:20 am
by 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
Re: monitor database queries from url
Posted: Fri Feb 14, 2020 12:16 pm
by 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
Re: monitor database queries from url
Posted: Fri Feb 14, 2020 12:19 pm
by 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