This is going to be a fishbowl wiki.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Dereckson | T187184 WMF-hosted wiki request for Ro-Md Wikimedians user group | |||
| Resolved | • Bstorm | T187774 Prepare and check storage layer for romdwikimedia |
Event Timeline
Comment Actions
Just because I do not know if that change something I'm adding it using comment as well: this is going to be a fishbowl wiki.
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2018-04-20T08:39:48Z] <marostegui> Going to sanitize gorwiki euwikisource romdwikimedia inhwiki on db1095 - T189112 T189466 T187774 T184375
Comment Actions
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
Comment Actions
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)]>
Comment Actions
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]>