jdbc driver version
i'm currently using the following mariadb version:
Server version: 10.1.40-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
i've tried a couple different drivers and the results are the same. i'm trying to connect remotely but i keep getting the same error. error as follows:
[ERROR] 2019-07-03 10:36:06.436 [[main]<jdbc] pipeline - A plugin had an unrecoverable error. Will restart this plugin. Pipeline_id:main Plugin: <LogStash::Inputs::Jdbc jdbc_user=>"misp", jdbc_password=><password>, statement=>"SELECT * FROM admin_settings;", jdbc_driver_library=>"/usr/share/logstash/driver-files/mysql-connector-java-8.0.16.jar", jdbc_connection_string=>"jdbc:10.2.20.6:3306/misp", id=>"09490e68b43c7783d6a90678adb72a65a9d644010c064015ed75ebe07b68729f", jdbc_driver_class=>"com.mysql.jdbc.Driver", enable_metric=>true, codec=><LogStash::Codecs::Plain id=>"plain_5f0bf8ce-cf39-423e-8020-039b1fc36b90", enable_metric=>true, charset=>"UTF-8">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, parameters=>{"sql_last_value"=>1970-01-01 00:00:00 UTC}, last_run_metadata_path=>"/root/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", clean_run=>false, record_last_run=>true, lowercase_column_names=>true> Error: Java::JavaSql::SQLException: No suitable driver found for jdbc:10.2.20.6:3306/misp Exception: Sequel::DatabaseConnectionError Stack: java.sql.DriverManager.getConnection(java/sql/DriverManager.java:689)
I'd just like to know which driver i should use with this version of mariadb.
the source that's trying to connect to remote mariadb is sitting on ubuntu 16.04 - if that matters...
Thanks!