We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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
The text was updated successfully, but these errors were encountered:
I have encountered the same problem, how do you solve it?
Sorry, something went wrong.
No branches or pull requests
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
The text was updated successfully, but these errors were encountered: