About the update_vrealize_portgroup.py utility
In the VVD guidance documentation, one of the steps is to move the vRealize VMs from the original VREALIZE VLAN to a VXLAN created on the NSX vRealize-Edge. As part of this, there is a need to update the Cassandra database with the VXLAN portgroup created for the vRealize-Edge.
Installation
Prerequisites:
- Network connectivity between management VLANs in RegionA and RegionB.
- IP address of the SDDC Manager VM in RegionA.
- root password of the SDDC Manager VM in RegionA.
- vRealize Automation and vRealize Operations components should be deployed in RegionA only.
For VMware Cloud Foundation 3.0.x / 3.5.x
- Download the attached 59203_update_vrealize_portgroup.zip file.
- Use a file transfer utility to copy the 59203_update_vrealize_portgroup.zip file to the /tmp directory on the RegionA SDDC Manager Controller VM.
- SSH to the SDDC Manager Controller VM in RegionA as the vcf user. Issue the su - commands to switch to the root user.
- Issue the following commands to extract the script:
unzip -d /tmp/ /tmp/59203_update_vrealize_portgroup.zip
Update vRealize portgroup
In the VVD guidance documentation, one of the steps is to move the vRealize VMs from the original VREALIZE VLAN to a VXLAN created on the NSX vRealize-Edge. The VXLAN portgroup created for the vRealize-Edge must be updated in the Cassandra database. Issue a command similar to the following on the SDDC Manager VM in RegionA to update the portgroup in Cassandra:
python /tmp/update_vrealize_portgroup.py --portgroup vxw-dvs-9-universalwire-2-sid-12002-Mgmt-xRegion01-VXLAN
Note: Replace the portgroup name in the previous command, vxw-dvs-9-universalwire-2-sid-12002-Mgmt-xRegion01-VXLAN, with the name that was created in the vSphere Web Client.
For VMware Cloud Foundation 3.7.x
In 3.7.x, the tables in the Cassandra database have been moved to the Postgres database. With this change the process has been simplified to a single SQL statement.
- Open an SSH session to the SDDC Manager VM in RegionA and change to the root user
su -
- Run the below query:
psql --host=localhost -U postgres -c '\c platform;' -c "update network set port_group_key_name = '<your-new-port-group-name>';" -c 'select * from network' -x