986623 - create database and user permission for bedrock demo{45}

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Chris Turra [:cturra]]

per bug 986571, bedrock needs two additional demo environments for building/testing/demo-ing. similar to the db creation work done in bug 902012, we need databases and users setup for the following environments:

  - www-demo4.allizom.org
  - www-demo5.allizom.org 


all of these reqeusts will be coming through zeus.

Comment 1

[Sheeri Cabral [:sheeri]]

these should go on dev in phx.

Comment 2

[Sheeri Cabral [:sheeri]]

mysql> create database if not exists www_demo4_allizom_org;
Query OK, 1 row affected (0.04 sec)

mysql> create database if not exists www_demo5_allizom_org;
Query OK, 1 row affected (0.07 sec)

Created users:
bedrock_demo4 all perms on www_demo4_allizom_org
bedrock_demo4_ro read perms on www_demo4_allizom_org
bedrock_demo5 all perms on www_demo5_allizom_org
bedrock_demo5_ro read perms on www_demo5_allizom_org

Will send passwords under separate cover.

Comment 3

[Sheeri Cabral [:sheeri]]

13:03 < sheeri> cturra: OK, your homedir on dev1.db.phx1.mozilla.com demo45auth 
                file has the passwords