If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

setupdb_app.py does not create roles

RESOLVED FIXED in 53

Status

Socorro
Infra
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: rhelmer, Assigned: selenamarie)

Tracking

unspecified

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [qa-])

(Reporter)

Description

4 years ago
This is easiest to reproduce with a fresh db, e.g. backup $PGDATA and do initdb then:

./socorro/external/postgresql/setupdb_app.py --database_name=breakpad

Expected:

breakpad DB plus roles for breakpad_rw, breakpad_ro, etc. are listed

Actual:

sqlalchemy.exc.ProgrammingError: (ProgrammingError) role "breakpad_rw" does not exist
(Reporter)

Comment 1

4 years ago
Doing "psql -f sql/roles.sql" does work, I think we should just have setupdb_app.py do this though (and perhaps the SQL in there should live elsewhere too)
Assignee: nobody → sdeckelmann
Target Milestone: --- → 53

Comment 2

4 years ago
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/f0104abad2da3ecc889bfd36529dbee5ded4384a
Fixes bug 869271 Adds role creation to setupdb_app.py

* Add default_password config option
* Add function create_roles()

https://github.com/mozilla/socorro/commit/28a22fffabf9190770fe1888ebf60bed2abc7523
Merge pull request #1310 from selenamarie/bug869271-add-roles-to-setupdb

Fixes bug 869271 Add role creation to setupdb_app.py

Updated

4 years ago
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.