Closed Bug 869271 Opened 11 years ago Closed 11 years ago

setupdb_app.py does not create roles

Categories

(Socorro :: Infra, task)

Product:
Socorro
Component:
Infra
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: rhelmer, Assigned: selenamarie)

Details

(Whiteboard: [qa-]) 

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
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
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
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.