518577 - Push SUMO 1.4 to production Thursday September 24th

Status: VERIFIED FIXED

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

Description

[Laura Thomson :laura]

Tag coming later.  

Devs, please add any SQL or config changes to this bug.

Comment 1

[Laura Thomson :laura]

Should add, no downtime expected - this release is largely UX improvements.

Comment 2

[Laura Thomson :laura]

Tag is https://svn.mozilla.org/projects/sumo/tags/1.4/1.4_20090924_r52259/

There is a small amount of SQL to run, will be added here.

Comment 3

[[:Cww]]

As part of the 1.4 push, we should have pre-populated tables from support stage
put onto support production.

ON stage:

mysqldump -u root -p sumo_dump tiki_question_sections tiki_question_fields >
tiki_questions.sql 

ON prod:

mysql -u root -p sumo_dump < tiki_questions.sql

Comment 5

[[:Cww]]

So we shouldn't mysqldump from stage, I'll get feedback and then make a new .sql file and attach the final final version.

Comment 6

[[:Cww]]

Attachment: Final SQL

SQL

This is final.  We'll make any further changes in the admin panel.

Comment 7

[James Socol [:jsocol, :james]]

A little more SQL:

Attachment 387750 [details] [diff] from bug 481890:
https://bug481890.bugzilla.mozilla.org/attachment.cgi?id=387750

Comment 8

[Laura Thomson :laura]

Other SQL:
https://bug436106.bugzilla.mozilla.org/attachment.cgi?id=390050
https://bug416479.bugzilla.mozilla.org/attachment.cgi?id=397750

We will also need to run htaccess.sh to regenerate rewrite rules.

Comment 9

[Laura Thomson :laura]

(In reply to comment #6)
> Created an attachment (id=402715) [details]
> Final SQL
> 
> SQL
> 
> This is final.  We'll make any further changes in the admin panel.

I see the table structure came from https://bug512386.bugzilla.mozilla.org/attachment.cgi?id=400108.

Where did the data come from?  Did you test this somewhere?

Comment 10

[Shyam Mani [:fox2mike]]

svn switch complete :

[root@mradm02 support.mozilla.com]# svn info
Path: .
URL: https://svn.mozilla.org/projects/sumo/tags/1.4/1.4_20090924_r52259
Repository Root: https://svn.mozilla.org
Repository UUID: 4eb1ac78-321c-0410-a911-ec516a8615a5
Revision: 52314
Node Kind: directory
Schedule: normal
Last Changed Author: [e-mail]
Last Changed Rev: 50929
Last Changed Date: 2009-09-04 13:41:05 -0700 (Fri, 04 Sep 2009)

SQL runs were fine, (first one too big to paste)

mysql> INSERT INTO `users_permissions` (
    -> `permName` ,`permDesc` ,`level` ,`type` ,`admin`
    -> )
    -> VALUES (
    -> 'tiki_p_forum_detach_own_posts', 'Can detach own forum posts', 'registered', 'forums', NULL
    -> ), (
    -> 'tiki_p_detach_comments', 'Can detach all comments', 'editors', 'comments', NULL
    -> );
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> DELETE FROM tiki_urlt_regex_out WHERE regex_left = '\%20' LIMIT 1;
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO `tiki_urlt_regex_out` (`regexid`, `regex_left`, `regex_right`, `regex_flags`, `continue_flag`, `comment_text`) VALUES
    -> (80, '^\\/?tiki-view_forum_thread.php\\?(.*)&?locale=([\\-a-zA-Z]+)(&|&)forumId=([0-9]+)(&|&)comments_parentId=([0-9]+)(&.*)?$', '/$2/forum/$4/$6$1$7', '', '0', ''),
    -> (90, '^\\/?tiki-view_forum_thread\\.php\\?comments_parentId=([0-9]+)(&|&)forumId=([0-9]+)(&.*)?$', '/en-US/forum/$3/$1$4', '', '0', ''),
    -> (100, '^\\/?tiki-view_forum.php\\?(.*)&?locale=([\\-a-zA-Z]+)(&|&)forumId=([0-9]+)(&.*)?$', '/$2/forum/$4', NULL, NULL, NULL),
    -> (110, '^\\/?tiki-view_forum.php\\?forumId=([0-9]+)', '/en-US/forum/$1', NULL, NULL, NULL);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

Flushing caches now.

Comment 11

[James Socol [:jsocol, :james]]

Missed one new config:

cp scripts/minify/minify.conf.php.dist scripts/minify/minify.conf.php

Comment 12

[Shyam Mani [:fox2mike]]

NS + Tiki + Memcache flushed out. 

Should be all done.

Comment 13

[Shyam Mani [:fox2mike]]

(In reply to comment #11)
> Missed one new config:
> 
> cp scripts/minify/minify.conf.php.dist scripts/minify/minify.conf.php

Added this too now.

Comment 14

[Laura Thomson :laura]

Also need to run 
https://bug518760.bugzilla.mozilla.org/attachment.cgi?id=402762 
on prod.

Comment 15

[Shyam Mani [:fox2mike]]

Done.

mysql> INSERT INTO tiki_urlt_regex_out (regexid, regex_left, regex_right, regex_flags, continue_flag, comment_text)
    -> VALUES (
    -> '120', '^\\/?tiki-view_forum.php\\?forumId=([0-9]+)(&|&)(.*)$', '/en-US/forum/$1?$3', NULL , NULL , NULL
    -> );
Query OK, 1 row affected (0.00 sec)

mysql> 
mysql> UPDATE tiki_urlt_regex_out SET regex_left = '^\\/?tiki-view_forum.php\\?forumId=([0-9]+)$' WHERE regexid =110 LIMIT 1 ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Comment 16

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; sorry I didn't verify it soon after we pushed, earlier.