No suitable driver found for jdbc:mariadb

Elastic Stack Logstash
1

Hi Team,

I am trying to connect to mariaDB as input , but facing error as
Java::JavaSql::SQLException: No suitable driver found for jdbc:mariadb

below are the input configuration in logstash

input {
jdbc {
jdbc_driver_library => "/etc/logstash/mariadb-java-client-2.4.2-sources.jar"
jdbc_driver_class => "org.mariadb.jdbc.Driver"
jdbc_connection_string => "jdbc:mariadb://127.0.0.1:3306/blk_kpi"
jdbc_user => "root"
jdbc_password => "root"
statement => "SELECT * from test WHERE handler_name in ('contact_phone')"
}
}
output {
stdout { codec => json_lines }
elasticsearch {
"hosts" => "127.0.0.1:9200"
"index" => "test_extra_index"
}
}

What can be the possible mistake, which is causing the error. I have tried the solutions which were in forum.

TIA

2

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