Page 1 of 1
Nagios Core 3.5.0 / Oracle table new line
Posted: Tue May 10, 2016 4:37 am
by emilianobaccini
Hi everyone,
I've spent several hours looking for a plug-in that raise an alarm each time a new row is inserted in a table (in this case is on an oracle 11g server), but i couldn't find it
nor figure out how to do it.
Does anyone know how can I reach this goal? Via a ready made check or modifying an already existing one.
Thanks in advance
Re: Nagios Core 3.5.0 / Oracle table new line
Posted: Tue May 10, 2016 2:22 pm
by rkennedy
Did you look on our exchange to see if anything would work for you?
https://exchange.nagios.org
From the CLI of the Nagios machine, are you able to produce the current amount of rows per table? If there isn't a current plugin, then you'll have to find that value and then store it in a temp file, and have your next executed check compare the two numbers.
Re: Nagios Core 3.5.0 / Oracle table new line
Posted: Wed May 11, 2016 8:09 am
by emilianobaccini
Hi rkennedy,
thanks for your reply.
I've tried to find something in the exchange that could fit my needs but I couldn't (or maybe my know how is just too low on that). What I got is a table in oracle where all the java exceprtions are stored with different information in each column (timestamp, server, exception and so on) what I need is that NAGIOS should rise an allarm each time a new line is inserted. This alarm sould fetch the information directly from the table so our maintainers can rise a Trouble Ticket properly.
If there's a way to do this I can't figure out how. Can you help me in to find a way to achieve this goal?
Thanks in advance.
Re: Nagios Core 3.5.0 / Oracle table new line
Posted: Wed May 11, 2016 2:05 pm
by rkennedy
emilianobaccini wrote:Hi rkennedy,
thanks for your reply.
I've tried to find something in the exchange that could fit my needs but I couldn't (or maybe my know how is just too low on that). What I got is a table in oracle where all the java exceprtions are stored with different information in each column (timestamp, server, exception and so on) what I need is that NAGIOS should rise an allarm each time a new line is inserted. This alarm sould fetch the information directly from the table so our maintainers can rise a Trouble Ticket properly.
If there's a way to do this I can't figure out how. Can you help me in to find a way to achieve this goal?
Thanks in advance.
You most likely will need to script something out on your own. Do you have anyone on your team that can do so? They can follow these guidelines -
Code: Select all
If there isn't a current plugin, then you'll have to find that value and then store it in a temp file, and have your next executed check compare the two numbers.
You'll need to make find a way to connect to the Oracle DB, and pull that number of rows - perhaps with a query.