[getpersonas] Update production on 2/8 @ 1500

VERIFIED FIXED

Status

Infrastructure & Operations
WebOps: Other
VERIFIED FIXED
6 years ago
4 years ago

People

(Reporter: clouserw, Assigned: oremj)

Tracking

other
All
Other
Bug Flags:
needs-downtime +

Details

(Whiteboard: [02/08/2011 @ 3pm])

(Reporter)

Description

6 years ago
This update pulls in a pile of fixes.  It should be fairly uneventful, except people won't be able to log in while the upgrade script runs (which will take 1-2 hours).  That's why I have this starting at 1500, but we're flexible.

The upgrade itself is easy:

1) `svn revert -R; svn up`
2) alter table users change column md5 md5 varbinary(255) DEFAULT NULL
3) In a screen session (because it takes forever) run: `php -f password_fix.php`

Updated

6 years ago
Flags: needs-downtime+
Whiteboard: [02/08/2011 @ 5pm]

Updated

6 years ago
Whiteboard: [02/08/2011 @ 5pm] → [02/08/2011 @ 3pm]
Assignee: server-ops → jeremy.orem+bugs
(Assignee)

Comment 1

6 years ago
[root@mradm02 www.getpersonas.com]# svn up
U    server/personadetail.php
U    server/faq.php
U    server/locale/nl/LC_MESSAGES/messages.po
 U   server/locale
U    server/firstrun.php
UU   server/lib/user.php
UU   server/lib/personas_functions.php
UU   server/lib/storage.php
U    server/updated.php
U    server/signin.php
U    server/upload_forms.php
U    server/external/mozilla/footer.php
U    server/profile.php
D    server/admin/placeholder_user.php
U    server/admin/editing.php
U    server/admin/pending.php
U    server/admin/dashboard.php
U    server/index.php
U    server/templates/footer.php
U    server/templates/gallery.php
U    server/templates/upload_tos_tmpl.php
U    server/templates/upload_persona_tmpl.php
U    server/templates/delete_persona_success_tmpl.php
U    server/templates/header.php
U    server/templates/persona_detail.php
U    server/templates/ssc_upload_tos_tmpl.php
U    server/templates/delete_persona_tmpl.php
U    server/templates/change_user_details.php
 U   server
UU   static/css/style.css
 U   static/js/script.js
 U   static
A    password_fix.php
 U   .
Updated to revision 82304.
(Assignee)

Comment 2

6 years ago
mysql> alter table users change column md5 md5 varbinary(255) DEFAULT NULL;
Query OK, 1232619 rows affected (16.95 sec)
Records: 1232619  Duplicates: 0  Warnings: 0
(Assignee)

Comment 3

6 years ago
Script is running now.
(Assignee)

Comment 4

6 years ago
Finished. Looks like it changed 1232610 users.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Verified FIXED (successfully pushed).
Status: RESOLVED → VERIFIED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.