Pivotal Knowledge Base

Follow

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

Environment

Pivotal HD Command Center: 2.1

Purpose
Procedure to set the gpadmin password back to default from the CLI. Once this is completed, you can then log back in and change the password as per the procedure in the documentation. 

Cause 

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

Procedure

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

Additional Information 

Please follow the link below for instructions on how to change the password from default in the command center once the procedure about is completed. 

http://pivotalhd-210.docs.pivotal.io/doc/1110/pdf/PCC_21_User.pdf

Comments

Powered by Zendesk