Skip to content

DatabaseError: driver.new.connect returned nil: probably bad JDBC connection string #382

@conghao321

Description

@conghao321

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions