search

fedora-infra / fas

Fedora Account System
https://admin.fedoraproject.org/accounts
GNU General Public License v2.0
40 stars 50 forks source link

[FAS3] Issue with storing timezone aware in db #212

Closed skrzepto closed 3 years ago

skrzepto commented 7 years ago

Looks like MySQL and SQLite have an issue storing timezone aware times in the db which makes login fail. (related to issue #195 )

Possible solutions

  1. Force postgresql only
  2. https://pypi.python.org/pypi/SQLAlchemy-UTCDateTime/

Thoughts or other suggestions?

pypingou commented 7 years ago

other suggestions?

Use UTC everywhere and don't care about the timezone?

skrzepto commented 7 years ago

Technically UTC is a timezone so the issue kind of persists

pypingou commented 7 years ago

If all the date/times are using the same timezone, then we do not need to store timezone info, we know they are all in the same timezone.

ryanlerch commented 3 years ago

Closing this issue as the FAS project is now archived, not actively developed, and unmaintained.

FAS was replaced in March 2021 by Fedora Accounts (https://accounts.fedoraproject.org).

If this issue is a Feature Request that you forsee might be beneficial to Fedora Accounts, please refile it against Noggin