Prepare and check storage layer for skrwiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Maintenance_bot
	Nov 22 2020, 5:09 PM

Description

The new wiki's visibility will be: Public.

Related Objects
Search...

Status	Subtype	Assigned	Task
Resolved	Release	Xqt	T268464 Pywikibot release 5.3.0 dependencies
Resolved	Feature	Xqt	T268414 Add support for skrwiki to Pywikibot
Resolved		None	T268413 Add skrwiki to RESTBase
Resolved		Ladsgroup	T268415 Add Wikidata support for skrwiki
Resolved		Urbanecm	T268410 Create Wikipedia Saraiki
Resolved		• nskaggs	T268412 Prepare and check storage layer for skrwiki

Event Timeline

Maintenance_bot created this task.Nov 22 2020, 5:09 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 22 2020, 5:09 PM

LSobanski subscribed.Nov 22 2020, 7:31 PM

Thanks, let us know when the database is created, so we can sanitize it.

LSobanski moved this task from Triage to Blocked on the DBA board.Nov 23 2020, 11:04 AM

https://phabricator.wikimedia.org/T265321 was resolved last week so the ipblocks_restrictions alter should no longer be necessary.

LSobanski triaged this task as Medium priority.Nov 23 2020, 11:25 AM

bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Dec 4 2020, 11:19 PM

In T268412#6640176, @LSobanski wrote:

Thanks, let us know when the database is created, so we can sanitize it.

DB got created.

I will sanitize it

Marostegui moved this task from Blocked to In progress on the DBA board.Dec 15 2020, 3:08 PM

This has been sanitized. I have tested the triggers creating my user.
I am now running a check data on labsdb1009, 1010, 1011, 1012 as well as clouddb1020:3315 and clouddb1016:3315

After that still pending:

_p database creation
grants for labsdbuser role for that database.

Private data check was clean
_p database created
Grants added

*****labsdb1009*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO 'labsdbuser'
*****labsdb1010*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO 'labsdbuser'
*****labsdb1011*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO 'labsdbuser'
*****labsdb1012*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO 'labsdbuser'
*****clouddb1016:3315*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO `labsdbuser`
*****clouddb1020:3315*****
Database (skrwiki%)
skrwiki
skrwiki_p
GRANT SELECT, SHOW VIEW ON `skrwiki\\_p`.* TO `labsdbuser`

This is ready for cloud-services-team

Marostegui removed Marostegui as the assignee of this task.Dec 16 2020, 8:41 AM

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

Marostegui added a project: cloud-services-team.

Restricted Application edited projects, added cloud-services-team (Kanban); removed cloud-services-team. · View Herald TranscriptDec 16 2020, 8:41 AM