Closed Bug 870286 Opened 9 years ago Closed 9 years ago

permission denied for relation product_info after setting up new database

Categories

(Socorro :: Database, task)

task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: rhelmer, Assigned: selenamarie)

Details

(Whiteboard: [qa-])

I have been getting this a lot from psycopg2 in the socorro apps the first time after a new database is created with setupdb_app.py:

ProgrammingError: permission denied for relation product_info
(In reply to Robert Helmer [:rhelmer] from comment #0)
> I have been getting this a lot from psycopg2 in the socorro apps the first
> time after a new database is created with setupdb_app.py:
> 
> ProgrammingError: permission denied for relation product_info

The user accessing the database for purposes of setupdb_app.py needs to be a superuser.

Is the socorro app using a different user than setupdb_app?
(In reply to Selena Deckelmann :selenamarie :selena from comment #1)
> (In reply to Robert Helmer [:rhelmer] from comment #0)
> > I have been getting this a lot from psycopg2 in the socorro apps the first
> > time after a new database is created with setupdb_app.py:
> > 
> > ProgrammingError: permission denied for relation product_info
> 
> The user accessing the database for purposes of setupdb_app.py needs to be a
> superuser.
> 
> Is the socorro app using a different user than setupdb_app?

Oh sorry this isn't very clear - setupdb_app.py runs fine (using a postgres superuser account), it's accessing the database as breakpad_rw from socorro apps (which is not a superuser, and shouldn't be) that yields this error.
Summary: permission denied for relation product_info when setting up new databases → permission denied for relation product_info after setting up new database
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/71b643bf9d13eed6248fdf039ad185f41cbb18d9
bug 870286 - clean up role creation

* Separate ALTER TABLE ... OWNER TO for each relation type
* Fix many tests
* Separate super user role from normal user roles
* Add a superuser to sql/roles.sql
* Add deprecation notices for old postgres related tests
* Add --no_schema back to setupdb_app.py
* PEP8-ify setupdb_app.py
* Clean up per feedback from @peterbe and @jezdez

https://github.com/mozilla/socorro/commit/21917bcff36862696c3a4718709339da4f2fb7c0
Merge pull request #1244 from selenamarie/bug870286-setupdb-permissions

bug 870286 - clean up role creation
Status: NEW → RESOLVED
Closed: 9 years ago
Resolution: --- → FIXED
Target Milestone: --- → 48
Whiteboard: [qa-]
Currently breaking socorro-vagrant build:
https://ci.mozilla.org/job/socorro-vagrant/47/console
(OperationalError) FATAL:  Peer authentication failed for user "test"

PR: https://github.com/mozilla/socorro/pull/1256
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/9a55ae2f896ff668c1872c7c8950648ff1a7276d
fixes bug 870286 - superuser must now be specified by puppet per docs

https://github.com/mozilla/socorro/commit/45b514c1d7085e66d1e6f4a05fc70450894982d5
Merge pull request #1256 from rhelmer/bug870286-specify-superuser-puppet

fixes bug 870286 - superuser must now be specified by puppet per docs
Status: REOPENED → RESOLVED
Closed: 9 years ago9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.