Advertisement
Guest User

Untitled

a guest
May 10th, 2017
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
YAML 0.72 KB | None | 0 0
  1.   jdbc {
  2.     type => "ash_oracle"
  3.     jdbc_validate_connection => true
  4.     jdbc_connection_string => "jdbc:oracle:thin:@xxxxx:4321/1234"
  5.     jdbc_user => "aaaaaa"
  6.     jdbc_password => "qwertyu"
  7.     jdbc_driver_library => "/etc/logstash/jdbc/ojdbc8.jar"
  8.     jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
  9.     statement => "SELECT * FROM dba_audit_trail WHERE sessionid > :sql_last_value"
  10.     last_run_metadata_path => "/mnt/elk_backups/logstash_last_run/logstash-oradb.lastrun"
  11.     use_column_value => true
  12.     tracking_column => sessionid
  13.     record_last_run => true
  14.     clean_run => false
  15.     jdbc_paging_enabled => true
  16.     jdbc_page_size => 1000
  17.     sql_log_level => debug
  18.     schedule => "* * * * *"
  19.   }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement