create databases and user permissions for mozillapopcorn.org

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
6 years ago
3 years ago

People

(Reporter: cturra, Unassigned)

Tracking

Details

(Reporter)

Description

6 years ago
this project is being promoted out of labs and will need dev, stage and production databases/users on the generic db cluster.


  dev: popcornmaker-dev.allizom.org
  stage: popcornmaker..allizom.org
  prod: mozillapopcorn.org
(Reporter)

Updated

6 years ago
Blocks: 750203, 750204, 750205
on dev/stage:
mysql> create database popcornmaker_dev; create database popcornmaker_allizom_org;
Query OK, 1 row affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

mysql> grant all on popcornmaker_dev.* to pmaker_dev@'10.8.70.20_' identified by 'password elided'; grant all on popcornmaker_allizom_org.* to pmaker@'10.8.70.20_' identified by 'password elided';
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)




on production:

mysql> create database mozillapopcorn_org;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on mozillapopcorn_org.* to pmaker@'10.8.70.20_' identified by 'password elided';
Query OK, 0 rows affected (0.00 sec)

dev1.db.phx1.mozilla.com:/home/cturra/popcorn_auth.txt has the passwords for all.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.