# Input mariadb 5.5.47 in logstash 2.3

**URL:** <https://discuss.elastic.co/t/input-mariadb-5-5-47-in-logstash-2-3/51244>\
**Category:** Logstash\
**Created:** [May 29, 2016, 11:05am UTC](https://discuss.elastic.co/t/input-mariadb-5-5-47-in-logstash-2-3/51244 "2016-05-29T11:05:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![srneodani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srneodani/32/10011_2.png) [@srneodani](https://discuss.elastic.co/u/srneodani)\
**Post date:** [May 29, 2016, 11:05am UTC](https://discuss.elastic.co/t/input-mariadb-5-5-47-in-logstash-2-3/51244/1 "2016-05-29T11:05:39Z")

</div>

Hi,

I was setting logstash to load data from my data base MariaDB, but no way.

I installed the plugins:  
logstash-output-influxdb  
logstash-input-jdbc

And I downloaded the connectors  
mysql-connector-java-5.1.36-bin.jar  
mysql-connector-java-5.1.39-bin.jar  
MariaDB-java-client-1.4.5.jar

Has anyone been able to upload data to a database MariaDB to logstash?

I'm using MariaDB version 5.5.47

And my configuration file:

input {  
jdbc {  
jdbc\_driver\_library =\> "/opt/mariadb-java-client-1.4.5.jar"  
jdbc\_connection\_string =\> "jdbc:mariadb://127.0.0.1:3306/employees"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_user =\> "root"  
jdbc\_password =\> 'xxxxxxxxxxxx'  
statement =\> "select \* from employees"  
schedule =\> "\*/1 \* \* \* \*"  
type =\> "employees"  
}  
}  
output {  
if [type] == "employees" {  
influxdb {  
host =\> "127.0.0.1"  
port =\> 8086  
db =\> "employees"  
user =\> "grafana"  
password =\> "xxxxxxxxxxxx"  
measurement =\> "employees"  
send\_as\_tags =\> ["emp\_no", "birth\_date", "first\_name", "last\_name", "gender", "hire\_date"]  
data\_points =\> {  
"emp\_no" =\> "%{emp\_no}"  
"birth\_date" =\> "%{birth\_date}"  
"first\_name" =\> "%{first\_name}"  
"last\_name" =\> "%{last\_name}"  
"gender" =\> "%{gender}"  
"hire\_date" =\> "%{hire\_date}"  
}  
}  
}  
}

I tried:

```
    jdbc_driver_library => "/opt/mysql-connector-java-5.1.36-bin.jar"
    jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/employees"

    jdbc_driver_library => "/opt/mysql-connector-java-5.1.39-bin.jar"
    jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/employees"

    jdbc_driver_library => "/opt/mariadb-java-client-1.4.5.jar"
    jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/employees"

    jdbc_driver_library => "/opt/mariadb-java-client-1.4.5.jar"
    jdbc_connection_string => "jdbc:mariadb://127.0.0.1:3306/employees"

```

Thank you so much!

---

<div class="post-metadata">

**Author:** ![srneodani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/srneodani/32/10011_2.png) [@srneodani](https://discuss.elastic.co/u/srneodani)\
**Post date:** [May 29, 2016, 11:06am UTC](https://discuss.elastic.co/t/input-mariadb-5-5-47-in-logstash-2-3/51244/2 "2016-05-29T11:06:44Z")

</div>

The error when I put mysql connector is:

{:timestamp=\>"2016-05-29T12:47:01.714000+0200", :message=\>"Failed to flush outgoing items", :outgoing\_count=\>1, :exception=\>"NoMethodError", :backtrace=\>["/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:348:in `escaped'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:226:in`events\_to\_request\_body'", "org/jruby/RubyHash.java:1342:in `each'", "org/jruby/RubyEnumerable.java:757:in`map'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:226:in `events_to_request_body'", "org/jruby/RubyArray.java:2414:in`map'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:224:in `events_to_request_body'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:171:in`flush'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/stud-0.0.22/lib/stud/buffer.rb:221:in `buffer_flush'", "org/jruby/RubyHash.java:1342:in`each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/stud-0.0.22/lib/stud/buffer.rb:216:in `buffer_flush'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/stud-0.0.22/lib/stud/buffer.rb:159:in`buffer\_receive'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-output-influxdb-3.1.2/lib/logstash/outputs/influxdb.rb:165:in `receive'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/outputs/base.rb:83:in`multi\_receive'", "org/jruby/RubyArray.java:1613:in `each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/outputs/base.rb:83:in`multi\_receive'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/output\_delegator.rb:130:in `worker_multi_receive'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/output_delegator.rb:114:in`multi\_receive'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:301:in `output_batch'", "org/jruby/RubyHash.java:1342:in`each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:301:in `output_batch'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:232:in`worker\_loop'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:201:in `start\_workers'"], :level=\>:warn}

And with mariadb conector  
{:timestamp=\>"2016-05-29T12:47:57.453000+0200", :message=\>"Pipeline aborted due to error", :exception=\>#\<LogStash::ConfigurationError: com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?\>, :backtrace=\>["/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin\_mixins/jdbc.rb:156:in `prepare_jdbc_connection'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167:in`register'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:330:in `start_inputs'", "org/jruby/RubyArray.java:1613:in`each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:329:in `start_inputs'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:180:in`start\_workers'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:136:in `run'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/agent.rb:465:in`start\_pipeline'"], :level=\>:error}

Any help, please?

Thank you so much!

---

<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:** [July 6, 2017, 4:55am UTC](https://discuss.elastic.co/t/input-mariadb-5-5-47-in-logstash-2-3/51244/3 "2017-07-06T04:55:44Z")

</div>