626897 - [getpersonas] Run a script on getpersonas stage

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Wil Clouser [:clouserw]]

Toby just checked in a script that needs running on this box/db:

http://personas.stage.mozilla.com/en-US/

The script is in the root of the dir:
http://viewvc.svn.mozilla.org/vc/projects/getpersonas.com/trunk/password_fix.php

Please adjust the variables at the top to point to the staging database and then run:

`php -f password_fix.php`

Comment 1

[Wil Clouser [:clouserw]]

There will be some SQL to run with this too, before we run the script.  Marking dependent on the import bug.

Comment 2

[Wil Clouser [:clouserw]]

Alright, after bug 629207 is done, the steps here are:

Run this:
> alter table users change column md5 md5 varbinary(255) DEFAULT NULL;

Run this:
> php -f password_fix.php

Thanks

Comment 3

[Wil Clouser [:clouserw]]

This is blocking a security bug

Comment 4

[Jeremy Orem [:oremj]]

mysql> alter table users change column md5 md5 varbinary(255) DEFAULT NULL;
Query OK, 1225227 rows affected (26.08 sec)
Records: 1225227  Duplicates: 0  Warnings: 0

Script is running now. Looks like it is doing 300/second, so it should take about 1 1/2 hours.

Comment 5

[Jeremy Orem [:oremj]]

Done.