How to configure the jdbc input plugin for mysql

Elastic Stack Logstash
1

HI.

I work in windows, and i need use input plugin for mysql, i have this:

jdbc {
jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/ruby"
jdbc_user => "ale"
jdbc_password => "ale"

#DRIVER
jdbc_driver_library => "E:\Bacardi\mysql-connector-java-5.1.39.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

#SQL
statement => "SELECT * FROM prueba"
#jdbc_paging_enabled => "true"
#jdbc_page_size => "50000"
}

but i have this error Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?

I tried:

#jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

#jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
#jdbc_driver_class => "com.mysql.jdbc.Driver"

but it still gives me the same error. please someone help me?

Sorry my English. thnks

2

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