Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"failed to connect to database: Unknown or incorrect time zone: \'UTC\'" #43

Closed
eraffaelli opened this issue Jan 10, 2020 · 2 comments
Closed
Labels
bug db:mysql Related to MySQL

Comments

@eraffaelli
Copy link

Hi,

Thanks for your lib.

I got this error while running the example with tide using mysql features.

"failed to connect to database: Unknown or incorrect time zone: 'UTC'"

I fixed it with this command :

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

found here https://dba.stackexchange.com/a/120946

Just to let you know, maybe it need something from your end, maybe not.
Mysql/MariaDB : mysql Ver 15.1 Distrib 10.3.18-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Regards

@mehcode
Copy link
Member

mehcode commented Jan 11, 2020

@eraffaelli Thanks for the report. I saw something like this when reading the MySQL protocol information but I had a hard time conceptualizing how the server wouldn't know what UTC was at all times.

We can adjust the connection to use '+00:00' directly instead of pretending MySQL knows what UTC is.

@mehcode mehcode added bug db:mysql Related to MySQL labels Jan 11, 2020
@mehcode
Copy link
Member

mehcode commented Jan 11, 2020

This should be fixed in v0.1.4

@mehcode mehcode closed this as completed Jan 11, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug db:mysql Related to MySQL
Projects
None yet
Development

No branches or pull requests

2 participants