When i run config file it stucks at Successfully started Logstash API endpoint {:port=>9600}, Nothing happens after this. Could you please help me to resolve this. Earlier it was working fine with this config
My Config file is as below
input {
jdbc {
#input Configuration
jdbc_connection_string => "jdbc:oracle:thin:@sgtd37-scan.net:8889/CWS"
jdbc_user => "ACT_TM"
jdbc_password => "*****"
jdbc_driver_library => "I:\Jars\ojdbc6.jar"
jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
statement => "select ALERT_ID, regexp_replace(regexp_substr(html_file_key,'<elem name="alertDate">(.?)'),'<elem name="alertDate">|','') as alertDate from alerts where DELETED =0 and rownum<=100000 order by create_date desc"
}
}
output {
elasticsearch {
#output configuration
hosts => "http://localhost:9200"
index => "alert_index"
document_type => "alert"
#document_id => "%{alert_internal_id}"
}
stdout{
codec => rubydebug
{
metadata => true
}
}
}
Logs:
[2019-03-12T12:03:01,988][INFO ][logstash.pipeline ] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>2, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50}
[2019-03-12T12:03:02,812][INFO ][logstash.outputs.elasticsearch] Elasticsearch pool URLs updated {:changes=>{:removed=>, :added=>[http://localhost:9200/]}}
[2019-03-12T12:03:03,349][WARN ][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://localhost:9200/"}
[2019-03-12T12:03:03,480][INFO ][logstash.outputs.elasticsearch] ES Output version determined {:es_version=>6}
[2019-03-12T12:03:03,489][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-03-12T12:03:03,607][INFO ][logstash.outputs.elasticsearch] New Elasticsearch output {:class=>"LogStash::Outputs::ElasticSearch", :hosts=>["http://localhost:9200"]}
[2019-03-12T12:03:03,686][INFO ][logstash.outputs.elasticsearch] Using mapping template from {:path=>nil}
[2019-03-12T12:03:03,784][INFO ][logstash.outputs.elasticsearch] Attempting to install template {:manage_template=>{"template"=>"logstash-", "version"=>60001, "settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"default"=>{"dynamic_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"match"=>"", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "properties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geoip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=>"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_float"}}}}}}}}
[2019-03-12T12:03:04,945][INFO ][logstash.pipeline ] Pipeline started successfully {:pipeline_id=>"main", :thread=>"#<Thread:0x20948060 sleep>"}
[2019-03-12T12:03:05,009][INFO ][logstash.agent ] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>}
[2019-03-12T12:03:08,645][INFO ][logstash.agent ] Successfully started Logstash API endpoint {:port=>9600}