1434393 - Give Sarah access to the prod read-only replica

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, enhancement, P1)

Description

[Ed Morley [:emorley]]

To help test the frontend + new API endpoints against prod failure classification data.

I'll create an account using:
https://treeherder.readthedocs.io/admin.html#direct-database-access

Comment 1

[Ed Morley [:emorley]]

I've created an account with read-only permissions and I'll send the credentials to you separately.

To use them export the updated DATABASE_URL inside Vagrant using something like:
`export DATABASE_URL='mysql://USER:[e-mail]/treeherder'`

...then to reset back to the local DB either log out/in of vagrant, or else run `source vagrant/env.sh`.

Note: The user GRANTS don't give read access to all of the auth_user table, so queries against that might fail unless limited to just the "username", "email" and "id" fields (Django loads all fields by default). However unless the new UI has a "who classified this" column on the details view, I guess this shouldn't affect you)

Comment 2

[Ed Morley [:emorley]]

I've just added the extra permissions mentioned in the meeting, using:

GRANT SELECT ON treeherder.auth_user to 'sclements';