Set up different PostgreSQL accounts for each Socorro component [tracker]

RESOLVED FIXED in 2.0

Status

Socorro
General
RESOLVED FIXED
7 years ago
6 years ago

People

(Reporter: laura, Assigned: mpressman)

Tracking

Dependency tree / graph

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

7 years ago
One per type of component.
(Reporter)

Updated

7 years ago
Assignee: nobody → josh
Target Milestone: 1.7.8 → 1.7.7
(Reporter)

Updated

7 years ago
Target Milestone: 1.7.7 → 1.7.8

Updated

7 years ago
Depends on: 635963
Being dealt with gradually.  For 1.7.8, moving just the processors.
(Reporter)

Updated

7 years ago
Summary: Set up different PostgreSQL accounts for each Socorro component → Set up different PostgreSQL accounts for each Socorro component [tracker]

Updated

7 years ago
Blocks: 659861
(Reporter)

Updated

7 years ago
Depends on: 660842
(Reporter)

Updated

7 years ago
Target Milestone: 1.7.8 → 2.0
(Reporter)

Updated

7 years ago
Assignee: josh → mpressman
(Reporter)

Comment 2

7 years ago
mpressman, status?
(Assignee)

Comment 3

7 years ago
Created additional roles for components that connect to database:
collector
reporter
bootstrap
(Reporter)

Comment 4

7 years ago
(In reply to comment #3)
> Created additional roles for components that connect to database:
> collector
> reporter
> bootstrap

Did you do this on dev/stage/prod?  What about corresponding config changes in puppet?
(Assignee)

Comment 5

7 years ago
This was done on dev/stage and prod. I wasn't aware that puppet managed any of these. So I'll get with jabba about getting them into puppet
Component: Socorro → General
Product: Webtools → Socorro
(Assignee)

Comment 6

6 years ago
This has been completed:
breakpad=# select * from pg_user;
     usename      | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil |                          useconfig                          
------------------+----------+-------------+----------+-----------+----------+----------+-------------------------------------------------------------
 analyst          |   110682 | f           | f        | f         | ******** |          | {statement_timeout=15min,work_mem=128MB,temp_buffers=128MB}
 bootstrap        |    16386 | f           | f        | f         | ******** |          | 
 breakpad_ro      |    16389 | f           | f        | f         | ******** |          | 
 collector        |    16391 | f           | f        | f         | ******** |          | 
 ganglia          |    16392 | f           | f        | f         | ******** |          | 
 nagiosdaemon     |    16395 | f           | f        | f         | ******** |          | 
 postgres         |       10 | t           | t        | t         | ******** |          | 
 replicator       |    16397 | f           | t        | t         | ******** |          | 
 reporter         |    16398 | f           | f        | f         | ******** |          | 
 breakpad_rw      |    16390 | f           | f        | f         | ******** |          | {log_min_duration_statement=0}
 monitor          |    16393 | f           | f        | f         | ******** |          | 
 breakpad_metrics |    16388 | f           | f        | f         | ******** |          | 
 processor        |    16396 | f           | f        | f         | ******** |          |
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.