Input mariadb 5.5.47 in logstash 2.3

Elastic Stack Logstash
1

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!

2

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:inevents_to_request_body'", "org/jruby/RubyHash.java:1342:in each'", "org/jruby/RubyEnumerable.java:757:inmap'", "/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:inmap'", "/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:inflush'", "/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:ineach'", "/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:inbuffer_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:inmulti_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:inmulti_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:inmulti_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:ineach'", "/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:inworker_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:inregister'", "/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:ineach'", "/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:instart_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:instart_pipeline'"], :level=>:error}

Any help, please?

Thank you so much!