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 DB connect database connection is invalid due to the server time zone value being unrecognized. What do I do?

[rsantoso_splunk · Accepted solution]

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