| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Dereckson | T183561 Create Wikipedia Lingua Franca Nova 2 | |||
| Resolved | • Bstorm | T183566 Prepare storage layer for lfnwiki |
Event Timeline
Thanks, then we don't need to do anything until the wiki is actually created. Once it is created, just ping us so we can sanitize it on labs.
Once filtered the cloud-services-team can create the views.
This needs to be filtered.
Assigning it to myself to indicate it is blocked on me before this can be handed over to cloud-services-team
Mentioned in SAL (#wikimedia-operations) [2018-04-19T11:21:30Z] <marostegui> Sanitize lfnwiki - T183566
This has been filtered. I see a new created user (myself) that has all the critical data redacted on labs hosts.
I am going to run a check private data to make completely sure before handing this over to cloud team for the views.
Mentioned in SAL (#wikimedia-operations) [2018-04-19T11:24:13Z] <marostegui> Run check_private_data on labsdb - T183566
Everything looks redacted on labs hosts, so all good!
This is now ready for cloud-services-team to create the views.
Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services
Something went wrong. DNS {wikicode}.analytics.db.svc.eqiad.wmflabs and {wikicode}.web.db.svc.eqiad.wmflabs are okay but wikis are not accessible. See the following output. Can you look at this?
urbanecm@tools-bastion-02 ~ $ mysql -h s3.analytics.db.svc.eqiad.wmflabs Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 22872379 Server version: 10.1.32-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use lfnwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'lfnwiki_p' MariaDB [(none)]> use gorwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'gorwiki_p' MariaDB [(none)]> use inhwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'inhwiki_p' MariaDB [(none)]> use romdwikimedia_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'romdwikimedia_p' MariaDB [(none)]> Bye
Just to make you sure, this isn't working on web replicas as well. See the following output.
urbanecm@tools-bastion-02 ~ $ mysql -h s3.web.db.svc.eqiad.wmflabs Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11379982 Server version: 10.1.32-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use lfnwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'lfnwiki_p' MariaDB [(none)]> use gorwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'gorwiki_p' MariaDB [(none)]> use inhwiki_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'inhwiki_p' MariaDB [(none)]> use romdwikimedia_p; ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'romdwikimedia_p' MariaDB [(none)]>
This is fixed:
marostegui@tools-bastion-03:~$ sql --cluster analytics gorwiki_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 23182056 Server version: 10.1.32-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [gorwiki_p]> use lfnwiki_p; use gorwiki_p; use inhwiki_p; use romdwikimedia_p; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [romdwikimedia_p]> MariaDB [romdwikimedia_p]> Ctrl-C -- exit! Aborted marostegui@tools-bastion-03:~$ sql --cluster web gorwiki_p Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 11472464 Server version: 10.1.32-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [gorwiki_p]> use lfnwiki_p; use gorwiki_p; use inhwiki_p; use romdwikimedia_p; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [romdwikimedia_p]>