# "LogStash::ConfigurationError"

**URL:** <https://discuss.elastic.co/t/logstash-configurationerror/151204>\
**Category:** Logstash\
**Created:** [October 5, 2018, 11:43am UTC](https://discuss.elastic.co/t/logstash-configurationerror/151204 "2018-10-05T11:43:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![emma1](https://avatars.discourse-cdn.com/v4/letter/e/74df32/32.png) [@emma1](https://discuss.elastic.co/u/emma1)\
**Post date:** [October 5, 2018, 11:43am UTC](https://discuss.elastic.co/t/logstash-configurationerror/151204/1 "2018-10-05T11:43:44Z")

</div>

Here is my config file of logstash for sending data from MYSQL to Kibana

input {  
jdbc {  
sincedb\_path =\> "/dev/null"  
ignore\_older =\> 0  
jdbc\_driver\_library =\> "ELK/logstash-6.2.3/logstash-6.2.3/bin/mysql-connector-java-5.1.47-bin.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/data"  
jdbc\_user =\> "root"  
jdbc\_password =\> password"  
statement =\> "select \* from tbl\_chatbot\_answers"  
clean\_run =\> true

}  
}

filter {  
mutate { convert =\> {"answer\_id" =\> "integer"} }  
mutate { convert =\> {"rstatus" =\> "integer"} }   
}  
output{  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "crowdsourcing"  
}  
stdout { codec =\> rubydebug { metadata =\> true } }

# stdout { codec =\> dots }

}

Im getting the below error

"LogStash::ConfigurationError", :message=\>"Something is wrong with your configuration.", :backtrace=\>["C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/config/mixin.rb:89:in `config_init'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/inputs/base.rb:62:in`initialize'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/plugins/plugin\_factory.rb:89:in `plugin'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:112:in`plugin'", "(eval):8:in `<eval>'", "org/jruby/RubyKernel.java:994:in`eval'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:84:in `initialize'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:169:in`initialize'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline\_action/create.rb:40:in `execute'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:315:in`block in converge\_state'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:141:in `with_pipelines'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:312:in`block in converge\_state'", "org/jruby/RubyArray.java:1734:in `each'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:299:in`converge\_state'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:166:in `block in converge_state_and_update'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:141:in`with\_pipelines'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:164:in `converge_state_and_update'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/agent.rb:90:in`execute'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/runner.rb:348:in `block in execute'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/vendor/bundle/jruby/2.3.0/gems/stud-0.0.23/lib/stud/task.rb:24:in`block in initialize'"]}

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [October 5, 2018, 1:31pm UTC](https://discuss.elastic.co/t/logstash-configurationerror/151204/2 "2018-10-05T13:31:28Z")

</div>

Start by removing the `sincedb_path` option from your jdbc input. I also recommend that you use an absolute path in the `jdbc_driver_library` option.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 2, 2018, 1:31pm UTC](https://discuss.elastic.co/t/logstash-configurationerror/151204/3 "2018-11-02T13:31:30Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.