Closed Bug 698857 Opened 13 years ago Closed 13 years ago

Push Mozillians 1.1 to production on Thursday, Nov. 3, 2011

Categories

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

Product:
Infrastructure & Operations Graveyard
Component:
WebOps: Other
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: tofumatt, Assigned: oremj)

Details

Well howdy! It seems like just yesterday we were talking about pushing 1.0 and 1.0.1 to production! My, how the kids grow up, eh? Mozillians didn't have any groups, no cool JS validations, and I bet there were lots of nitty little bugs. But no more! Mozillians is getting older -- I see it just grew its first tooth: user-admin-able groups!

So I'd like to enrol our little app into production, as I think he's ready to venture out into the world. We'd like a few days to say our goodbyes first, so let's aim for him to start Thursday, Nov. 3rd. I'll ping whoever is assigned to push the code with any hiccups, but I don't foresee any.

He'll be wearing a shirt that says "1.1", but on the back of his shirt will be the word "prod" if you'd rather pick him out that way. He hangs out around https://github.com/mozilla/mozillians.

I'll be in #mozillians and #mozillians-release on Thursday if you need me: I'm tofumatt on there as well.

*sniff*, *sob*
Assignee: server-ops → oremj
Just FYI once we're ready to push: 


https://wiki.mozilla.org/Mozillians/Release_Checklist#Go.21


Jeremy, can we get a time when we can release tomorrow? 10AM or later (Pacific) would be preferable.
Let's do 10am.
I'll need a few Django cron tasks to be run after this code goes live.

One-time code:

manage.py cron assign_staff_to_early_users

That will add all users who should be in the staff group to it.

This needs to be in cron; every 30 minutes should be good:

manage.py cron assign_autocomplete_to_groups
/data/genericrhel6/src/mozillians.org/update 1.1
+ echo -e 'Updating code...'
Updating code...
+ cd /data/genericrhel6/src/mozillians.org/mozillians
+ git fetch origin -q
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ git checkout -f 1.1
Previous HEAD position was a5e8843... Mistakes undone, fix bug 691091.
HEAD is now at 3e20f4b... Don't allow non-vouched to search groups
+ git submodule sync -q
+ git submodule update --init -q
Initialized empty Git repository in /data/genericrhel6/src/mozillians.org/mozillians/media/js/libs/tag-it/.git/
remote: Counting objects: 667, done.
remote: Compressing objects: 100% (309/309), done.
remote: Total 667 (delta 361), reused 630 (delta 331)
Receiving objects: 100% (667/667), 416.85 KiB, done.
Resolving deltas: 100% (361/361), done.
remote: Counting objects: 118, done.
remote: Compressing objects: 100% (93/93), done.
remote: Total 111 (delta 16), reused 110 (delta 15)
Receiving objects: 100% (111/111), 85.56 KiB, done.
Resolving deltas: 100% (16/16), completed with 4 local objects.
From git://github.com/mozilla/mozillians-lib
   c389440..b343ae8  master     -> origin/master
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ echo -e 'Updating vendor...'
Updating vendor...
+ cd /data/genericrhel6/src/mozillians.org/mozillians/vendor
+ git submodule sync -q
+ git submodule update --init -q
Initialized empty Git repository in /data/genericrhel6/src/mozillians.org/mozillians/vendor/src/django-cronjobs/.git/
remote: Counting objects: 56, done.
remote: Compressing objects: 100% (51/51), done.
remote: Total 56 (delta 19), reused 5 (delta 2)
Receiving objects: 100% (56/56), 7.96 KiB, done.
Resolving deltas: 100% (19/19), done.
remote: Counting objects: 45, done.
remote: Compressing objects: 100% (30/30), done.
remote: Total 36 (delta 24), reused 18 (delta 6)
Unpacking objects: 100% (36/36), done.
From git://github.com/mozilla/funfactory
   bc2c9f0..c5c4060  master     -> origin/master
Initialized empty Git repository in /data/genericrhel6/src/mozillians.org/mozillians/vendor/src/happyforms/.git/
remote: Counting objects: 16, done.
remote: Compressing objects: 100% (8/8), done.
remote: Total 16 (delta 3), reused 16 (delta 3)
Receiving objects: 100% (16/16), done.
Resolving deltas: 100% (3/3), done.
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ cd /data/genericrhel6/src/mozillians.org/mozillians/locale
+ find . -name '*.mo' -delete
+ svn up
U    lt/LC_MESSAGES/messages.po
U    sq/LC_MESSAGES/messages.po
U    ca/LC_MESSAGES/messages.po
U    sr/LC_MESSAGES/messages.po
A    ru
A    ru/LC_MESSAGES
A    ru/LC_MESSAGES/messages.po
U    de/LC_MESSAGES/messages.po
U    zh_TW/LC_MESSAGES/messages.po
U    templates/LC_MESSAGES/messages.pot
U    ar/LC_MESSAGES/messages.po
A    eo
A    eo/LC_MESSAGES
A    eo/LC_MESSAGES/messages.po
U    cs/LC_MESSAGES/messages.po
A    pt_BR
A    pt_BR/LC_MESSAGES
A    pt_BR/LC_MESSAGES/messages.po
U    es/LC_MESSAGES/messages.po
U    fr/LC_MESSAGES/messages.po
U    nl/LC_MESSAGES/messages.po
U    ko/LC_MESSAGES/messages.po
U    en_US/LC_MESSAGES/messages.po
U    pl/LC_MESSAGES/messages.po
U    hu/LC_MESSAGES/messages.po
U    sl/LC_MESSAGES/messages.po
Updated to revision 97182.
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ ./compile.sh
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ cd /data/genericrhel6/src/mozillians.org/mozillians
+ find . -type f -name .gitignore -or -name '*.pyc' -delete
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ cd /data/genericrhel6/src/mozillians.org/mozillians
+ python ./manage.py compress_assets
+ checkretval
+ retval=0
+ [[ 0 -gt 0 ]]
+ cd /data/genericrhel6/src/mozillians.org/mozillians
+ python vendor/src/schematic/schematic migrations
Running migration 5:
CREATE TABLE `group` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `name` varchar(50) NOT NULL UNIQUE,
    `auto_complete` bool NOT NULL,
    `system` bool NOT NULL
) ENGINE=InnoDB CHARSET=utf8;

CREATE INDEX `group_3fc10b3b` ON `group` (`auto_complete`);
CREATE INDEX `group_43de5bc6` ON `group` (`system`);

CREATE TABLE `profile_groups` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `userprofile_id` integer NOT NULL,
    `group_id` integer NOT NULL,
    UNIQUE (`userprofile_id`, `group_id`)
) ENGINE=InnoDB CHARSET=utf8;

ALTER TABLE `profile_groups` ADD CONSTRAINT `group_id_refs_id_1cbb0b43` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`);
ALTER TABLE `profile_groups` ADD CONSTRAINT `userprofile_id_refs_id_4a989baa` FOREIGN KEY (`userprofile_id`) REFERENCES `profile` (`id`);

That took 1.50 seconds
################################################## 

Running migration 6:
ALTER TABLE `group` ADD COLUMN `url` varchar(50) NOT NULL;

CREATE INDEX `group_a4b49ab` ON `group` (`url`);

That took 0.64 seconds
################################################## 

Running migration 7:
INSERT INTO `group` (`name`, `auto_complete`, `system`, `url`)
VALUES
    ('engineering:accessibility', 1, 1, 'engineering-accessibility'),
    ('engineering:graphics', 1, 1, 'engineering-graphics'),
    ('engineering:css', 1, 1, 'engineering-css'),
    ('engineering:html', 1, 1, 'engineering-html'),
    ('engineering:networking', 1, 1, 'engineering-networking'),
    ('engineering:svg', 1, 1, 'engineering-svg'),
    ('engineering:javascript', 1, 1, 'engineering-javascript'),
    ('engineering:apps', 1, 1, 'engineering-apps'),
    ('engineering:mobile', 1, 1, 'engineering-mobile'),
    ('engineering:boot2gecko', 1, 1, 'engineering-boot2gecko'),
    ('engineering:quality assurance', 1, 1, 'engineering-quality-assurance'),
    ('engineering:crashkill', 1, 1, 'engineering-crashkill'),
    ('engineering:tools and automation', 1, 1, 'engineering-tools-and-automation'),
    ('engineering:release engineering', 1, 1, 'engineering-release-engineering'),
    ('engineering:privacy', 1, 1, 'engineering-privacy'),
    ('engineering:security', 1, 1, 'engineering-security'),
    ('products:firefox', 1, 1, 'products-firefox'),
    ('products:thunderbirrd', 1, 1, 'products-thunderbirrd'),
    ('products:seamonkey', 1, 1, 'products-seamonkey'),
    ('products:fennec', 1, 1, 'products-fennec'),
    ('products:pancake', 1, 1, 'products-pancake'),
    ('products:firefox home', 1, 1, 'products-firefox-home'),
    ('products:add-ons', 1, 1, 'products-add-ons'),
    ('products:jetpack', 1, 1, 'products-jetpack'),
    ('products:support', 1, 1, 'products-support'),
    ('products:metrics', 1, 1, 'products-metrics'),
    ('products:ux', 1, 1, 'products-ux'),
    ('products:user research', 1, 1, 'products-user-research'),
    ('engagement:developer documentation', 1, 1, 'engagement-developer-documentation'),
    ('engagement:product marketing', 1, 1, 'engagement-product-marketing'),
    ('engagement:public relations', 1, 1, 'engagement-public-relations'),
    ('engagement:creative', 1, 1, 'engagement-creative'),
    ('engagement:developer engagement', 1, 1, 'engagement-developer-engagement'),
    ('engagement:contributor engagement', 1, 1, 'engagement-contributor-engagement'),
    ('engagement:steward', 1, 1, 'engagement-steward'),
    ('engagement:user engagement', 1, 1, 'engagement-user-engagement'),
    ('engagement:market insights', 1, 1, 'engagement-market-insights'),
    ('engagement:student reps', 1, 1, 'engagement-student-reps'),
    ('engagement:reps', 1, 1, 'engagement-reps'),
    ('innovation:labs', 1, 1, 'innovation-labs'),
    ('innovation:web development', 1, 1, 'innovation-web-development'),
    ('innovation:systems administration', 1, 1, 'innovation-systems administration'),
    ('innovation:webfwd', 1, 1, 'innovation-webfwd'),
    ('l10n:af', 1, 1, 'l10n-af'),
    ('l10n:ak', 1, 1, 'l10n-ak'),
    ('l10n:an', 1, 1, 'l10n-an'),
    ('l10n:as', 1, 1, 'l10n-as'),
    ('l10n:ast', 1, 1, 'l10n-ast'),
    ('l10n:bal', 1, 1, 'l10n-bal'),
    ('l10n:be', 1, 1, 'l10n-be'),
    ('l10n:bg', 1, 1, 'l10n-bg'),
    ('l10n:bg-iv', 1, 1, 'l10n-bg-iv'),
    ('l10n:bn-bd', 1, 1, 'l10n-bn-bd'),
    ('l10n:bn-in', 1, 1, 'l10n-bn-in'),
    ('l10n:bpy', 1, 1, 'l10n-bpy'),
    ('l10n:br', 1, 1, 'l10n-br'),
    ('l10n:bs', 1, 1, 'l10n-bs'),
    ('l10n:ca', 1, 1, 'l10n-ca'),
    ('l10n:ca-valencia', 1, 1, 'l10n-ca-valencia'),
    ('l10n:co', 1, 1, 'l10n-co'),
    ('l10n:crh', 1, 1, 'l10n-crh'),
    ('l10n:cs', 1, 1, 'l10n-cs'),
    ('l10n:cy', 1, 1, 'l10n-cy'),
    ('l10n:da', 1, 1, 'l10n-da'),
    ('l10n:de', 1, 1, 'l10n-de'),
    ('l10n:myv', 1, 1, 'l10n-myv'),
    ('l10n:dz', 1, 1, 'l10n-dz'),
    ('l10n:el', 1, 1, 'l10n-el'),
    ('l10n:en-gb', 1, 1, 'l10n-en-gb'),
    ('l10n:en-shaw', 1, 1, 'l10n-en-shaw'),
    ('l10n:en-za', 1, 1, 'l10n-en-za'),
    ('l10n:eo', 1, 1, 'l10n-eo'),
    ('l10n:es-ar', 1, 1, 'l10n-es-ar'),
    ('l10n:es-cl', 1, 1, 'l10n-es-cl'),
    ('l10n:es-es', 1, 1, 'l10n-es-es'),
    ('l10n:es-mx', 1, 1, 'l10n-es-mx'),
    ('l10n:et', 1, 1, 'l10n-et'),
    ('l10n:eu', 1, 1, 'l10n-eu'),
    ('l10n:fa', 1, 1, 'l10n-fa'),
    ('l10n:fi', 1, 1, 'l10n-fi'),
    ('l10n:fj-fj', 1, 1, 'l10n-fj-fj'),
    ('l10n:fj', 1, 1, 'l10n-fj'),
    ('l10n:fr', 1, 1, 'l10n-fr'),
    ('l10n:fur', 1, 1, 'l10n-fur'),
    ('l10n:fy-nl', 1, 1, 'l10n-fy-nl'),
    ('l10n:ga-ie', 1, 1, 'l10n-ga-ie'),
    ('l10n:gd', 1, 1, 'l10n-gd'),
    ('l10n:gl', 1, 1, 'l10n-gl'),
    ('l10n:gsc', 1, 1, 'l10n-gsc'),
    ('l10n:gu-in', 1, 1, 'l10n-gu-in'),
    ('l10n:he', 1, 1, 'l10n-he'),
    ('l10n:hi-in', 1, 1, 'l10n-hi-in'),
    ('l10n:hr', 1, 1, 'l10n-hr'),
    ('l10n:ht', 1, 1, 'l10n-ht'),
    ('l10n:hu', 1, 1, 'l10n-hu'),
    ('l10n:hy-am', 1, 1, 'l10n-hy-am'),
    ('l10n:id', 1, 1, 'l10n-id'),
    ('l10n:ig', 1, 1, 'l10n-ig'),
    ('l10n:ilo', 1, 1, 'l10n-ilo'),
    ('l10n:is', 1, 1, 'l10n-is'),
    ('l10n:it', 1, 1, 'l10n-it'),
    ('l10n:ja', 1, 1, 'l10n-ja'),
    ('l10n:jbo', 1, 1, 'l10n-jbo'),
    ('l10n:ka', 1, 1, 'l10n-ka'),
    ('l10n:kab', 1, 1, 'l10n-kab'),
    ('l10n:ky', 1, 1, 'l10n-ky'),
    ('l10n:kk', 1, 1, 'l10n-kk'),
    ('l10n:km', 1, 1, 'l10n-km'),
    ('l10n:kn', 1, 1, 'l10n-kn'),
    ('l10n:ko', 1, 1, 'l10n-ko'),
    ('l10n:ku', 1, 1, 'l10n-ku'),
    ('l10n:kw', 1, 1, 'l10n-kw'),
    ('l10n:la', 1, 1, 'l10n-la'),
    ('l10n:lb', 1, 1, 'l10n-lb'),
    ('l10n:lg', 1, 1, 'l10n-lg'),
    ('l10n:lmo', 1, 1, 'l10n-lmo'),
    ('l10n:lo', 1, 1, 'l10n-lo'),
    ('l10n:lt', 1, 1, 'l10n-lt'),
    ('l10n:lv', 1, 1, 'l10n-lv'),
    ('l10n:mai', 1, 1, 'l10n-mai'),
    ('l10n:mg', 1, 1, 'l10n-mg'),
    ('l10n:mi', 1, 1, 'l10n-mi'),
    ('l10n:mk', 1, 1, 'l10n-mk'),
    ('l10n:ml', 1, 1, 'l10n-ml'),
    ('l10n:mn', 1, 1, 'l10n-mn'),
    ('l10n:mr', 1, 1, 'l10n-mr'),
    ('l10n:my', 1, 1, 'l10n-my'),
    ('l10n:nb-no', 1, 1, 'l10n-nb-no'),
    ('l10n:ne-np', 1, 1, 'l10n-ne-np'),
    ('l10n:nl', 1, 1, 'l10n-nl'),
    ('l10n:nn-no', 1, 1, 'l10n-nn-no'),
    ('l10n:nso', 1, 1, 'l10n-nso'),
    ('l10n:ny', 1, 1, 'l10n-ny'),
    ('l10n:oc', 1, 1, 'l10n-oc'),
    ('l10n:oc-es-aranese', 1, 1, 'l10n-oc-es-aranese'),
    ('l10n:or', 1, 1, 'l10n-or'),
    ('l10n:os', 1, 1, 'l10n-os'),
    ('l10n:pa', 1, 1, 'l10n-pa'),
    ('l10n:pl', 1, 1, 'l10n-pl'),
    ('l10n:pt-br', 1, 1, 'l10n-pt-br'),
    ('l10n:pt-pt', 1, 1, 'l10n-pt-pt'),
    ('l10n:qu', 1, 1, 'l10n-qu'),
    ('l10n:rm', 1, 1, 'l10n-rm'),
    ('l10n:ro', 1, 1, 'l10n-ro'),
    ('l10n:ru', 1, 1, 'l10n-ru'),
    ('l10n:rw', 1, 1, 'l10n-rw'),
    ('l10n:sc', 1, 1, 'l10n-sc'),
    ('l10n:si', 1, 1, 'l10n-si'),
    ('l10n:si-lk', 1, 1, 'l10n-si-lk'),
    ('l10n:sk', 1, 1, 'l10n-sk'),
    ('l10n:sl', 1, 1, 'l10n-sl'),
    ('l10n:sna-zw', 1, 1, 'l10n-sna-zw'),
    ('l10n:sq', 1, 1, 'l10n-sq'),
    ('l10n:sr', 1, 1, 'l10n-sr'),
    ('l10n:srd', 1, 1, 'l10n-srd'),
    ('l10n:su', 1, 1, 'l10n-su'),
    ('l10n:sv-se', 1, 1, 'l10n-sv-se'),
    ('l10n:ta', 1, 1, 'l10n-ta'),
    ('l10n:ta-lk', 1, 1, 'l10n-ta-lk'),
    ('l10n:te', 1, 1, 'l10n-te'),
    ('l10n:tg', 1, 1, 'l10n-tg'),
    ('l10n:th', 1, 1, 'l10n-th'),
    ('l10n:ti', 1, 1, 'l10n-ti'),
    ('l10n:tl', 1, 1, 'l10n-tl'),
    ('l10n:to', 1, 1, 'l10n-to'),
    ('l10n:tr', 1, 1, 'l10n-tr'),
    ('l10n:tt', 1, 1, 'l10n-tt'),
    ('l10n:uk', 1, 1, 'l10n-uk'),
    ('l10n:uz', 1, 1, 'l10n-uz'),
    ('l10n:ug', 1, 1, 'l10n-ug'),
    ('l10n:vi', 1, 1, 'l10n-vi'),
    ('l10n:wa', 1, 1, 'l10n-wa'),
    ('l10n:wo', 1, 1, 'l10n-wo'),
    ('l10n:yo-ng', 1, 1, 'l10n-yo-ng'),
    ('l10n:yue', 1, 1, 'l10n-yue'),
    ('l10n:zap-mx-diiste', 1, 1, 'l10n-zap-mx-diiste'),
    ('l10n:zh-cn', 1, 1, 'l10n-zh-cn'),
    ('l10n:zh-tw', 1, 1, 'l10n-zh-cn');

That took 0.06 seconds
################################################## 

Running migration 8:
DELETE FROM `profile_groups`;
DELETE FROM `group`;

ALTER TABLE `group` ADD COLUMN `always_auto_complete` bool NOT NULL;
ALTER TABLE `group` AUTO_INCREMENT=1;

INSERT INTO `group` (`name`, `auto_complete`, `always_auto_complete`, `url`)
VALUES
    ('accessibility', 1, 1, 'accessibility'),
    ('graphics', 1, 1, 'graphics'),
    ('css', 1, 1, 'css'),
    ('html', 1, 1, 'html'),
    ('networking', 1, 1, 'networking'),
    ('svg', 1, 1, 'svg'),
    ('javascript', 1, 1, 'javascript'),
    ('apps', 1, 1, 'apps'),
    ('mobile', 1, 1, 'mobile'),
    ('boot2gecko', 1, 1, 'boot2gecko'),
    ('quality assurance', 1, 1, 'quality-assurance'),
    ('crashkill', 1, 1, 'crashkill'),
    ('tools and automation', 1, 1, 'tools-and-automation'),
    ('release engineering', 1, 1, 'release-engineering'),
    ('privacy', 1, 1, 'privacy'),
    ('security', 1, 1, 'security'),
    ('firefox', 1, 1, 'firefox'),
    ('thunderbirrd', 1, 1, 'thunderbirrd'),
    ('seamonkey', 1, 1, 'seamonkey'),
    ('fennec', 1, 1, 'fennec'),
    ('pancake', 1, 1, 'pancake'),
    ('firefox home', 1, 1, 'firefox-home'),
    ('add-ons', 1, 1, 'add-ons'),
    ('jetpack', 1, 1, 'jetpack'),
    ('support', 1, 1, 'support'),
    ('metrics', 1, 1, 'metrics'),
    ('ux', 1, 1, 'ux'),
    ('user research', 1, 1, 'user-research'),
    ('developer documentation', 1, 1, 'developer-documentation'),
    ('product marketing', 1, 1, 'product-marketing'),
    ('public relations', 1, 1, 'public-relations'),
    ('creative', 1, 1, 'creative'),
    ('developer engagement', 1, 1, 'developer-engagement'),
    ('contributor engagement', 1, 1, 'contributor-engagement'),
    ('steward', 1, 1, 'steward'),
    ('user engagement', 1, 1, 'user-engagement'),
    ('market insights', 1, 1, 'market-insights'),
    ('student reps', 1, 1, 'student-reps'),
    ('reps', 1, 1, 'reps'),
    ('labs', 1, 1, 'labs'),
    ('web development', 1, 1, 'web-development'),
    ('systems administration', 1, 1, 'systems administration'),
    ('webfwd', 1, 1, 'webfwd'),
    ('l10n:af', 1, 1, 'l10n-af'),
    ('l10n:ak', 1, 1, 'l10n-ak'),
    ('l10n:an', 1, 1, 'l10n-an'),
    ('l10n:as', 1, 1, 'l10n-as'),
    ('l10n:ast', 1, 1, 'l10n-ast'),
    ('l10n:bal', 1, 1, 'l10n-bal'),
    ('l10n:be', 1, 1, 'l10n-be'),
    ('l10n:bg', 1, 1, 'l10n-bg'),
    ('l10n:bg-iv', 1, 1, 'l10n-bg-iv'),
    ('l10n:bn-bd', 1, 1, 'l10n-bn-bd'),
    ('l10n:bn-in', 1, 1, 'l10n-bn-in'),
    ('l10n:bpy', 1, 1, 'l10n-bpy'),
    ('l10n:br', 1, 1, 'l10n-br'),
    ('l10n:bs', 1, 1, 'l10n-bs'),
    ('l10n:ca', 1, 1, 'l10n-ca'),
    ('l10n:ca-valencia', 1, 1, 'l10n-ca-valencia'),
    ('l10n:co', 1, 1, 'l10n-co'),
    ('l10n:crh', 1, 1, 'l10n-crh'),
    ('l10n:cs', 1, 1, 'l10n-cs'),
    ('l10n:cy', 1, 1, 'l10n-cy'),
    ('l10n:da', 1, 1, 'l10n-da'),
    ('l10n:de', 1, 1, 'l10n-de'),
    ('l10n:myv', 1, 1, 'l10n-myv'),
    ('l10n:dz', 1, 1, 'l10n-dz'),
    ('l10n:el', 1, 1, 'l10n-el'),
    ('l10n:en-gb', 1, 1, 'l10n-en-gb'),
    ('l10n:en-shaw', 1, 1, 'l10n-en-shaw'),
    ('l10n:en-za', 1, 1, 'l10n-en-za'),
    ('l10n:eo', 1, 1, 'l10n-eo'),
    ('l10n:es-ar', 1, 1, 'l10n-es-ar'),
    ('l10n:es-cl', 1, 1, 'l10n-es-cl'),
    ('l10n:es-es', 1, 1, 'l10n-es-es'),
    ('l10n:es-mx', 1, 1, 'l10n-es-mx'),
    ('l10n:et', 1, 1, 'l10n-et'),
    ('l10n:eu', 1, 1, 'l10n-eu'),
    ('l10n:fa', 1, 1, 'l10n-fa'),
    ('l10n:fi', 1, 1, 'l10n-fi'),
    ('l10n:fj-fj', 1, 1, 'l10n-fj-fj'),
    ('l10n:fj', 1, 1, 'l10n-fj'),
    ('l10n:fr', 1, 1, 'l10n-fr'),
    ('l10n:fur', 1, 1, 'l10n-fur'),
    ('l10n:fy-nl', 1, 1, 'l10n-fy-nl'),
    ('l10n:ga-ie', 1, 1, 'l10n-ga-ie'),
    ('l10n:gd', 1, 1, 'l10n-gd'),
    ('l10n:gl', 1, 1, 'l10n-gl'),
    ('l10n:gsc', 1, 1, 'l10n-gsc'),
    ('l10n:gu-in', 1, 1, 'l10n-gu-in'),
    ('l10n:he', 1, 1, 'l10n-he'),
    ('l10n:hi-in', 1, 1, 'l10n-hi-in'),
    ('l10n:hr', 1, 1, 'l10n-hr'),
    ('l10n:ht', 1, 1, 'l10n-ht'),
    ('l10n:hu', 1, 1, 'l10n-hu'),
    ('l10n:hy-am', 1, 1, 'l10n-hy-am'),
    ('l10n:id', 1, 1, 'l10n-id'),
    ('l10n:ig', 1, 1, 'l10n-ig'),
    ('l10n:ilo', 1, 1, 'l10n-ilo'),
    ('l10n:is', 1, 1, 'l10n-is'),
    ('l10n:it', 1, 1, 'l10n-it'),
    ('l10n:ja', 1, 1, 'l10n-ja'),
    ('l10n:jbo', 1, 1, 'l10n-jbo'),
    ('l10n:ka', 1, 1, 'l10n-ka'),
    ('l10n:kab', 1, 1, 'l10n-kab'),
    ('l10n:ky', 1, 1, 'l10n-ky'),
    ('l10n:kk', 1, 1, 'l10n-kk'),
    ('l10n:km', 1, 1, 'l10n-km'),
    ('l10n:kn', 1, 1, 'l10n-kn'),
    ('l10n:ko', 1, 1, 'l10n-ko'),
    ('l10n:ku', 1, 1, 'l10n-ku'),
    ('l10n:kw', 1, 1, 'l10n-kw'),
    ('l10n:la', 1, 1, 'l10n-la'),
    ('l10n:lb', 1, 1, 'l10n-lb'),
    ('l10n:lg', 1, 1, 'l10n-lg'),
    ('l10n:lmo', 1, 1, 'l10n-lmo'),
    ('l10n:lo', 1, 1, 'l10n-lo'),
    ('l10n:lt', 1, 1, 'l10n-lt'),
    ('l10n:lv', 1, 1, 'l10n-lv'),
    ('l10n:mai', 1, 1, 'l10n-mai'),
    ('l10n:mg', 1, 1, 'l10n-mg'),
    ('l10n:mi', 1, 1, 'l10n-mi'),
    ('l10n:mk', 1, 1, 'l10n-mk'),
    ('l10n:ml', 1, 1, 'l10n-ml'),
    ('l10n:mn', 1, 1, 'l10n-mn'),
    ('l10n:mr', 1, 1, 'l10n-mr'),
    ('l10n:my', 1, 1, 'l10n-my'),
    ('l10n:nb-no', 1, 1, 'l10n-nb-no'),
    ('l10n:ne-np', 1, 1, 'l10n-ne-np'),
    ('l10n:nl', 1, 1, 'l10n-nl'),
    ('l10n:nn-no', 1, 1, 'l10n-nn-no'),
    ('l10n:nso', 1, 1, 'l10n-nso'),
    ('l10n:ny', 1, 1, 'l10n-ny'),
    ('l10n:oc', 1, 1, 'l10n-oc'),
    ('l10n:oc-es-aranese', 1, 1, 'l10n-oc-es-aranese'),
    ('l10n:or', 1, 1, 'l10n-or'),
    ('l10n:os', 1, 1, 'l10n-os'),
    ('l10n:pa', 1, 1, 'l10n-pa'),
    ('l10n:pl', 1, 1, 'l10n-pl'),
    ('l10n:pt-br', 1, 1, 'l10n-pt-br'),
    ('l10n:pt-pt', 1, 1, 'l10n-pt-pt'),
    ('l10n:qu', 1, 1, 'l10n-qu'),
    ('l10n:rm', 1, 1, 'l10n-rm'),
    ('l10n:ro', 1, 1, 'l10n-ro'),
    ('l10n:ru', 1, 1, 'l10n-ru'),
    ('l10n:rw', 1, 1, 'l10n-rw'),
    ('l10n:sc', 1, 1, 'l10n-sc'),
    ('l10n:si', 1, 1, 'l10n-si'),
    ('l10n:si-lk', 1, 1, 'l10n-si-lk'),
    ('l10n:sk', 1, 1, 'l10n-sk'),
    ('l10n:sl', 1, 1, 'l10n-sl'),
    ('l10n:sna-zw', 1, 1, 'l10n-sna-zw'),
    ('l10n:sq', 1, 1, 'l10n-sq'),
    ('l10n:sr', 1, 1, 'l10n-sr'),
    ('l10n:srd', 1, 1, 'l10n-srd'),
    ('l10n:su', 1, 1, 'l10n-su'),
    ('l10n:sv-se', 1, 1, 'l10n-sv-se'),
    ('l10n:ta', 1, 1, 'l10n-ta'),
    ('l10n:ta-lk', 1, 1, 'l10n-ta-lk'),
    ('l10n:te', 1, 1, 'l10n-te'),
    ('l10n:tg', 1, 1, 'l10n-tg'),
    ('l10n:th', 1, 1, 'l10n-th'),
    ('l10n:ti', 1, 1, 'l10n-ti'),
    ('l10n:tl', 1, 1, 'l10n-tl'),
    ('l10n:to', 1, 1, 'l10n-to'),
    ('l10n:tr', 1, 1, 'l10n-tr'),
    ('l10n:tt', 1, 1, 'l10n-tt'),
    ('l10n:uk', 1, 1, 'l10n-uk'),
    ('l10n:uz', 1, 1, 'l10n-uz'),
    ('l10n:ug', 1, 1, 'l10n-ug'),
    ('l10n:vi', 1, 1, 'l10n-vi'),
    ('l10n:wa', 1, 1, 'l10n-wa'),
    ('l10n:wo', 1, 1, 'l10n-wo'),
    ('l10n:yo-ng', 1, 1, 'l10n-yo-ng'),
    ('l10n:yue', 1, 1, 'l10n-yue'),
    ('l10n:zap-mx-diiste', 1, 1, 'l10n-zap-mx-diiste'),
    ('l10n:zh-cn', 1, 1, 'l10n-zh-cn'),
    ('l10n:zh-tw', 1, 1, 'l10n-zh-cn');

INSERT INTO `group` (`name`, `system`, `url`)
VALUES
    ('staff', 1, 'staff');

That took 0.99 seconds
##################################################
Cronjob has been set up too.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.