-
Notifications
You must be signed in to change notification settings - Fork 184
Description
jdk version is 14
MySQL version is 8
MySQL connector version is : 8.0.21
Does this plugin support mysql 8?
my config is :
`
input {
stdin {
}
jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/nv_course?
useUnicode=true&characterEncoding=utf‐8&useSSL=true&serverTimezone=UTC"
jdbc_user => "root"
jdbc_password => mysql
# the path to our downloaded jdbc driver
jdbc_driver_library => "/Users/conghao/.m2/repository/mysql/mysql-connector-java/8.0.21/mysql-connector-java-8.0.21.jar"
jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
jdbc_paging_enabled => "true"
jdbc_page_size => "50000"
statement => "select * from course_pub where timestamp > date_add(:sql_last_value,INTERVAL 8
HOUR)"
schedule => "* * * * *"
record_last_run => true
last_run_metadata_path => "/Users/conghao/codes/tools/elasticsearch/logstash-7.8.1/config/logstash_metadata" }
}
output {
elasticsearch {
hosts => "localhost:9200"
#hosts => ["localhost:9200","localhost:9202","localhost:9203"]
index => "nv_course"
document_id => "%{id}"
document_type => "_doc"
template =>"/Users/conghao/codes/tools/elasticsearch/logstash-7.8.1/config/nv_course_template.json"
template_name =>"nv_course"
template_overwrite =>"true"
}
stdout {
codec => json_lines }
}
2020-08-16T00:23:00,040][ERROR][logstash.inputs.jdbc ][main][4b99b44fa0d9467a2b612df282d8e1114ce317932f3339b310286d144073267b] Unable to connect to database. Tried 1 times {:error_message=>"Sequel::DatabaseError: driver.new.connect returned nil: probably bad JDBC connection string"} { 2072 rufus-scheduler intercepted an error: 2072 job: 2072 Rufus::Scheduler::CronJob "* * * * *" {} 2072 error: 2072 2072 2072 Sequel::DatabaseConnectionError 2072 Sequel::DatabaseError: driver.new.connect returned nil: probably bad JDBC connection string