openboxes / openboxes-devops

Infrastracture as Code artifacts for OpenBoxes.
3 stars 1 forks source link

OBPIH-5618 Handle split hosts and finance user in {reset,restore}_db.yml #47

Closed mdpearson closed 1 year ago

mdpearson commented 1 year ago

Hi folks, this PR updates reset_db.yml and restore_db.yml so that they work as expected on split hosts like dbstg/obstg. Targets for these runbooks should be stg or prd because in both cases, when the DB is replaced, Tomcat needs to be restarted to kick off the liquibase migrations.

These scripts poll the affected services after kicking them and report if they don't come back up cleanly.

mdpearson commented 1 year ago

Oh, and after clobbering or updating the database the runbook now makes sure the finance user, etc. has access to it