# Logstash-6.2.4 Error while running conf **URL:** \ **Category:** Logstash\ **Created:** [May 23, 2018, 11:12am UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982 "2018-05-23T11:12:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\ **Post date:** [May 23, 2018, 11:12am UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/1 "2018-05-23T11:12:52Z")
> Plugin:LogStash::Inputs::Jdbc jdbc\_connection\_string=\>"jdbc:mysql://localhost:3306/pall\_new", jdbc\_user=\>"root", jdbc\_password=\>, jdbc\_validate\_connection=\>true, jdbc\_driver\_library=\>"home/vadim/www/Full/Search/logstash-6.2.4/mysql-connector-java-5.1.42.jar", jdbc\_driver\_class=\>"Java::oracle.jdbc.driver.OracleDriver", statement=\>"SELECT products\_id, products\_name FROM products\_description", id=\>"b6ca01ee0dc3c734a39863d404734e9e920f232dedd95d747220deb7bafef7e6", enable\_metric=\>true, codec=\>\"plain\_b7a7ab6e-0e21-4273-ac35-524b39c2352d", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, parameters=\>{"sql\_last\_value"=\>2018-05-22 17:01:44 +0300}, last\_run\_metadata\_path=\>"/home/vadim/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\> > Error: Java::oracle.jdbc.driver.OracleDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? > Exception: LogStash::ConfigurationError > Stack: /home/vadim/www/FULL/Search/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/plugin\_mixins/jdbc.rb:162:in `open_jdbc_connection' /home/vadim/www/FULL/Search/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/plugin_mixins/jdbc.rb:220:in `execute\_statement' > /home/vadim/www/FULL/Search/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/inputs/jdbc.rb:264:in `execute_query' /home/vadim/www/FULL/Search/logstash-6.2.4/vendor/bundle/jruby/2.3.0/gems/logstash-input-jdbc-4.3.9/lib/logstash/inputs/jdbc.rb:250:in `run' > /home/vadim/www/FULL/Search/logstash-6.2.4/logstash-core/lib/logstash/pipeline.rb:514:in `inputworker' /home/vadim/www/FULL/Search/logstash-6.2.4/logstash-core/lib/logstash/pipeline.rb:507:in `block in start\_input' > [2018-05-23T14:06:04,151][ERROR][logstash.pipeline] A plugin had an unrecoverable error. Will restart this plugin. > Pipeline\_id:main ![Selection_466](https://us1.discourse-cdn.com/elastic/original/3X/4/3/43e772fd56a9c5230f5c39016a7d7154f8cf9c6b.png) ---
**Author:** ![arkady\_renko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arkady_renko/32/30160_2.png) [@arkady\_renko](https://discuss.elastic.co/u/arkady_renko)\ **Post date:** [May 23, 2018, 12:03pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/2 "2018-05-23T12:03:14Z")
Hi, You are trying to connect MySQL database. Why are you using oracle jdbc driver class? ---
**Author:** ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\ **Post date:** [May 23, 2018, 12:30pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/3 "2018-05-23T12:30:51Z")
I change jdbc\_driver\_class =\> "com.mysql.jdbc.Driver" But the same mistake Error: com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? ---
**Author:** ![arkady\_renko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arkady_renko/32/30160_2.png) [@arkady\_renko](https://discuss.elastic.co/u/arkady_renko)\ **Post date:** [May 23, 2018, 1:39pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/4 "2018-05-23T13:39:07Z")
> [@Vadim\_Klimenko](#): > > jdbc\_driver\_library=\>"home/vadim/www/Full/Search/logstash-6.2.4/mysql-connector-java-5.1.42.jar" "/" missing in mysql jdbc driver path. Try with adding slash. ---
**Author:** ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\ **Post date:** [May 23, 2018, 1:49pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/5 "2018-05-23T13:49:54Z")
jdbc\_driver\_library =\> "/home/vadim/www/Full/Search/logstash-6.2.4/mysql-connector-java-8.0.11.jar" but I have the same error. Error: com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library? Exception: LogStash::ConfigurationError ---
**Author:** ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\ **Post date:** [May 23, 2018, 2:40pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/6 "2018-05-23T14:40:42Z")
I move file to /var/www/ and error fixed. But in the end I have another error: [2018-05-23T17:39:03,383][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>"main", :thread=\>"#\"} ---
**Author:** ![arkady\_renko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arkady_renko/32/30160_2.png) [@arkady\_renko](https://discuss.elastic.co/u/arkady_renko)\ **Post date:** [May 23, 2018, 3:34pm UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/7 "2018-05-23T15:34:03Z")
I don't think it is an error log. Did you check elasticsearch index? ---
**Author:** ![Vadim\_Klimenko](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vadim_klimenko/32/31511_2.png) [@Vadim\_Klimenko](https://discuss.elastic.co/u/Vadim_Klimenko)\ **Post date:** [May 24, 2018, 8:52am UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/8 "2018-05-24T08:52:30Z")
Yes > {"products":{"aliases":{},"mappings":{"products\_description":{"properties":{"@timestamp":{"type":"date"},"@version":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"categories\_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"products\_id":{"type":"long"},"products\_keywords":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"products\_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"products\_page\_url":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}}},"settings":{"index":{"creation\_date":"1527086229995","number\_of\_shards":"5","number\_of\_replicas":"1","uuid":"gXOja3AwSviIGD0kcn32sg","version":{"created":"6020499"},"provided\_name":"products"}}}} ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 21, 2018, 8:52am UTC](https://discuss.elastic.co/t/logstash-6-2-4-error-while-running-conf/132982/9 "2018-06-21T08:52:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.