Hello i running logstash 6.7.1. it fresh installation, but not storing any data to elasticsearch.
[2019-04-12T11:10:38,459][INFO ][logstash.pipeline ] Starting pipeline {:pipeline_id=>"redemptionneeds", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50}
[2019-04-12T11:10:39,285][INFO ][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>[], :added=>[http://127.0.0.1:9200/]}}
[2019-04-12T11:10:39,653][WARN ][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://127.0.0.1:9200/"}
[2019-04-12T11:10:39,726][INFO ][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>6}
[2019-04-12T11:10:39,735][WARN ][logstash.outputs.elasticsearch] Detected a 6.x and above cluster: the `type` event field won't be used to determine the document _type {:es_version=>6}
[2019-04-12T11:10:39,830][INFO ][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://127.0.0.1:9200/"]}
[2019-04-12T11:10:40,300][INFO ][logstash.pipeline ] Pipeline started successfully {:pipeline_id=>"redemptionneeds", :thread=>"#<Thread:0x20d0ff2e run>"}
[2019-04-12T11:10:40,489][INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:redemptionneeds], :non_running_pipelines=>[]}
[2019-04-12T11:10:41,080][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}
[2019-04-12T11:20:04,647][WARN ][logstash.runner ] SIGTERM received. Shutting down.
This is my config.
input {
jdbc {
jdbc_driver_library => "/usr/local/etc/sqljdbc_7.2/enu/mssql-jdbc-7.2.1.jre11.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://*************;databaseName=**********"
jdbc_user => "*****"
jdbc_password => "**********"
schedule => "*/5 * * * *"
statement_filepath => "/etc/logstash/sql/RedemptionNeeds.sql"
jdbc_paging_enabled => true
jdbc_page_size => 50000
last_run_metadata_path => "/usr/share/logstash/.logstash_jdbc_last_run_RedemptionNeeds"
}
}
output {
elasticsearch {
hosts => ["http://127.0.0.1:9200/"]
index => "redemptionneeds"
document_type => "redemption"
document_id => "%{id}"
manage_template => false
}
}
Verry need your help, i thank you first.