Removing Proxy configuration in SDDC fails with an error "The host was not reachable with specified port"

Products

• VMware Cloud Foundation 4.x
• VMware Cloud Foundation 5.x

Issue/Introduction

This article provides steps to remove Proxy configuration from SDDC in a situation wherein, the Proxy server and its associated ports has been discarded. When you make an attempt to remove you will encounter an error in UI as shown below:

You will read log entries similar to 

/var/log/vmware/vcf/operationsmanager/operationsmanager.log

DEBUG [vcf_om,dca35e09a4e0498a,6fc0] [c.v.e.s.common.util.NetworkService,http-nio-127.0.0.1-7300-exec-1] Cannot connect to port 8080
DEBUG [vcf_om,dca35e09a4e0498a,6fc0] [c.v.e.s.e.h.LocalizableRuntimeExceptionHandler,http-nio-127.0.0.1-7300-exec-1] Processing localizable exception The host was not reachable with specified port.
ERROR [vcf_om,dca35e09a4e0498a,6fc0] [c.v.e.s.e.h.LocalizableRuntimeExceptionHandler,http-nio-127.0.0.1-7300-exec-1] [UBDCLV] PROXY_HOST_NOT_REACHABLE The host was not reachable with specified port.
com.vmware.evo.sddc.common.core.error.InvalidInputException: The host was not reachable with specified port.

Environment

VMware Cloud Foundation

Cause

SDDC Proxy configuration cannot be removed or turned off from SDDC UI as its associated server and ports have been discarded prior to making changes in SDDC.

Resolution

Steps to remove proxy configuration from database:

Note: Please take backup of SDDC Virtual Machine. Do not skip this step.

• Login to SDDC SSH session via Putty client as VCF account
• Switch to root account with a command 'su'
• list the configuration by running command

psql -h localhost -U postgres -d platform -c "select id,proxy_enabled from proxy_config;"

• Identify the proxy id and make a note of the id.

platform# select id,proxy_enabled from proxy_config;
                  id                  | proxy_enabled
--------------------------------------+---------------
 {UNIQUE_ID}                          | t
(1 row)

• Delete the configuration by using id obtained above

psql -h localhost -U postgres -d platform -c "delete from proxy_config where id='<ID FROM PREVIOUS OUTPUT>';"