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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...