798152 - [socorro-crashstats] hook django app to postgres

Status: RESOLVED FIXED

(Socorro :: Webapp, task)

Description

[Robert Helmer [:rhelmer]]

We need this for sessions support for auth - right now the dev server uses sqlite which won't really cut it if we have more than one webserver.

Comment 1

[Robert Helmer [:rhelmer]]

Peter - are you already working on this? If so feel free to take it.

Comment 2

[Peter Bengtsson [:peterbe]]

No I'm not. I've tried running socorro-crashstats locally with psycopg2 and it worked perfectly fine. Locally I appear to have '2.4.5 (dt dec pq3 ext)' installed. 

We need to find out what psycopg2 we have installed on the web head.

Comment 3

[Robert Helmer [:rhelmer]]

(In reply to Peter Bengtsson [:peterbe] from comment #2)
> No I'm not. I've tried running socorro-crashstats locally with psycopg2 and
> it worked perfectly fine. Locally I appear to have '2.4.5 (dt dec pq3 ext)'
> installed. 
> 
> We need to find out what psycopg2 we have installed on the web head.

The reason I blocked this on bug 789969 is that we don't have it installed system-wide.

Comment 4

[Robert Helmer [:rhelmer]]

Now that bug 789969 is closed, I pushed some commits to get this working:

https://github.com/mozilla/socorro-crashstats/commit/7a1bdb4f67f238bd9bddc996f40334434b479e19
https://github.com/mozilla/socorro-crashstats/commit/cbae605d7c715a157618bd6aa14c31a9fbf50c48
https://github.com/mozilla/socorro-crashstats/commit/fefb6fbe29206e0994779a5e85737ffb997367de

Everything is up and running now, but we're waiting to get pg_hba.conf adjusted on devdb (bug 799782) before we can close this out (peterbe and I have both tested this locally against postgres so we expect it to work!)

Comment 5

[Robert Helmer [:rhelmer]]

One more - require bcrypt since the underlying auth implementation wants it (long story, will be resolved upstream):

https://github.com/mozilla/socorro-crashstats/commit/ecfd5b0c574d87893ad1afe15fba7127634f7077

Looks like everything is working on dev, I can do a "./manage.py syncdb --noinput" etc.

Comment 6

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro-crashstats

https://github.com/mozilla/socorro-crashstats/commit/b6576b15a7f5180c9e46b1fe6c1d47c0b05dc0bc
changes required for prettier 500 error page fixes bug 798152

https://github.com/mozilla/socorro-crashstats/commit/6d5eafc4d9fa4cb498f723bfb6b130ae4e8b96be
Merge pull request #139 from ossreleasefeed/create-error-500-template-799522-version2

changes required for prettier 500 error page fixes bug 798152