678951 - QA and deploy BrowserID train-2011.08.12 to production

Status: VERIFIED FIXED

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

Description

[Lloyd Hilaiel [:lloyd]]

ChangeLog including issues resolved: https://github.com/mozilla/browserid/commit/ae918c658930bd751b8f0550018fbad6426ba75d

[QA] Suggested areas of focus for QA:
  * Full regression testing given significant changes in dialog logic as well as port to a new persistence layer (mysql)
  * Explore mobile fixes (give a quick pass on iOS and Fennec)
  * Verify correct functioning of verification token persistence: cause verification email to be sent, restart server (killall node on beta server), confirm that you can then verify email and complete add email flow.
  * confirm fix for issue #147

[RELEASE ENGINEERING] Steps for updating production from rain-2011.08.04 to train-2011.08.12:

  1. install mysql 5.1
  2. Add a user to the database:
    1. `CREATE USER 'browserid'@'localhost';`
    2. `CREATE DATABASE browserid`
    3. `GRANT INSERT,SELECT,DELETE,UPDATE,CREATE on browserid.* to 'browserid'@'localhost'`
    4. `FLUSH PRIVILEGES;`
  3. stop the servers (preventing people from using browserid)
  4. migrate the database using `scripts/migrate_sqlite_to_mysql.js` (putting the script in the same directory as `authdb.sqlite`
  5. push updated code and restart the servers.

Comment 1

[James Bonacci [:jbonacci]]

Decision made to merge this with the 8/18 train.
Will copy over ChangeLog and main comments above to new ticket for 8/18.