Skip to content

Instantly share code, notes, and snippets.

@zmb3
Forked from haydonryan/Update Ops Mgr UAA callback
Created August 21, 2017 21:36
Show Gist options
  • Save zmb3/c29d2eb837a30585e6a099aec0171a16 to your computer and use it in GitHub Desktop.
Save zmb3/c29d2eb837a30585e6a099aec0171a16 to your computer and use it in GitHub Desktop.
sudo su - tempest-web -s /bin/bash -c 'psql tempest_production'
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'uaa_configs';
SELECT id, hostname
FROM uaa_configs;
UPDATE uaa_configs
SET hostname = '<NEW_HOST_NAME>'
WHERE id = 1;
# bounce UAA (or opsman)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment