Closed Bug 1057019 Opened 10 years ago Closed 10 years ago

Fix API access after any DB refresh

Categories

(Marketplace Graveyard :: Code Quality, defect)

Product:
Marketplace Graveyard
Component:
Code Quality
Version:
Avenir
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED INVALID

People

(Reporter: kumar, Unassigned)

Details

When we refresh dev/stage with prod DB data we truncate tables and do some inserts: https://wiki.mozilla.org/User:Clouserw/AMODBrefresh

Because API secrets are encrypted (https://github.com/mozilla/zamboni/blob/master/mkt/api/models.py#L19), access does not work on the new server since we do not sync decryption keys from prod.

We should fix this somehow, maybe by resetting the secrets in a script?

Here are some random observations:
- The api_access table does not get truncated at all during the refresh. This seems wrong.
- The user that webpay connects with, 'mkt:5520425:amckay@mozilla.com:0', is actually not the one that gets inserted up above. Note the trailing :0.


The last time we ran into this, the exception we hit was this http://sentry.dmz.phx1.mozilla.com/marketplace-stage/marketplace-stage/group/19990/ and to fix it, I manually opened a python shell and reset the secret:

a = Access.objects.get(key='mkt:5520425:amckay@mozilla.com:0')
a.secret = 'secret from webpay/settings/sites/stage/private_base.py'
a.save()
We should do bug 1018318 instead.
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.