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

View solution in original post

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!