Hi All,
My Config file is
input {
jdbc {
jdbc_driver_library => "/ELK/logstash-6.2.3/mysql-connector-java-5.1.47/mysql-connector-java-5.1.47-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/sakila?useSSL=true&verifyServerCertificate=false&requireSSL=true"
jdbc_user => ""
jdbc_password => "*"
statement => "select * from actor"
clean_run => true
}
}
filter {
mutate { convert => {"actor_id" => "integer"} }
}
output{
elasticsearch {
hosts => ["localhost:9200"]
index => "crowdsourcing"
}
}
But while running in logstash im getting the below error
C:\ELK\logstash-6.2.3\bin>logstash -f test.conf
Sending Logstash's logs to C:/ELK/logstash-6.2.3/logs which is now configured vi
a log4j2.properties
[2018-10-11T11:01:48,380][INFO ][logstash.modules.scaffold] Initializing module
{:module_name=>"fb_apache", :directory=>"C:/ELK/logstash-6.2.3/modules/fb_apache
/configuration"}
[2018-10-11T11:01:48,411][INFO ][logstash.modules.scaffold] Initializing module
{:module_name=>"netflow", :directory=>"C:/ELK/logstash-6.2.3/modules/netflow/con
figuration"}
[2018-10-11T11:01:48,645][WARN ][logstash.config.source.multilocal] Ignoring the
'pipelines.yml' file because modules or command line options are specified
[2018-10-11T11:01:49,286][INFO ][logstash.runner ] Starting Logstash {"
logstash.version"=>"6.2.3"}
[2018-10-11T11:01:50,708][INFO ][logstash.agent ] Successfully started
Logstash API endpoint {:port=>9600}
[2018-10-11T11:01:53,069][INFO ][logstash.pipeline ] Starting pipeline {:
pipeline_id=>"main", "pipeline.workers"=>2, "pipeline.batch.size"=>125, "pipelin
e.batch.delay"=>50}
[2018-10-11T11:01:53,678][INFO ][logstash.outputs.elasticsearch] Elasticsearch p
ool URLs updated {:changes=>{:removed=>, :added=>[http://localhost:9200/]}}
[2018-10-11T11:01:53,694][INFO ][logstash.outputs.elasticsearch] Running health
check to see if an Elasticsearch connection is working {:healthcheck_url=>http:/
/localhost:9200/, :path=>"/"}
[2018-10-11T11:01:53,913][WARN ][logstash.outputs.elasticsearch] Restored connec
tion to ES instance {:url=>"http://localhost:9200/"}
[2018-10-11T11:01:54,100][INFO ][logstash.outputs.elasticsearch] ES Output versi
on determined {:es_version=>6}
[2018-10-11T11:01:54,116][WARN ][logstash.outputs.elasticsearch] Detected a 6.x
and above cluster: the type event field won't be used to determine the documen
t _type {:es_version=>6}
[2018-10-11T11:01:54,131][INFO ][logstash.outputs.elasticsearch] Using mapping t
emplate from {:path=>nil}
[2018-10-11T11:01:54,163][INFO ][logstash.outputs.elasticsearch] Attempting to i
nstall template {:manage_template=>{"template"=>"logstash-*", "version"=>60001,
"settings"=>{"index.refresh_interval"=>"5s"}, "mappings"=>{"default"=>{"dynami
c_templates"=>[{"message_field"=>{"path_match"=>"message", "match_mapping_type"=
"string", "mapping"=>{"type"=>"text", "norms"=>false}}}, {"string_fields"=>{"ma
tch"=>"*", "match_mapping_type"=>"string", "mapping"=>{"type"=>"text", "norms"=>
false, "fields"=>{"keyword"=>{"type"=>"keyword", "ignore_above"=>256}}}}}], "pro
perties"=>{"@timestamp"=>{"type"=>"date"}, "@version"=>{"type"=>"keyword"}, "geo
ip"=>{"dynamic"=>true, "properties"=>{"ip"=>{"type"=>"ip"}, "location"=>{"type"=
"geo_point"}, "latitude"=>{"type"=>"half_float"}, "longitude"=>{"type"=>"half_f
loat"}}}}}}}}
[2018-10-11T11:01:54,225][INFO ][logstash.outputs.elasticsearch] New Elasticsear
ch output {:class=>"LogStash::Outputs::Elasticsearch", :hosts=>["//localhost:920
0"]}
[2018-10-11T11:01:54,647][INFO ][logstash.pipeline ] Pipeline started suc
cesfully {:pipeline_id=>"main", :thread=>"#<Thread:0x22de8119 sleep>"}
[2018-10-11T11:01:54,710][INFO ][logstash.agent ] Pipelines running {:
count=>1, :pipelines=>["main"]}
[2018-10-11T11:01:55,460][ERROR][org.logstash.Logstash ] java.lang.IllegalSta
teException: org.jruby.exceptions.RaiseException: (LoadError) no such file to lo
ad -- /ELK/logstash-6.2.3/bin/mysql-connector-java-5.1.47-bin