query mysql database and monitor response

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.
Locked
kellyangell
Posts: 18
Joined: Mon Aug 08, 2016 3:20 am

query mysql database and monitor response

Post by kellyangell »

Hi

I would like to get nagios to query the database on a server its monitoring every hour and return the output back depending if the threshold levels have been reached, i can get the monitoring server to connect to the database but is there an easier way of getting nagios to just run a script and send the output back through the monitoring server ?

Thanks
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: query mysql database and monitor response

Post by rkennedy »

is there an easier way of getting nagios to just run a script and send the output back through the monitoring server ?
This is what Nagios does, by using a check_command defined on your host / service, linked to how your command definitions are defined. I'm not sure what you're looking for when you mention an 'easy' way to do it.

Core is our Open Source product, where as Nagios XI is our enterprise product. If you're looking for ease of use, with wizards built in to create your checks, then I would look at Nagios XI. https://www.nagios.com/products/nagios-xi/
Former Nagios Employee
kellyangell
Posts: 18
Joined: Mon Aug 08, 2016 3:20 am

Re: query mysql database and monitor response

Post by kellyangell »

its working now !
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: query mysql database and monitor response

Post by dwhitfield »

Glad to hear it is resolved. I am going to lock the thread. Please feel free to post again if you have you another issue. Thank you for using the Nagios forums!
Locked