Closed Bug 837738 Opened 11 years ago Closed 11 years ago

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

Categories

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

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: kairo, Assigned: mpressman)

References

Details

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

[rkaiser@crashanalysis.dmz.phx1 ~]$ psql -h tp-socorro01-ro-zeus.phx1.mozilla.com -p 6432 -U analyst breakpad
psql: ERROR:  No such user: analyst
Assignee: server-ops-database → mpressman
Added back to pg_auth, was able to connect from crashanalysis.dmz.phx1
(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?
I will get this added to the current postgres2 module as well as into the new postgres module
Yay, I can connect now and my scripts are running. I'm leaving the bug open for the puppet work, though. :)
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.
(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 | jthomas@mozilla.com | 2012-02-15 15:19:18 -0800 (Wed, 15 Feb 2012) | 1 line

add pgbouncer
------------------------------------------------------------------------
The postgres module handling of pgbouncer was backported into postgres2

The auth and config templates are at trunk/modules/postgres2/templates/etc/pgbouncer
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.