Ingest Database Tables to Nagios Log Server

[Sampath.Basireddy]

Hello There,

Is there any possibility of ingesting Oracle database tables to Nagios Log Server?

Thank You,
SB

[mcapra]

Yup:
https://www.elastic.co/guide/en/logstas ... -jdbc.html

A reference implementation:
https://stackoverflow.com/questions/456 ... last-value

With the only major difference being that you don't need the input{} braces when defining Nagios Log Server input rules. So your input rule would look something like this:

Code: Select all

jdbc {
    jdbc_driver_library => "ojdbc6.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@localhost:1521:XE"
    jdbc_user => "******"
    jdbc_password => "******"
    schedule => "* * * * *"
    statement => "SELECT * from SYNC_TABLE where LAST_MODIFICATION >= :sql_last_value"
    tracking_column => "LAST_MODIFICATION"
    tracking_column_type => "timestamp"
    use_column_value => true
  }

[scottwilkerson]

Thanks @mcapra!

[Sampath.Basireddy]

Thank You @mcapra, I will give it a try.

[scottwilkerson]

Thank You @mcapra, I will give it a try.

Let us know if you have further questions