Gitlab不小心关闭了sign-in，无法登录web的坑。。。

手贱一不小心用root在gitlab后台把登录功能给关了，当时我就懵逼了。

解决方法如下：

#进入数据库修改配置
[root@gitlab-server ~]# gitlab-psql gitlabhq_production

could not change directory to "/root"

psql (9.2.)

Type "help" for help.

gitlabhq_production=#

若想查看资料库列表：

[root@gitlab-server ~]# gitlab-psql -l

could not change directory to "/root"

                                             List of databases

        Name         |    Owner    | Encoding |   Collate   |    Ctype    |        Access privileges

---------------------+-------------+----------+-------------+-------------+---------------------------------

 gitlabhq_production | gitlab      | UTF8     | en_US.UTF- | en_US.UTF- |

 postgres            | gitlab-psql | UTF8     | en_US.UTF- | en_US.UTF- |

 template0           | gitlab-psql | UTF8     | en_US.UTF- | en_US.UTF- | =c/"gitlab-psql"               +

                     |             |          |             |             | "gitlab-psql"=CTc/"gitlab-psql"

 template1           | gitlab-psql | UTF8     | en_US.UTF- | en_US.UTF- | =c/"gitlab-psql"               +

                     |             |          |             |             | "gitlab-psql"=CTc/"gitlab-psql"

( rows)

进入client后：

命令都是可以Tab出来的，很牛B
gitlabhq_production=# UPDATE application_settings set signin_enabled=true;

UPDATE

重启Gitlab:

这里因为启动的慢gitlab web报错出现：502 ，Whoops, GitLab is taking too much time to respond.

等待8080端口启动后，访问即可恢复：

tcp               127.0.0.1:          0.0.0.0:*               LISTEN      /unicorn master

[root@gitlab-server ~]# gitlab-ctl restart

ok: run: gitlab-workhorse: (pid ) 1s

ok: run: logrotate: (pid ) 0s

ok: run: nginx: (pid ) 0s

ok: run: postgresql: (pid ) 1s

ok: run: redis: (pid ) 0s

ok: run: sidekiq: (pid ) 1s

ok: run: unicorn: (pid ) 0s

巴特西

Gitlab不小心关闭了sign-in，无法登录web的坑。。。

最新文章

热门文章