We had a password change that took stage offline for several days. We weren't sure what happened. Let's get: -rw-r--r-- 1 root root 517 Jan 14 09:32 pg_auth_web.conf -rw-r--r-- 1 root root 517 Jan 14 09:32 pg_auth_processor.conf Under revision control on all Socorro systems.
Also, could do something like put this in a crontab: https://github.com/markokr/pgbouncer-dev/blob/master/etc/mkauth.py The passwords don't appear to be the same as the output from 'md5sum', so pulling a shadowed password out of PostgreSQL would be the easiest path forward.
5 years ago
The configs have been added to the new postgres module. I will backport into the postgres2 module for use until switching over to the new postgres module.
Assignee: server-ops-database → mpressman
5 years ago
adding pg_bouncer_allowed_rules deceleration from postgres module to postgres2 module
added pgbouncer_allowed_rules to stage and prod nodes/socorro.pp for hosts: tp-socorro01-master01.phx1 tp-socorro01-master02.phx1 socorro1.stage.db.phx1 Committed revision 74717.
backported pgbouncer.pp and pgbouncer/server.pp from postgres to postgres2 Committed revision 74722.
added postgres2::pgbouncer class to tp-socorro01-master01 Committed revision 74725.
socorro1.db.phx1.mozilla.com has pgbouncer auth configs and pgbouncer.ini under puppet control socorro3.db.phx1.mozilla.com has pgbouncer auth configs and pgbouncer.ini under puppet control socorro-reporting1.db.phx1.mozilla.com has pgbouncer auth configs and pgbouncer.ini under puppet control The module has been back ported and just needs to be applied to tp-socorro01-master02.phx1.mozilla.com and socorro1.stage.db.phx1.mozilla.com
added socorro1.stage.db.phx1 (stage) to pgbouncer puppet control
socorro1.stage.db.phx1 in Committed revision 75229
tp-socorro01-master02.phx1 added in Committed revision 75232
This is now complete
Status: NEW → RESOLVED
Last Resolved: 5 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.