Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
conghao321 opened this issue Aug 16, 2020 · 1 comment

Comments

@conghao321
Copy link

conghao321 commented Aug 16, 2020

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

@AlexJinx
Copy link

I have encountered the same problem, how do you solve it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants