Harbor-用户密码重置

Harbor-用户密码重置

一、找到harbor-db的容器，进入容器

[root@jenkins harbor]# docker exec -it harbor-db bash

二、进入postgresql命令行

postgres [ / ]$ psql -h postgresql -d postgres -U postgres

默认密码root123

postgres [ / ]$ psql -h postgresql -d postgres -U postgres
Password for user postgres:
psql (9.6.23)
Type "help" for help.

三、切换到harbor所在的数据库

\c registry

四、查看harbor_user表

select * from harbor_user;

registry=# select * from harbor_user;
 user_id | username  | email |             password             |    realname    |    comment     | deleted | reset_uuid |               salt               | sysadmin_flag |       creation_time        |        update_time         | password_version
---------+-----------+-------+----------------------------------+----------------+----------------+---------+------------+----------------------------------+---------------+----------------------------+----------------------------+------------------
       2 | anonymous |       |                                  | anonymous user | anonymous user | t       |            |                                  | f             | 2021-10-26 14:46:47.489956 | 2021-10-26 14:46:47.590433 | sha1
       1 | admin     |       | e8d33121818d45b4ec6c6e9f88d9eb3e | system admin   | admin user     | f       |            | UnZb0bkELnShyboQrm4uFdCMQbGvBnir | t             | 2021-10-26 14:46:47.489956 | 2021-10-26 15:22:52.216501 | sha256
(2 rows)

五、重置密码
修改admin的密码，修改为初始化密码Harbor12345 ，修改好了之后登录web ui上再修改

update harbor_user set password='a71a7d0df981a61cbb53a97ed8d78f3e', salt='ah3fdh5b7yxepalg9z45bu8zb36sszmr' where username='admin';