Skip to main content
  1. 2023/
  2. Posts from July/

Wait, where is my password?

root@gitlabvm:/data/gitlab# docker-compose exec gitlab  gitlab-psql
psql (13.11)
Type "help" for help.

gitlabhq_production=# SELECT username,password_expires_at FROM users WHERE password_expires_at IS NOT NULL;
username |    password_expires_at
----------+---------------------------
meenyon  | 2023-07-17 04:52:54.96629
(1 row)

gitlabhq_production=# UPDATE users SET password_expires_at = null WHERE password_expires_at IS NOT NULL;
UPDATE 1
gitlabhq_production=#