Getting Data In

What do I do if the Splunk DB Connect database connection is invalid due to the server time zone value being unrecognized?

rsantoso_splunk
Splunk Employee
Splunk Employee

Splunk DB connect database connection is invalid due to the server time zone value being unrecognized. What do I do?

0 Karma
1 Solution

rsantoso_splunk
Splunk Employee
Splunk Employee

To populate the zoneinfo into mysql:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Once the zoneinfo is loaded, it is best to restart the mysql server so that it does not continue to use any previously cached time zone data.

If your system has its own zoneinfo database (the set of files describing time zones), you should use the mysql_tzinfo_to_sql program for filling the time zone tables. Examples of such systems are Linux, FreeBSD, Solaris, and macOS. One likely location for these files is the /usr/share/zoneinfo directory.

Please refer to the following url on the information above populating the zoneinfo to mysql:
https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

View solution in original post

0 Karma

rsantoso_splunk
Splunk Employee
Splunk Employee

To populate the zoneinfo into mysql:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Once the zoneinfo is loaded, it is best to restart the mysql server so that it does not continue to use any previously cached time zone data.

If your system has its own zoneinfo database (the set of files describing time zones), you should use the mysql_tzinfo_to_sql program for filling the time zone tables. Examples of such systems are Linux, FreeBSD, Solaris, and macOS. One likely location for these files is the /usr/share/zoneinfo directory.

Please refer to the following url on the information above populating the zoneinfo to mysql:
https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

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 ...