Missing DB permissions in fix_translations_credits script
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Данило Шеган |
Bug Description
During QA of bug #459132, the script ran for a while before erroring out with:
Traceback (most recent call last):
...
File "/srv/staging.
lock_
File "/srv/staging.
force_
...
File "/srv/staging.
if (not self.is_
...
psycopg2.
Apparently, we are also missing karma SELECT, INSERT, karmaaction SELECT permissions, and potranslation INSERT (for the new automated translation message) permissions, apart from already identified SELECT on teamparticipation and SELECT on validpersoncache.
Related branches
- Francis J. Lacoste (community): Approve (release-critical)
- Muharem Hrnjadovic (community): Approve
-
Diff: 70 lines3 files modifieddatabase/schema/security.cfg (+4/-1)
lib/lp/translations/doc/fix_translation_credits.txt (+17/-0)
scripts/rosetta/fix_translation_credits.py (+2/-2)
summary: |
- Missing permission to access validpersoncache in - fix_translations_credits script + Missing DB permissions in fix_translations_credits script |
description: | updated |
Changed in rosetta: | |
status: | Triaged → In Progress |
Changed in rosetta: | |
importance: | High → Critical |
tags: | added: current-rollout-blocker |
Changed in rosetta: | |
status: | Fix Committed → Fix Released |
milestone: | none → 3.1.10 |
tags: |
added: qa-ok removed: qa-needstesting |
This bug was mentioned in db-devel r8643 <http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ db-devel/ revision/ 8643>