jdbc compatibility
Posted by: Jim Palazzolo
Date: July 03, 2019 08:42AM

i'm trying to connect remotely to this db
10.1.40-MariaDB-0ubuntu0.18.04.1

i've been successful in the past, but it's been a long time.

i've tried a few jdbc drivers and i keep getting the same error:

[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)


would justl like to know what driver is compatible with this db...

thanks!

Options: ReplyQuote


Subject
Written By
Posted
jdbc compatibility
July 03, 2019 08:42AM
July 03, 2019 11:12AM
July 04, 2019 09:11AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.