Prepare and check storage layer for nupwiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Maintenance_bot
	Apr 1 2025, 1:08 PM

Description

The new wiki's visibility will be: Public.

Status	Assigned	Task
Resolved	Pppery	T390711 Post-creation work for nupwiki
Resolved	Zabe	T390384 Create Wikipedia Nupe
Resolved	FCeratto-WMF	T390710 Prepare and check storage layer for nupwiki

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 1 2025, 1:08 PM

Let us know when the database is created. Let's redact this with the new cookbook cc @FCeratto-WMF

wiki has been created

In T390710#10766932, @Zabe wrote:

wiki has been created

@FCeratto-WMF can you take care of this and test the new cookbook?

The sanitization is done except the final step on clouddb e.g. an-redacteddb1001.eqiad.wmnet with CREATE DATABASE and GRANT SELECT

The database was created on an-redacteddb1001 and permission are granted

This is not done, we got alerts again.

We are debugging the cookbook ran previously to make sure it's doing the cleanup correctly.

The cookbook has been updated; the PII data has been sanitized, the nupwiki_p table has been created and has the grant applied.

I think the nupwiki_p database should be created also on clouddb hosts, specifically on clouddb1016 and clouddb1020.

I created the databases and set the grants on the clouddb hosts.
This led to bugfix and improvements in https://gerrit.wikimedia.org/r/c/operations/cookbooks/+/1139035