The new wiki is going to be a fishbowl wiki.
|Resolved||CCicalese_WMF||T203296 Deploy fixcopyright.wikimedia.org|
|Resolved||Reedy||T202819 Create production wiki: fixcopyright.wikimedia.org|
|Resolved||Bstorm||T202820 Prepare and check storage layer for fixcopyright.wikimedia.org|
This is technically done, but I would like some users being filtered before handling it to cloud (there is no rows at the moment). Once it has some rows (and check that the filters work- only then) we will handle it to cloud team so the views can be created. CC @Bstorm
Stalled until that happens.
There is one row now there (I just checked the user table) and it is filtered correctly.
I would, however, as Jaime said, wait a bit more until we have a few more rows to make sure they are definitely being sanitized correctly. I tried to create an user but as it is a fishbowl, I could not do so.
I talked to Jaime about that existing user, and when he first sanitized it, the user wasn't there, so it means it was created after the triggers got in place and they worked fine, because the user is sanitized, that means that this is ready for cloud-services-team to create the views.
In order to bypass the access denied typical error due to the mariadb bug, I have created the database (_p) and granted the labsdb user access to that db.
for i in labsdb1009 labsdb1010 labsdb1011; do echo $i; mysql.py -BN -h$i -e "show databases like 'fixcopyrightwiki_p'" ; done labsdb1009 fixcopyrightwiki_p labsdb1010 fixcopyrightwiki_p labsdb1011 fixcopyrightwiki_p
On all labsdb hosts:
GRANT SELECT, SHOW VIEW ON `fixcopyrightwiki\_p`.* TO 'labsdbuser'
@Bstorm you are good to go! Thanks!
@Marostegui, on all three replicas, I just got:
pymysql.err.InternalError: (1290, 'The MariaDB server is running with the --read-only option so it cannot execute this statement')
For creating indexes by script. User is maintainindexes
Apparently it doesn't have the super option on these servers?
Yeah, not sure what happened, it is supposed to have it: https://github.com/wikimedia/puppet/blob/production/modules/role/templates/mariadb/grants/wiki-replicas.sql#L33
I have granted it, please try again :-)
Noted for my reference:
requests.exceptions.ConnectionError: HTTPConnectionPool(host='cloudservices1003.wikimedia.org', port=9001): Max retries exceeded with url: /v2/zones?name=analytics.db.svc.eqiad.wmflabs. (Caused by NewConnectionError('<requests.packages.urllib3.connection.HTTPConnection object at 0x7f43d5e359d0>: Failed to establish a new connection: [Errno 110] Connection timed out',))
I've never seen that before from the DNS script. I think I might need to fix something there. We haven't tried it since the change to cloudservices1003.