837738 - Unable to connect to PostgreSQL user analyst on tp-socorro01-ro-zeus.phx1

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Robert Kaiser]

Since the Socorro DB failover last week, I'm seeing the same as bug 825227 yet again:

[[e-mail]1 ~]$ psql -h tp-socorro01-ro-zeus.phx1.mozilla.com -p 6432 -U analyst breakpad
psql: ERROR:  No such user: analyst

Comment 1

[Matt Pressman [:mpressman]]

Added back to pg_auth, was able to connect from crashanalysis.dmz.phx1

Comment 2

[Selena Deckelmann :selenamarie :selena]

(In reply to Matt Pressman [:mpressman] from comment #1)
> Added back to pg_auth, was able to connect from crashanalysis.dmz.phx1

Cool! Can we get that config added to Puppet?

Comment 3

[Matt Pressman [:mpressman]]

I will get this added to the current postgres2 module as well as into the new postgres module

Comment 4

[Robert Kaiser]

Yay, I can connect now and my scripts are running. I'm leaving the bug open for the puppet work, though. :)

Comment 5

[Matt Pressman [:mpressman]]

This has been added to the postgres module, it still needs to be back ported to the postgres2 module. The bug https://bugzilla.mozilla.org/show_bug.cgi?id=830882 is tracking that.

Comment 6

[Selena Deckelmann :selenamarie :selena]

(In reply to Matt Pressman [:mpressman] from comment #5)
> This has been added to the postgres module, it still needs to be back ported
> to the postgres2 module. The bug
> https://bugzilla.mozilla.org/show_bug.cgi?id=830882 is tracking that.

Hey Matt -- can you point me to the prod version of this file in SVN? I see one for stage, but the one for prod appears to only have the postgres user in it. 

Here's what I found in SVN at trunk/modules/postgres2/files/etc/pgbouncer:

selena@wuzetian:pgbouncer #640 13:53 ♥: svn log pg_auth.conf 
------------------------------------------------------------------------
r28853 | [e-mail] | 2012-02-15 15:19:18 -0800 (Wed, 15 Feb 2012) | 1 line

add pgbouncer
------------------------------------------------------------------------

Comment 7

[Matt Pressman [:mpressman]]

The postgres module handling of pgbouncer was backported into postgres2

The auth and config templates are at trunk/modules/postgres2/templates/etc/pgbouncer