523264 - Push SUMO 1.4.1 to production on Thursday, Oct 22

Status: VERIFIED FIXED

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

Description

[James Socol [:jsocol, :james]]

The tag is:

/projects/sumo/tags/1.4/1.4.1_20091016_r53582

After the switch, run webroot/htaccess.sh.

We'll also need the following SQL run on production:
https://bugzilla.mozilla.org/attachment.cgi?id=405301

There may be one other SQL patch to run, still waiting to hear.

Comment 1

[James Socol [:jsocol, :james]]

Yep, here's the other SQL patch:
https://bug513851.bugzilla.mozilla.org/attachment.cgi?id=403978

Comment 2

[James Socol [:jsocol, :james]]

We'll also need the SHOWFOR configuration updated, that's in the scripts directory:
cp scripts/showfor/config.php.dist scripts/showfor/config.php

Shyam, how do you feel about moving the scripts/ directory off NFS during this push? (What we talked about in bug 514055.)

Comment 3

[Shyam Mani [:fox2mike]]

(In reply to comment #2)

> Shyam, how do you feel about moving the scripts/ directory off NFS during this
> push? (What we talked about in bug 514055.)

James, I'm all for it.

Comment 4

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

Are we really making DNS changes the same time as tonight's push (7pm PDT?)  See bug 522923.

Comment 5

[Shyam Mani [:fox2mike]]

[root@mradm02 support.mozilla.com]# svn switch https://svn.mozilla.org/projects/sumo/tags/1.4/1.4.1_20091016_r53582
U    webroot/js/wikiplugin_showfor.js
U    webroot/js/forumquestion.js
U    webroot/lang/uk/language.php
U    webroot/lang/ms/language.php
U    webroot/lang/sr-LATN/language.php
U    webroot/lang/fy-NL/language.php
U    webroot/lang/fa/language.php
U    webroot/lang/ja/language.php
U    webroot/lang/sv-SE/language.php
U    webroot/lang/fi/language.php
U    webroot/lang/fj/language.php
U    webroot/lang/fr/language.php
U    webroot/lang/nl/language.php
U    webroot/lang/vi/language.php
U    webroot/lang/rm/language.php
U    webroot/lang/ro/language.php
U    webroot/lang/ca/language.php
U    webroot/lang/pt-BR/language.php
U    webroot/lang/ru/language.php
U    webroot/lang/rw/language.php
U    webroot/lang/oc/language.php
U    webroot/lang/gl/language.php
U    webroot/lang/bn-IN/language.php
U    webroot/lang/sb/language.php
U    webroot/lang/kk/language.php
U    webroot/lang/cs/language.php
U    webroot/lang/kn/language.php
U    webroot/lang/ta-LK/language.php
U    webroot/lang/ko/language.php
U    webroot/lang/si/language.php
U    webroot/lang/cy/language.php
U    webroot/lang/sk/language.php
U    webroot/lang/sl/language.php
U    webroot/lang/zh-CN/language.php
U    webroot/lang/or/language.php
U    webroot/lang/ga-IE/language.php
U    webroot/lang/bn-BD/language.php
U    webroot/lang/sq/language.php
U    webroot/lang/da/language.php
U    webroot/lang/de/language.php
U    webroot/lang/he/language.php
U    webroot/lang/ta/language.php
U    webroot/lang/hi-IN/language.php
U    webroot/lang/pa-IN/language.php
U    webroot/lang/te/language.php
U    webroot/lang/hr/language.php
U    webroot/lang/th/language.php
U    webroot/lang/pl/language.php
U    webroot/lang/hu/language.php
U    webroot/lang/gu-IN/language.php
U    webroot/lang/lt/language.php
U    webroot/lang/lv/language.php
U    webroot/lang/tr/language.php
U    webroot/lang/tv/language.php
U    webroot/lang/sr-CYRL/language.php
U    webroot/lang/id/language.php
U    webroot/lang/fur/language.php
U    webroot/lang/el/language.php
U    webroot/lang/en/language.php
U    webroot/lang/ar/language.php
U    webroot/lang/eo/language.php
U    webroot/lang/as/language.php
U    webroot/lang/pt-PT/language.php
U    webroot/lang/mk/language.php
U    webroot/lang/et/language.php
U    webroot/lang/eu/language.php
U    webroot/lang/zh-TW/language.php
U    webroot/lang/mn/language.php
U    webroot/lang/is/language.php
U    webroot/lang/it/language.php
U    webroot/lang/mr/language.php
U    webroot/tiki-ask_a_question.php
U    webroot/tiki-forum_rss.php
U    webroot/tiki-admin_include_general.php
U    webroot/comments.php
U    webroot/tiki-newsearch.php
U    webroot/tiki-view_forum_thread.php
U    webroot/tiki-login_scr.php
U    webroot/lib/smarty_tiki/outputfilter.urlt.php
U    webroot/lib/rss/rsslib.php
U    webroot/lib/notifications/notificationemaillib.php
U    webroot/styles/mozfr.css
U    webroot/styles/mozcommon.css
U    webroot/styles/mozaskaq.css
U    webroot/tiki-view_forum.php
U    webroot/robots.txt
U    webroot/tiki-special_chars.php
U    webroot/templates/tiki-upload_image.tpl
U    webroot/templates/tiki-newsearch.tpl
U    webroot/templates/tiki-pick_avatar.tpl
U    webroot/templates/styles/mozkb/comments.tpl
U    webroot/templates/styles/mozkb/tiki-edit_help_tool.tpl
U    webroot/templates/styles/mozkb/tiki-view_forum.tpl
U    webroot/templates/styles/mozkb/mail/forum_post_notification.tpl
U    webroot/templates/styles/mozkb/comment-header.tpl
U    webroot/templates/styles/mozkb/tiki-searchindex.tpl
U    webroot/templates/styles/mozkb/tiki-ask_a_question.tpl
U    webroot/templates/styles/mozkb/forumquestion.tpl
U    webroot/templates/styles/mozfh/tiki-show_page.tpl
U    webroot/templates/styles/mozms/tiki-show_page.tpl
U    webroot/templates/styles/mozms2/tiki-show_page.tpl
A    webroot/templates/styles/mozcommon/header_vi.tpl
A    webroot/templates/styles/mozcommon/header_uk.tpl
U    webroot/templates/styles/mozcommon/searchbar.tpl
U    webroot/templates/styles/mozcommon/footer.tpl
U    webroot/templates/styles/mozcommon/header_de.tpl
U    webroot/htaccess.dist
U    scripts/showfor/config.php.dist
Updated to revision 54044.

svn switch complete, directory scripts has been moved away from NFS.

Comment 6

[Shyam Mani [:fox2mike]]

DB Changes are in :

mysql> INSERT INTO tiki_urlt_regex_out (regexid,regex_left,regex_right) VALUES
    -> (95,'^\\/?tiki-view_forum.php\\?locale=([\\-a-zA-Z]+)&(?:amp;)?forumId=([0-9]+)(?:&(?:amp;)?(.*))?$','/$1/forum/$2?$3');
Query OK, 1 row affected (0.01 sec)

mysql> 
mysql> UPDATE tiki_urlt_regex_out SET regex_left = '^\\/?tiki-view_forum_thread\\.php\\?comments_parentId=([0-9]+)&(?:amp;)?forumId=([0-9]+)(?:(?:&(?:amp;)?)(.*))?$', regex_right = '/en-US/forum/$2/$1?$3' WHERE regexid = 90;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE tiki_language SET source = REPLACE(source, 'aproximately', 'approximately');
Query OK, 10 rows affected (0.58 sec)
Rows matched: 125005  Changed: 10  Warnings: 0

Pushing out stuff and flushing cache.

Comment 7

[Shyam Mani [:fox2mike]]

And done.

Comment 8

[Chris Ilias [:cilias]]

Was htaccess.sh not run on prod? (bug 520793)
I'm still seeing Firefox+Help+1 when I go to Help-->Help Contents.

Comment 9

[Shyam Mani [:fox2mike]]

(In reply to comment #8)
> Was htaccess.sh not run on prod? (bug 520793)
> I'm still seeing Firefox+Help+1 when I go to Help-->Help Contents.

Yeah, I forgot to run that. Have done now and re-flushed the caches.

Comment 10

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

Verified FIXED; we ran, and passed:

* Selenium tests (http://viewvc.svn.mozilla.org/vc/projects/sumo/trunk/tests/frontend/?pathrev=52894) (some have pre-existing, known failures -- fixing tomorrow)
* bug 518874, bug 519908, bug 509881, bug 505432, bug 520821, bug 522151, and bug 518770
* search, as: admin, logged out, contributor
* lots of solid ad-hoc testing.

(!)