Nagios Core 3.5.0 / Oracle table new line

[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

[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.

[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.

[rkennedy]

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.