743897 - db acls for byob

Status: RESOLVED FIXED

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

Description

[Dustin J. Mitchell [:dustin] (he/him)]

user 'byob'@'10.22.74.132' needs access to on tm-c01.

if we can get the scl3 VIP flow'd immediately, I'll point it at that instead.

Comment 1

[Dustin J. Mitchell [:dustin] (he/him)]

The production flow is time-sensitive - it's blocking putting this back into service.

Staging (and I'm aware this is down right now) is:
  byob_user@10.22.74.133 on stage-rw-vip.db.scl3
so please update that when it's set up.  I just added bug 743899 to get that flow put in.

Comment 2

[Dustin J. Mitchell [:dustin] (he/him)]

db's are byob and byob_staging, respectively.  Sorry, it's late, I'm tired.

Comment 3

[Sheeri Cabral [:sheeri]]

Done on tm-c01, which only has the byob database:

mysql> GRANT ALL PRIVILEGES ON `byob`.* TO 'byob'@'10.22.74.132' IDENTIFIED BY PASSWORD 'password hash elided';
Query OK, 0 rows affected (0.03 sec)

Done!

Done on stage1.db.scl3.mozilla.com, which has the byob_staging database:
mysql> GRANT ALL PRIVILEGES ON `byob_staging`.* TO 'byob_user'@'10.22.74.133'  IDENTIFIED BY PASSWORD 'password hash elided';
Query OK, 0 rows affected (0.01 sec)