How to change vSphere update manager database password

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:
This article provides information on how to change update manager database password.

Environment

VMware vCenter Server Appliance 6.7.x
VMware vCenter Server Appliance 6.5.x

Resolution

The randomly generated password is of 16 characters.
To reset database (DB) password;

1. Identify the current password and record it for use in step 4. The current password can be retrieved by reviewing the following file.

# /usr/lib/vmware-updatemgr/bin/configvalues.txt.

For example: 

db_password=ueqy&CpO|r1@}w?m

2. Stop vSphere Update Manager service, running the command;

service-control --stop vmware-updatemgr

3. Define a new password in the same file, for example: '1234567890abcdef'
4. Run below command to change postgresql password for vumuser.
   • ​​First, run the command below to connect to DB, use password from step 1 (above).

/opt/vmware/vpostgres/current/bin/psql -U vumuser -d VCDB

• Then run the same command to change password for vumuser.

ALTER USER vumuser WITH PASSWORD '1234567890abcdef';

5. Modify the password with the new vumuser credentials in the following files:

• /usr/lib/vmware-updatemgr/bin/configvalues.txt
• /usr/lib/vmware-updatemgr/bin/vci-integrity.xml

6. Start vSphere Update Manager service.

service-control --start vmware-updatemgr

7. Verify that vSphere Update Manager is working via vSphere web client.