Troubleshooting vRA VA vcac-config hostname-change command

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:
After vRA 7.4 'changehostname.sh' script is deprecated and replaced by `vcac-config hostname-change' command, with vRA 7.4 and up a VA hostname should be changed only using `vcac-config hostname-change` command.

Environment

VMware vRealize Automation 7.4.x

Resolution

1. On the node where hostname is changed verify:

- 'hostname' command returns $NEW_HOSTNAME
- The following files (if exist) are modified and the $OLD_HOSTNAME is replaced with $NEW_HOSTNAME
 * /etc/HOSTNAME
 * /etc/mailname
 * /etc/sysconfig/network
 * /usr/local/horizon/conf/flags/sysconfig.hostname
 * /etc/vcac/security.properties

2. The following select statements should not return any records from the database:

 echo "Select * from \"cluster_nodes\" where \"cluster_nodes\".\"node_host\" LIKE '%$OLD_HOSTNAME%';" | su - postgres /opt/vmware/vpostgres/current/bin/psql vcac
 echo "Select * from \"saas\".\"OAuth2Client\" where \"OAuth2Client\".\"redirectUri\" LIKE '%$OLD_HOSTNAME %';" | su - postgres /opt/vmware/vpostgres/current/bin/psql vcac
 echo "Select * from \"saas\".\"Connector\" where \"Connector\".\"host\" LIKE '%$OLD_HOSTNAME%';" | su - postgres /opt/vmware/vpostgres/current/bin/psql vcac
 echo "Select * from \"saas\".\"FederationArtifacts\" where \"FederationArtifacts\".\"strData\" LIKE '%$OLD_HOSTNAME%';" | su - postgres /opt/vmware/vpostgres/current/bin/psql vcac
 echo "Select * from \"saas\".\"ServiceInstance\" where \"ServiceInstance\".\"hostName\" LIKE '%$OLD_HOSTNAME%';" | su - postgres /opt/vmware/vpostgres/current/bin/psql vcac

3. On all nodes the following files should be modified:

 * /etc/hosts
 * /usr/local/horizon/conf/runtime-config.properties
 * all config-state.json files in /usr/local/horizon/conf folder (May be listed with the following command: 'find /usr/local/horizon/conf -name config-state.json' )
  * all files in /etc/haproxy/conf.d folder

4. Actions to perform on primary node:

 * execute /usr/local/horizon/scripts/secure/wizardssl.hzn
 * rabbitmq cluster reset

5. If any changes are to be made , or scripts to be executed, user should stop horizon-workspace and vcac-server.

 service horizon-workspace stop
 service vcac-server stop

6. At the end horizon-workspace and vcac-server services should be started.

 service horizon-workspace start
 service vcac-server start