I am a beginner in logstash. I want to load my database "mydb" in the inddex "test". but I find an error with logstash: "error logstash.inputs.jdbc Unable to connect to database" this is my config file: `input { jdbc { jdbc_driver_library => "C:\logstash-6.7.1\bin\mysql-connector-java-5…

What timezone are your timestamps recorded in in the MySQL DB? If UTC then you can add some parameters to the jdbc connection string. jdbc:mysql://localhost/mydb?useTimezone=true&useLegacyDatetimeCode=false&serverTimezone=UTC

Error logstash.inputs.jdbc Unable to connect to database

Elastic Stack Logstash

medaly_ahmed (Medaly Ahmed) April 16, 2019, 3:41pm 3

Thanks sir @guyboertje
how can i resolve this error of the server time zone ?

Topic		Replies	Views
Logstash MYSQL jdbc Logstash	2	580	May 19, 2023
Logstash jdbc config:Unable to connect to database Logstash	1	1455	May 5, 2019
Logstash.inputs.jdbc Unable to connect to database Logstash	2	3110	September 30, 2019
Logstash : jdbc - Unable to connect to database Logstash	3	3649	August 3, 2020
Logstash jdbc Illegal instant due to time zone offset transition (daylight savings time 'gap'): 1979-03-21 Logstash	2	416	June 8, 2023

Error logstash.inputs.jdbc Unable to connect to database

Related topics