https://community.splunk.com/t5/Getting-Data-In/What-do-I-do-if-the-Splunk-DB-Connect-database-connection-is/m-p/433419#M75758 <P>Splunk DB connect database connection is invalid due to the server time zone value being unrecognized. What do I do?</P> Tue, 11 Dec 2018 00:09:51 GMT rsantoso_splunk 2018-12-11T00:09:51Z https://community.splunk.com/t5/Getting-Data-In/What-do-I-do-if-the-Splunk-DB-Connect-database-connection-is/m-p/433419#M75758 <P>Splunk DB connect database connection is invalid due to the server time zone value being unrecognized. What do I do?</P> Tue, 11 Dec 2018 00:09:51 GMT https://community.splunk.com/t5/Getting-Data-In/What-do-I-do-if-the-Splunk-DB-Connect-database-connection-is/m-p/433419#M75758 rsantoso_splunk 2018-12-11T00:09:51Z https://community.splunk.com/t5/Getting-Data-In/What-do-I-do-if-the-Splunk-DB-Connect-database-connection-is/m-p/433420#M75759 <P>To populate the zoneinfo into mysql: <BR /> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql <BR /> 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.</P> <P>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. </P> <P>Please refer to the following url on the information above populating the zoneinfo to mysql:<BR /> <A href="https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html" target="_blank">https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html</A></P> Tue, 29 Sep 2020 22:22:50 GMT https://community.splunk.com/t5/Getting-Data-In/What-do-I-do-if-the-Splunk-DB-Connect-database-connection-is/m-p/433420#M75759 rsantoso_splunk 2020-09-29T22:22:50Z