[SOLVED] Time zone issue (MySQL)

Get Help
1

I am facing issue with my metabase timezone.I have mysql database running on UTC and postgres as well on UTC.When i change timezone to asia/calcuttta it is adding 11 hours to UTC rather than 5:30 minute.

2

Sorry for the trouble. I just wrote a response to another user about this same issue here: Issue with metabase! Urgent

3

New Timezone related issue.

New install.
metabase v0.24.2
DB = Mysql 5.7

Getting the following error when after attempting to set the timezone through the UI.
07-11 14:12:56 DEBUG generic-sql.query-processor :: Setting timezone with statement: SET @@session.time_zone = ‘US/Eastern’;
07-11 14:12:56 ERROR generic-sql.query-processor :: Failed to set timezone:
SQLException:
Message: Unknown or incorrect time zone: ‘US/Eastern’
SQLState: HY000
Error Code: 1298

4

I had the same Issue.

You can fix this by loading the timezones data into MySQL using

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

After I did that the errors were gone.

1 Like