Page 1 of 1
Ingest Database Tables to Nagios Log Server
Posted: Mon Dec 17, 2018 11:42 am
by Sampath.Basireddy
Hello There,
Is there any possibility of ingesting Oracle database tables to Nagios Log Server?
Thank You,
SB
Re: Ingest Database Tables to Nagios Log Server
Posted: Mon Dec 17, 2018 1:43 pm
by 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
}
Re: Ingest Database Tables to Nagios Log Server
Posted: Mon Dec 17, 2018 3:08 pm
by scottwilkerson
Re: Ingest Database Tables to Nagios Log Server
Posted: Mon Dec 17, 2018 4:43 pm
by Sampath.Basireddy
Thank You
@mcapra, I will give it a try.
Re: Ingest Database Tables to Nagios Log Server
Posted: Mon Dec 17, 2018 5:22 pm
by scottwilkerson
Sampath.Basireddy wrote:Thank You
@mcapra, I will give it a try.
Let us know if you have further questions