The new wiki's visibility will be: Public.
@Marostegui and @Ladsgroup - Would you mind helping with this please, or pointing me to some more information?
I'm not sure whether I have missed a step somewhere, or whether a database or specific grant hasn't been created.
Our team has been asked to set up the views for this database, which was previously carried out by the WMCS team, but is now the responsibility of the Data Engineering team.
I'm following the procedure outlined here: https://wikitech.wikimedia.org/wiki/Portal:Data_Services/Admin/Wiki_Replicas#Step_6:_setting_views
When I run the following command...
btullis@cumin1001:~$ sudo cookbook sre.wikireplicas.add-wiki --task-id T319190 bnwikiquote
The maintain-views script exits with an error:
1044, "Access denied for user 'maintainviews'@'localhost' to database 'bnwikiquote\\_p'"
I'm also checking this page: https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services
I've checked the same command with another pending wiki replica database: T317111: Prepare and check storage layer for tlwikiquote and the result is broadly the same, so it seems that we're missing a step somewhere.
@Ladsgroup comments above that:
DBA side is done
...but what does that actually mean in this case? What steps were carried out? Do you use a cookbook, or is there a puppet change? Is it a manual command that is run for each new database?
I'm happy to try to update the documentation, but I don't want to confuse things if this is work that should be done by your team.
Thank and sincere apologies if I'm missing something obvious.
There's indeed a step being missed there which is usually ran by DBAs:
set session sql_log_bin=0;create database bnwikiquote_p;GRANT SELECT, SHOW VIEW ON `bnwikiquote_p`.* TO `labsdbuser`;
That needs to be executed on all clouddb* hosts.
I just ran:
sudo cookbook sre.wikireplicas.add-wiki --task-id T319190 bnwikiquote
And it looks like it worked fine.
Added views for new wiki: bnwikiquote T319190 END (PASS) - Cookbook sre.wikireplicas.add-wiki (exit_code=0)
Is there anything else that needs to be run from your side @BTullis or that command was all?
Thanks @Marostegui - No, as far as I am aware, running that cookbook is the only thing that I need to do for these simple wiki additions.
There is one other step for the Data Engineering team as part of each new wiki's post-creation work, which is to add it to the pageviews allowlist, but that was done for this wiki in T319191