Page MenuHomePhabricator
Create Task
Maniphest T149186

Check wikitech has the right db grants
Closed, ResolvedPublic
Actions

Description

This was changed recently:

https://gerrit.wikimedia.org/r/#/c/318077/1/templates/mariadb/grants-wikitech.sql.erb

But maybe (probably) there are other outadated grants on the server- review it.

Details

SubjectRepoBranchLines +/-
labswiki: Add wikitech access from mira to mirror tin privilegesoperations/puppetproduction+7 -1
Customize query in gerrit

Event Timeline

jcrespo created this task.Oct 26 2016, 12:12 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 26 2016, 12:12 PM
jcrespo claimed this task.Oct 26 2016, 1:51 PM
jcrespo moved this task from Triage to In progress on the DBA board.
Krenair subscribed.Oct 26 2016, 4:59 PM

Even if the grant has been updated, looks like there's some firewall issues.

jcrespo added a comment.Oct 26 2016, 5:02 PM

The grants have not been updated yet (probably).

gerritbot subscribed.Nov 3 2016, 11:29 AM

Change 319546 had a related patch set uploaded (by Jcrespo):
labswiki: Add wikitech access from mira to mirror tin privileges

https://gerrit.wikimedia.org/r/319546

gerritbot added a project: Patch-For-Review.Nov 3 2016, 11:29 AM

Change 319546 merged by Jcrespo:
labswiki: Add wikitech access from mira to mirror tin privileges

https://gerrit.wikimedia.org/r/319546

jcrespo closed this task as Resolved.Nov 3 2016, 11:35 AM

Certainly, the grants were wrong, I have applied the latest changes, here it is the current status:

https://gerrit.wikimedia.org/r/#/c/319546/1/templates/mariadb/grants-wikitech.sql.erb

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL