Unable to Delete MyVMware Credential from Locker After VMware to Broadcom Migration and Upgrade, Still Referenced in MyVMware

Products

• VMware Aria Suite
• VMware vRealize Suite Lifecycle Manager 8.x

Issue/Introduction

Following the transition to Broadcom Aria Lifecycle, our ability to retrieve installers, patches, and updates via My VMware has been discontinued. Consequently, we now manually update the Aria Suites through LCM. In an effort to streamline operations, we aimed to remove outdated My VMware credentials from our locker. Despite the removal of the corresponding feature from settings, these credentials persist within the locker and appear as in use by My VMware under settings, which are no longer accessible. This article provides guidance on how to permanently remove these credentials from the locker to ensure they are no longer associated or in use.

 

Environment

Aria Suite Lifecycle Manager 8.x

Resolution

Workaround:

Prerequisites

• You have backups / Snapshots of the Aria Suite Lifecycle Manager 8.x appliance(s).

Procedure

1. SSH into the Aria Suite Lifecycle Manager appliance node.

2. Run the following commands to connect to the Postgres database.

su - postgres
cd /opt/vmware/vpostgres/11/bin
./psql -d vrlcm

Note: These commands connect you to the Aria Suite Lifecycle Manager Database.

3. Run the below command to list all the database tables.

\dt

4. Locate the "vm_locker_password" from the list of database tables.

5. Run the below command to retrieve the data from the "vm_locker_password" table and locate the MyVMware credential Alias from the list.

select * from vm_locker_password;

 

6. Run the below command to confirm the correct credential gets displayed.

select * from vm_locker_password where alias='<alias-of-MyVMware password>';

7. Run the below command to delete the "MyVMware" credential from the database.

delete from vm_locker_password where alias='<alias-of-MyVMware password>';

8. Run the below command to disconnect from postgres.

\q

9. Login to the Aria Suite Lifecycle Manager user interface and reload the Locker >> Password page and validate if the MyVMware credential got deleted.