Pivotal HD Command Center: 2.1
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.
You might have lost your gpadmin password for Pivotal Command Center.
Follow the steps to resolve this issue:
- ps -eaf | grep postmaster <---- we do this to get the port number to be used in part 2 below.
- psql -p 10432 -d commander <---- connect to DB commander through port got from past 1 above
- 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
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';
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
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.