Page 1 of 1

query mysql database and monitor response

Posted: Tue Oct 11, 2016 4:26 am
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

Re: query mysql database and monitor response

Posted: Tue Oct 11, 2016 11:02 am
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/

Re: query mysql database and monitor response

Posted: Tue Oct 18, 2016 4:36 am
by kellyangell
its working now !

Re: query mysql database and monitor response

Posted: Tue Oct 18, 2016 10:29 am
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!