Skip to content

Instantly share code, notes, and snippets.

@dwallraff
Last active September 14, 2016 16:52
Show Gist options
  • Save dwallraff/a3aa8d19bf9734408f6786246a2f3e49 to your computer and use it in GitHub Desktop.
Save dwallraff/a3aa8d19bf9734408f6786246a2f3e49 to your computer and use it in GitHub Desktop.
Update the uaa name in OpsMan if the hostname changes (Thanks @virtmerlin)
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