Page MenuHomePhabricator

Drop labtestwikitech database from m5
Closed, ResolvedPublic

Description

Drop labtestwikitech database from m5

Event Timeline

Marostegui moved this task from Triage to In progress on the DBA board.

These are the active grants on the DB:

GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.32.22'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.32.24'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.48.45'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.0.196'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.16.77'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.32.16'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'208.80.153.14'
GRANT SELECT, INSERT, UPDATE, DELETE ON `labtestwiki`.* TO 'wikiuser'@'208.80.153.14'
Marostegui renamed this task from Drop labtestwikitech from m5 to Drop labtestwikitech database from m5.Oct 21 2019, 6:48 AM

Mentioned in SAL (#wikimedia-operations) [2019-11-12T09:42:04Z] <marostegui> Remove privileges for labtestwiki on m5 - T236010

These are the active grants on the DB:

GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.32.22'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.32.24'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.192.48.45'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.0.196'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.16.77'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'10.64.32.16'
GRANT ALL PRIVILEGES ON `labtestwiki`.* TO 'wikiadmin'@'208.80.153.14'
GRANT SELECT, INSERT, UPDATE, DELETE ON `labtestwiki`.* TO 'wikiuser'@'208.80.153.14'

These grants have been deleted

Mentioned in SAL (#wikimedia-operations) [2019-11-12T10:33:22Z] <marostegui> Drop labtestwiki database from m5 master db1133 - T236010

I have finally dropped the labtestwiki database from m5, it has had its tabled renamed for a long time without any issues: T233236#5585652
Backup is at: db1133:/root/T236010_backup_labtestwiki_.sql

Marostegui updated the task description. (Show Details)