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!

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.