Advertisement
Kulasangar

Untitled

Nov 1st, 2016
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. input {
  2. jdbc {
  3. jdbc_connection_string => "jdbc:mysql://myhostmachine:3306/report_generation2"
  4. jdbc_user => "root"
  5. jdbc_password => "root"
  6. jdbc_validate_connection => true
  7. jdbc_driver_library => "/oathforthejar/mysql-connector-java-5.1.39-bin.jar"
  8. jdbc_driver_class => "com.mysql.jdbc.Driver"
  9. schedule => "* * * * *"
  10. statement => "SELECT * from tablename"
  11. jdbc_paging_enabled => "true"
  12. jdbc_page_size => "50000"
  13. }
  14. }
  15.  
  16. filter {
  17. date {
  18. match => ["time", "yyyy-MM-dd HH:mm:ss"]
  19. target => "timestamp"
  20. locale => "en"
  21. timezone => "UTC"
  22. }
  23. mutate {
  24. remove_field => ["@timestamp"]
  25. #convert => { "chargeamount" => "float" }
  26. #convert => { "responsecode" => "integer" }
  27. }
  28. }
  29.  
  30. output {
  31. elasticsearch {
  32. #protocol => http
  33. index => "response_summary6"
  34. document_type => "message_logs"
  35. document_id => "%{messagerowid}"
  36. action => index
  37. hosts => ["http://myhostmachine:9402"]
  38. }
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement