Page MenuHomePhabricator

Prepare and check storage layer for igwiktionary
Closed, ResolvedPublic

Description

The new wiki's visibility will be: Public.

Event Timeline

Zabe changed the edit policy from "Custom Policy" to "All Users".Aug 5 2022, 7:43 PM
Ladsgroup triaged this task as Medium priority.Aug 11 2022, 5:30 AM
Ladsgroup moved this task from Triage to Blocked on the DBA board.

Let us know when the wiki is created so we can sanitize it

Let us know when the wiki is created so we can sanitize it

the wiki got created but we were not informed. It happens.

I can take over and do it if that's fine with you, you can check if I mess up something.

I think I did it:

root@db1154:~# for i in igwiktionary; do echo $i; redact_sanitarium.sh -d $i -S /run/mysqld/mysqld.s5.sock | mysql -S /run/mysqld/mysqld.s5.sock $i ; done
igwiktionary
root@db1154:~# check_private_data.py -S /run/mysqld/mysqld.s5.sock
-- Non-public databases that are present:
-- Non-public tables that are present:
-- Unfiltered columns that are present:
root@db1154:~#

Is that part done? Then https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services?

That part is done, but the grants are still missing:

mysql:root@localhost [(none)]> set session sql_log_bin=0;create database igwiktionary_p;GRANT SELECT, SHOW VIEW ON `igwiktionary_p`.* TO `labsdbuser`;
Query OK, 0 rows affected (0.000 sec)

Query OK, 1 row affected (0.001 sec)

Query OK, 0 rows affected (0.002 sec)

@BTullis this is now ready for the views creation.

Thank you .
Running the cookbook now.

btullis@cumin1001:~$ sudo cookbook sre.wikireplicas.add-wiki --task-id T314645 igwiktionary

Mentioned in SAL (#wikimedia-operations) [2022-11-24T13:38:43Z] <btullis@cumin1001> Added views for new wiki: igwiktionary T314645