#24616: date_hierarchy with USE_TZ=True won't work with Amazon RDS
-------------------------------------+-------------------------------------
Reporter: iiilx | Owner: nobody
Type: | Status: new
Cleanup/optimization |
Component: contrib.admin | Version: 1.6
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
pytz,mysql_tzinfo_to_sql,USE_TZ |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by adamchainz):
I've been running Django 1.6+ fine on RDS MySQL (5.5) for over a year and
a half, in two separate deployments. The timezone tables are preloaded for
you, iirc. If you log in with your master user and run {{{SHOW TABLES IN
`mysql`;}}} you should see them. You may need to run the following grants
to your application's username to give it access to read the data:
{{{
GRANT SELECT ON `mysql`.`time_zone` TO 'application'@'%';
GRANT SELECT ON `mysql`.`time_zone_leap_second` TO 'application'@'%';
GRANT SELECT ON `mysql`.`time_zone_name` TO 'application'@'%';
GRANT SELECT ON `mysql`.`time_zone_transition` TO 'application'@'%';
GRANT SELECT ON `mysql`.`time_zone_transition_type` TO 'application'@'%';
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/24616#comment:3>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/063.eb35722babacb436eda867f656cfc981%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
