Unable to modify the IP range from the network pools in the SDDC manager appliance

Products

• VMware vCenter Server

Issue/Introduction

• The functionality exists for users to provision new IP ranges within any network pool managed by SDDC Manager.
• However, SDDC Manager UI does not currently permit the editing of an existing IP range.

Environment

VMware Cloud Foundation 5.x 

VMware Cloud Foundation 9.x

Resolution

Ensure a snapshot of the VCF SDDC Manager appliance virtual machine is created before making any changes to the platform DB. This step is crucial to establish a rollback point for system restoration.

1. SSH to the SDDC manager, login as vcf user and then switch to root user using su command.
   
   
2. Access the platform database: 
   
   psql --host=localhost -U postgres -d platform
   
   
3. Identify the IDs for vSAN and VMOTION stack from the vcf_network table
   
   select * from vcf_network where type='VSAN';
select * from vcf_network where type='VMOTION';
      
4. Update the IP range with the following command:
   
    update vcf_network set ip_inclusion_ranges='[{"start":"IP_RANGE_START","end":"IP_RANGE_END"}]' where id='ID_from_Step_3'; 
   
   
5. Set the new free and used IP addresses that fit the new IP range manually.
   
   update vcf_network set free_ip_addresses='["IP_1","IP_2","IP_3","IP_4","IP_5"]' where id='ID_from_Step_3';
update vcf_network set used_ip_addresses='["IP_1","IP_2","IP_3","IP_4","IP_5"]' where id='ID_from_Step_3';
      
6. Validate the changes
   
   select * from vcf_network where id='ID_from_Step_3';

Additional Information

Related Articles:
How to remove Network I.P Pool Range in SDDC Manager