All Apps and Add-ons

Splunk DB Connect getting time zone issue

joey77
Engager

Hi folks,

I have been trying to test Splunk DB connect on my local machine before deploying it live.
I've installed a mysql instance, so I can test the connection.

So trying to set up my first connection as a test.
But I always get this error message:

The server time zone value 'Est' is
unrecognized or represents more than
one time zone. You must configure
either the server or JDBC driver (via
the 'serverTimezone' configuration
property) to use a more specifc time
zone value if you want to utilize time
zone support.

I'm using splunk 8.0.1, java 8, mysql 8, splunk db connect 3.

0 Karma
1 Solution

joey77
Engager

I've solve my problem with this: ?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

at the end of the URL used to connect to DB

View solution in original post

0 Karma

joey77
Engager

I've solve my problem with this: ?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

at the end of the URL used to connect to DB

0 Karma

rajasekhar14
Path Finder

did you install mysql on the same sever where you install the db-connect app?

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...