875054 - Add alembic config to postgres user account

Status: RESOLVED FIXED

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

Description

[Selena Deckelmann :selenamarie :selena]

Attachment: Alembic config for socorro

Add a '.alembic_config' file to the postgres user account.

Comment 1

[Sheeri Cabral [:sheeri]]

OK, this file has lots of socorro-specific stuff (users, directories, etc) so it should go on socorro servers only. 

There are no passwords, so it can go directly into puppet, no need for hiera.

The socorro package has a socorro::db class that is unused, so I am adding in the alembic config to it:

Sheeri-Cabral:socorro scabral$ svn diff | grep Index
Index: files/alembic_config
Index: manifests/db.pp
Sheeri-Cabral:socorro scabral$ svn commit -m "adding alembic_config to socorro db class"
Adding         files/alembic_config
Sending        manifests/db.pp
Transmitting file data ..
Committed revision 74597.

Comment 2

[Sheeri Cabral [:sheeri]]

Putting this into socorro.pp for tp-socorro01-master01 since it's out of the load balancer right now:

    class {
        # sudoers::users is now part of socorro::db
        'socorro::db':;
    }

Comment 3

[Sheeri Cabral [:sheeri]]

Notice: /Stage[main]/Socorro::Db/File[/var/lib/pgsql/.alembic_config]/ensure: defined content as '{md5}3343da7ef397df99f736396aec72f958'

w00t!

OK, I'm going to put this on all the socorro db servers:

tp-socorro-master01 (already done)
tp-socorro-master02
socorro3
socorro-reporting
socorro-bixie-stage
socorro-stage
socorro-dev

And I ran puppet manually on all of them, the only change was the .alembic_config file and removing pgexperts from sudoers, which I did while I was in the file anyway.

Resolving, please check that everything's what you need and either verify or reopen.