# MySQL connection error

**URL:** <https://discuss.elastic.co/t/mysql-connection-error/151199>\
**Category:** Logstash\
**Created:** [October 5, 2018, 11:04am UTC](https://discuss.elastic.co/t/mysql-connection-error/151199 "2018-10-05T11:04:49Z")\
**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:04am UTC](https://discuss.elastic.co/t/mysql-connection-error/151199/1 "2018-10-05T11:04:49Z")

</div>

input {  
jdbc {  
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/crowdsourcing"  
jdbc\_user =\> "root"  
jdbc\_password =\> "password"  
statement =\> "select \* from tbl\_chatbot\_answers"  
clean\_run =\> true

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

# stdout { codec =\> dots }

}

The above is my config file for sending data from mysql to kibana.  
But it is throwing an error like  
Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#\<LogStash::FilterDelegator:0x58d9f8a @metric\_events\_out=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: out value:0, @metric\_events\_in=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: in value:0, @metric\_events\_time=org.jruby.proxy.org.logstash.instrument.metrics.counter.LongCounter$Proxy2 - name: duration\_in\_millis value:0, @id="c9053c610a1e1af3889c6fb3a4adc3dd108203521e4c20d76fad89aa0efd4273", @klass=LogStash::Filters::Mutate, @metric\_events=#\<LogStash::Instrument::NamespacedMetric:0x3fb788d1 @metric=#\<LogStash::Instrument::Metric:0x1a32f894 @collector=#\<LogStash::Instrument::Collector:0x7cf71326 @agent=nil, @metric\_store=#\<LogStash::Instrument::MetricStore:0x15efa2fd @store=#\<Concurrent:🗺0x00000000000fb0 entries=3 default\_proc=nil\>, @structured\_lookup\_mutex=#Mutex:0x5fcca3f7, @fast\_lookup=#\<Concurrent:🗺0x00000000000fb4 entries=67 default\_proc=nil\>\>\>\>, @namespace\_name=[:stats, :pipelines, :main, :plugins, :filters, :c9053c610a1e1af3889c6fb3a4adc3dd108203521e4c20d76fad89aa0efd4273, :events]\>, @filter=\<LogStash::Filters::Mutate convert=\>{"answer\_id"=\>"int"}, id=\>"c9053c610a1e1af3889c6fb3a4adc3dd108203521e4c20d76fad89aa0efd4273", enable\_metric=\>true, periodic\_flush=\>false\>\>", :error=\>"translation missing: en.logstash.agent.configuration.invalid\_plugin\_register", :thread=\>"#\<Thread:0x4b31541a run\>"}  
[2018-10-05T16:02:45,300][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<LogStash::ConfigurationError: translation missing: en.logstash.agent.configuration.invalid\_plugin\_register\>, :backtrace=\>["C:/ELK/logstash-6.2.3/logstash-6.2.3/vendor/bundle/jruby/2.3.0/gems/logstash-filter-mutate-3.3.1/lib/logstash/filters/mutate.rb:219:in `block in register'", "org/jruby/RubyHash.java:1343:in`each'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/vendor/bundle/jruby/2.3.0/gems/logstash-filter-mutate-3.3.1/lib/logstash/filters/mutate.rb:217:in `register'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:341:in`register\_plugin'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:352:in `block in register_plugins'", "org/jruby/RubyArray.java:1734:in`each'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:352:in `register_plugins'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:736:in`maybe\_setup\_out\_plugins'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:362:in `start_workers'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:289:in`run'", "C:/ELK/logstash-6.2.3/logstash-6.2.3/logstash-core/lib/logstash/pipeline.rb:249:in `block in start'"], :thread=\>"#\<Thread:0x4b31541a run\>"}  
[2018-10-05T16:02:45,453][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: LogStash::PipelineAction::Create/pipeline\_id:main, action\_result: false", :backtrace=\>nil}

---

<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, 5:11pm UTC](https://discuss.elastic.co/t/mysql-connection-error/151199/2 "2018-10-05T17:11:54Z")

</div>

> mutate { convert =\> {"answer\_id" =\> "int"} }

"integer", not "int". See [Mutate filter plugin | Logstash Reference [8.11] | Elastic](https://www.elastic.co/guide/en/logstash/current/plugins-filters-mutate.html#plugins-filters-mutate-convert).

---

<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, 5:11pm UTC](https://discuss.elastic.co/t/mysql-connection-error/151199/3 "2018-11-02T17:11:55Z")

</div>

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