手贱一不小心用root在gitlab后台把登录功能给关了，当时我就懵逼了。
解决方法如下：
#进入数据库修改配置
[root@gitlab-server ~]# gitlab-psql gitlabhq_productioncould not change directory to "/root"psql (9.2.18)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-8 | en_US.UTF-8 | ?postgres ???????????| gitlab-psql | UTF8 ????| en_US.UTF-8 | en_US.UTF-8 | ?template0 ??????????| gitlab-psql | UTF8 ????| en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" ??????????????+ ????????????????????| ????????????| ?????????| ????????????| ????????????| "gitlab-psql"=CTc/"gitlab-psql" template1 ??????????| gitlab-psql | UTF8 ????| en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" ??????????????+ ????????????????????| ????????????| ?????????| ????????????| ????????????| "gitlab-psql"=CTc/"gitlab-psql"(4 rows)
进入client后：
命令都是可以Tab出来的，很牛B
gitlabhq_production=# UPDATE application_settings set signin_enabled=true;UPDATE 5
重启Gitlab:
这里因为启动的慢gitlab web报错出现：502 ，Whoops, GitLab is taking too much time to respond.
等待8080端口启动后，访问即可恢复：
tcp ???????0 ?????0 127.0.0.1:8080 ?????????0.0.0.0:* ??????????????LISTEN ?????7275/unicorn master
[root@gitlab-server ~]# gitlab-ctl restartok: run: gitlab-workhorse: (pid 7220) 1sok: run: logrotate: (pid 7226) 0sok: run: nginx: (pid 7234) 0sok: run: postgresql: (pid 7241) 1sok: run: redis: (pid 7250) 0sok: run: sidekiq: (pid 7255) 1sok: run: unicorn: (pid 7260) 0s
Gitlab不小心关闭了sign-in，无法登录web的坑。。。
原文地址：http://www.cnblogs.com/pyyu/p/7521606.html