How to change a lost password for Pivotal Control Centre for PHD 2.1

Products

• Services Suite

Environment

Cause

You might have lost your gpadmin password for Pivotal Command Center.

Resolution

Follow the steps to resolve this issue:

1. ps -eaf | grep postmaster <---- we do this to get the port number to be used in part 2 below.
2. psql -p 10432 -d commander <---- connect to DB commander through port got from past 1 above
3. update users set password_digest='$2a$10$yhji/s6hiGe6AOrBwLzQ0OnSMB83yRd4zxa2i9dC1AkGqEejaUvqa' where username='gpadmin'; <----- use the update users set password_digest command to set the password back to default

Example 

1.

pivhdsne:~]$ ps -eaf | grep postmaster
postgres 2117 1 0 12:16 ? 00:00:01 /usr/bin/postmaster -p 10432 -D /var/lib/pgsql/data
gpadmin 32351 30571 0 15:39 pts/0 00:00:00 grep postmaster

2.

[pivhdsne:~]$ psql -p 10432 -d commander
psql (8.2.15, server 8.4.20)
WARNING: psql version 8.2, server version 8.4.
Some psql features might not work.
Type "help" for help.

3.

commander=> update users set password_digest='$2a$10$yhji/s6hiGe6AOrBwLzQ0OnSMB83yRd4zxa2i9dC1AkGqEejaUvqa' where username='gpadmin';
UPDATE 1

 

Please use the third command exactly as shown above. Now try to log into Pivotal Commander Center with the following credentials: 

• username: gpadmin 
• password: Gpadmin1