# 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 **URL:** \ **Category:** Logstash\ **Created:** [October 11, 2018, 5:51am UTC](https://discuss.elastic.co/t/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/151972 "2018-10-11T05:51:09Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![emma1](https://avatars.discourse-cdn.com/v4/letter/e/74df32/32.png) [@emma1](https://discuss.elastic.co/u/emma1)\ **Post date:** [October 11, 2018, 5:51am UTC](https://discuss.elastic.co/t/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/151972/1 "2018-10-11T05:51:09Z")
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/](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/](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](https://localhost:920) > 0"]} > [2018-10-11T11:01:54,647][INFO][logstash.pipeline] Pipeline started suc > cesfully {:pipeline\_id=\>"main", :thread=\>"#\"} > [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 ---
**Author:** ![Makra](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@Makra](https://discuss.elastic.co/u/Makra)\ **Post date:** [October 11, 2018, 6:35am UTC](https://discuss.elastic.co/t/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/151972/2 "2018-10-11T06:35:23Z")
> [@emma1](#): > > [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 Check if the the JAR file exists in the specified folder ---
**Author:** ![emma1](https://avatars.discourse-cdn.com/v4/letter/e/74df32/32.png) [@emma1](https://discuss.elastic.co/u/emma1)\ **Post date:** [October 11, 2018, 6:51am UTC](https://discuss.elastic.co/t/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/151972/3 "2018-10-11T06:51:03Z")
it is already present inside the logstash bin folder ---
**Author:** ![Makra](https://avatars.discourse-cdn.com/v4/letter/m/8491ac/32.png) [@Makra](https://discuss.elastic.co/u/Makra)\ **Post date:** [October 11, 2018, 7:00am UTC](https://discuss.elastic.co/t/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/151972/4 "2018-10-11T07:00:52Z")
The JAR files not necessarily to be there inside bin folder. Change the path and check if it works. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 8, 2018, 7:00am UTC](https://discuss.elastic.co/t/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/151972/5 "2018-11-08T07:00:53Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.