Hi,
I am using Logstach to migrate data from mariadb to elasticSearch, but I always get this error, 'Error: Java::org.mariadb.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?'.
Here is my .conf file:
input{
        jdbc {
                jdbc_driver_library => "mariadb-java-client-2.3.0-sources.jar"
                jdbc_driver_class => "Java::org.mariadb.jdbc.Driver"
                jdbc_connection_string => "jdbc:mariadb://$ip:$port/db_name"
                jdbc_user => "user"
                jdbc_password => "pwd"
                statement => "SELECT * FROM db_name.tb_name"
        }
}
output {
        elasticsearch {
                hosts => "$ip:9200"
                index => "index_01"
        }
        stdout{
                codec => rubydebug
        }
}
I put the driver file 'mariadb-java-client-2.3.0-sources.jar' under the Logstash folder and the jar is not empty; I also tried the absolute address but I still got the same error. Could you tell me how to fix this issue.
Best Regards,
Sally