1182163 - Set DATABASE_URL and DATABASE_URL_RO in puppet on stage/prod

Status: RESOLVED FIXED

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

Description

[Ed Morley [:emorley]]

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:[e-mail]/treeherder_stage"
DATABASE_URL_RO="mysql://th_user:[e-mail]/treeherder_stage"

(Substituting in the current values for TREEHERDER_DATABASE_PASSWORD and TREEHERDER_RO_DATABASE_PASSWORD)

And for prod:

DATABASE_URL="mysql://th_admin:[e-mail]/treeherder"
DATABASE_URL_RO="mysql://th_user:[e-mail]/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 :-)

Comment 1

[Kendall Libby [:fubar] (he/him)]

Added to puppet and in place on the admin node. Other's will pick it up over the next hour.

Comment 2

[Ed Morley [:emorley]]

Thank you :-)