gitlab不小心把sign-in取消了怎么恢复

No authentication methods configured.

[root@linux-node1 etc]# gitlab-psql gitlabhq_production
could not change directory to "/var/opt/gitlab/gitlab-rails/etc": Permission denied
psql (9.6.1)
Type "help" for help.

gitlabhq_production=# UPDATE application_settings set signin_enabled=true;
UPDATE 6
gitlabhq_production-# \q
[root@linux-node1 etc]# gitlab-ctl restart
ok: run: gitaly: (pid 79247) 1s
ok: run: gitlab-monitor: (pid 79254) 0s
ok: run: gitlab-workhorse: (pid 79258) 1s
ok: run: logrotate: (pid 79268) 0s
ok: run: nginx: (pid 79279) 0s
ok: run: node-exporter: (pid 79287) 0s
ok: run: postgres-exporter: (pid 79294) 1s
ok: run: postgresql: (pid 79309) 0s
ok: run: prometheus: (pid 79320) 1s
ok: run: redis: (pid 79331) 0s
ok: run: redis-exporter: (pid 79337) 1s
ok: run: sidekiq: (pid 79348) 0s
ok: run: unicorn: (pid 79353) 1s
[root@linux-node1 etc]#

验证