Update network IP pool range, gateway, release used IP in SDDC Manager
Article ID: 420695
Updated On:
Products
Issue/Introduction
You cannot remove an existing IP address range from the SDDC UI if it is the only range within the network pool or if it is currently in use.
Editing the information that includes Network, VLAN ID, MTU, Subnet Mask and Default Gateway is not supported via GUI.
This article provides guidance on changing the IP range, gateway, release used IP using the public API and DB interaction.
Environment
SDDC 5.x
Cause
Wrong initial configuration
Resolution
Note: Please follow the below steps with caution. Ensure to take a snapshot of the SDDC Manager Virtual Machine before proceeding.
su to switch to the root user and enter the password.TOKEN=`curl -X POST -H "Content-Type: application/json" -d '{"username": "[email protected]","password": "PASSWORD"}' --insecure https://localhost/v1/tokens | awk -F "\"" '{ print $4}'`
*Replace PASSWORD with a proper one
4. Now that you have the token, let’s use the API to list all the Network Pools.
curl -X GET -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -k https://localhost/v1/network-pools | json_pp
Sample output :
{
"id" : "######-####-####-####-############", <<<---Network Pool ID
"name" : "###########-network-pool", <<<---Network Pool name
"networks" : [
{
"id" : "########-####-####-####-#############" <<<--- Network A ID
},
{
"id" : "########-####-####-####-############" <<<---Network B ID
}
]
},
Network Pool may have several Networks. So the list might be bigger.
5. Use the following command to obtain more details about the networks
curl -X GET -H "Content-Type: application/json" -H "Authorization: Bearer $TOKEN" -k https://localhost/v1/network-pools/NETWORK_POOL_ID_FROM_PREVIOUS_STEP/networks | json_pp
Sample output part :
],
"gateway" : "xxx.xx.xx.xxx",
"id" : "########-####-####-####-#############", <<<--- Network A ID
"ipPools" : [
{
"end" : "xxx.xxx.xx.xxx",
"start" : "xxx.xxx.xx.x"
}
],
"mask" : "xxx.xxx.xxx.x",
"mtu" : 9000,
"subnet" : "xxx.xxx.xx.x",
"type" : "VMOTION",
6. Connect to SDDC Manager DB
psql -h localhost -U postgres -d platform
7. Use the following command to release IP from used IP addresses. Provide the full list of used IP addresses except those which need to be released.
update vcf_network SET used_ip_addresses='["xxx.xxx.xx.x","xxx.xxx.xx.x","xxx.xxx.xx.xx"]' where id='NETWORK_A_ID';
8. Use the following command to update gateway on particular network
update vcf_network SET gateway='xxx.xxx.xx.x' where id='NETWORK_A_ID';
9. Use the following command to update Network IP range
update vcf_network SET ip_inclusion_ranges='[{"start":"xxx.xxx.xx.x","end":"xxx.xxx.xx.xxx"}]' where id='NETWORK_A_ID';
10. Exit the database:\q
11. Check if the changes reflect on the SDDC UI.
Additional Information
https://knowledge.broadcom.com/external/article?articleId=402201
https://techdocs.broadcom.com/us/en/vmware-cis/vcf/vcf-5-2-and-earlier/5-2/map-for-administering-vcf-5-2/host-management-admin/about-network-pools-admin/add-or-remove-a-network-pool-ip-address-range-admin.html
Feedback
