Closed Bug 1122531 Opened 9 years ago Closed 9 years ago

[Mozillians] MySQL timezone tables required in all mozillians deployments

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Version:
Customer Request
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: nemo-yiannis, Unassigned)

References

Details

(Whiteboard: [kanban:https://webops.kanbanize.com/ctrl_board/2/287] [data: db_change]) 

Hi, we would like to make sure that timezone tables exist in the MySQL servers that we are using in all dev/prod/stage deployments (mozillians-dev.a.o, mozillians.a.o, mozillians.org). If not, can you please import it?

Here [1] is the django documentation I used to configure MySQL timezone definitions locally.

[1] https://docs.djangoproject.com/en/1.7/ref/databases/#time-zone-definitions

Thank you!
Blocks: 1122518
Whiteboard: [kanban:https://webops.kanbanize.com/ctrl_board/2/287]
Changing priority to 'Major' since this is blocking a release.
Severity: normal → major
John, this is paging on call, there isn't much we can do until webops are online. Reducing importance until webops are online.
Severity: major → normal
Is there any update regarding that bug?
Assignee: server-ops-webops → server-ops-database
Component: WebOps: Engagement → Database Operations
Product: Infrastructure & Operations → Data & BI Services Team
QA Contact: nmaul → scabral
Version: other → Customer Request
# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

This was completed, and the warnings shown above, on dev/stage, production, and jenkins. There are 1738 time zones in the time zone table now.
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
Whiteboard: [kanban:https://webops.kanbanize.com/ctrl_board/2/287] → [kanban:https://webops.kanbanize.com/ctrl_board/2/287] [data: db_change]
You need to log in before you can comment on or make changes to this bug.