Mentioned in SAL (#wikimedia-operations) [2018-11-14T14:10:13Z] <Reedy> Wiki created T205714 T207584 T205713 T206916

Mentioned in SAL (#wikimedia-operations) [2018-11-15T10:07:42Z] <banyek> sanitizing db2094 ( T205714 T207584 T205713 T206916 )

Mentioned in SAL (#wikimedia-operations) [2018-11-15T10:15:31Z] <banyek> sanitizing db1124 ( T205714 T207584 T205713 T206916 )

The sanitization is done, but before I route this to the cloud team we need to check if the triggers work. I need for somebody to log in and ping me to check if the sensitive data got removed.

I also created the privileges for the cloud team to create the views, but this ticket is still waits on the test user creation

Yeah, but there is no account in the wiki, so nobody can log in. I pinged @Reedy with request for an account creation, waiting :).

@Banyek One user finally exist on the wiki. Do you need anything more to be able to complete this?

@Urbanecm Nope, I checked it on the labsdb instances and it was sanitized properl;y.
@Bstorm you can create the views (if the fishbowl wikis have views)

Views and indexes created.

MariaDB [meta_p]> SELECT count(*) FROM meta_p.wiki WHERE dbname = 'punjabiwikimedia';
+----------+
| count(*) |
+----------+
|        1 |
+----------+

MariaDB [punjabiwikimedia_p]> select count(*) from user;
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.01 sec)