Page MenuHomePhabricator

Drop labtestwikitech database from m5
Closed, ResolvedPublic

Description

Drop labtestwikitech database from m5

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 21 2019, 6:23 AM
Marostegui triaged this task as Medium priority.Oct 21 2019, 6:24 AM
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 updated the task description. (Show Details)Oct 21 2019, 6:28 AM
Marostegui renamed this task from Drop labtestwikitech from m5 to Drop labtestwikitech database from m5.Oct 21 2019, 6:48 AM
Marostegui updated the task description. (Show Details)Tue, Nov 12, 7:37 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

Marostegui updated the task description. (Show Details)Tue, Nov 12, 9:45 AM
Marostegui updated the task description. (Show Details)Tue, Nov 12, 9:47 AM
Marostegui updated the task description. (Show Details)

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 closed this task as Resolved.Tue, Nov 12, 10:34 AM
Marostegui updated the task description. (Show Details)