Closed Bug 1182163 Opened 6 years ago Closed 6 years ago

Set DATABASE_URL and DATABASE_URL_RO in puppet on stage/prod

Categories

(Tree Management :: Treeherder: Infrastructure, defect, P2)

defect

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: emorley, Assigned: fubar)

References

Details

For bug 1175432 we're wanting to replace the separate TREEHERDER_DATABASE_{HOST,PORT,USERNAME,PASSWORD,NAME} variables with a single 12-factor app style DATABASE_URL.

As such, please could you add the following environment variables for stage:

DATABASE_URL="mysql://th_admin:TREEHERDER_DATABASE_PASSWORD@treeherder-stage-rw-vip.db.scl3.mozilla.com/treeherder_stage"
DATABASE_URL_RO="mysql://th_user:TREEHERDER_RO_DATABASE_PASSWORD@treeherder-stage-ro-vip.db.scl3.mozilla.com/treeherder_stage"

(Substituting in the current values for TREEHERDER_DATABASE_PASSWORD and TREEHERDER_RO_DATABASE_PASSWORD)

And for prod:

DATABASE_URL="mysql://th_admin:TREEHERDER_DATABASE_PASSWORD@treeherder-rw-vip.metrics.scl3.mozilla.com/treeherder"
DATABASE_URL_RO="mysql://th_user:TREEHERDER_RO_DATABASE_PASSWORD@treeherder-ro-vip.metrics.scl3.mozilla.com/treeherder"

(Also substituting the passwords)


At some point after bug 1175432 lands, I'll file another bug to remove the old variables from puppet.

Thanks :-)
Flags: needinfo?(klibby)
Added to puppet and in place on the admin node. Other's will pick it up over the next hour.
Assignee: nobody → klibby
Status: NEW → RESOLVED
Closed: 6 years ago
Flags: needinfo?(klibby)
Resolution: --- → FIXED
Thank you :-)
You need to log in before you can comment on or make changes to this bug.