870286 - permission denied for relation product_info after setting up new database

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Helmer [:rhelmer]]

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

Comment 1

[Selena Deckelmann :selenamarie :selena]

(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?

Comment 2

[Robert Helmer [:rhelmer]]

(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.

Comment 3

[[github robot]]

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

Comment 4

[Robert Helmer [:rhelmer]]

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

Comment 5

[[github robot]]

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