Skip to content

"No authentication methods configured" problem again

I am using the newest Gitlab version (8.13.11). Today I disabled the user sign-in by mistake. When I login again, I can only see "No authentication methods configured" and cannot do anything. I found some solutions, e.g

sudo gitlab-rails console 
s = ApplicationSetting.find_by(signin_enabled: false) 
s.signin_enabled = true 
s.save

or

sudo gitlab-psql gitlabhq_production
gitlabhq_production=# UPDATE application_settings set signin_enabled=true;
gitlabhq_production=# quit
gitlabhq_production-# ^D\q
sudo gitlab-ctl restart

It seems that all the solutions modify the "signin_enabled" item in the "application_settings" table. But this method is invalid in my Gitlab version, because there is not an item named "signin_enabled" in the "application_settings" table any more!

gitlabhq_production=# \d application_settings
                                                   Table "public.application_settings"
                 Column                 |            Type             |                             Modifiers                             
----------------------------------------+-----------------------------+-------------------------------------------------------------------
 id                                     | integer                     | not null default nextval('application_settings_id_seq'::regclass)
 default_projects_limit                 | integer                     | 
 signup_enabled                         | boolean                     | 
 gravatar_enabled                       | boolean                     | 
 sign_in_text                           | text                        | 
 created_at                             | timestamp without time zone | 
 updated_at                             | timestamp without time zone | 
 home_page_url                          | character varying           | 
 default_branch_protection              | integer                     | default 2
 restricted_visibility_levels           | text                        | 
 version_check_enabled                  | boolean                     | default true
 max_attachment_size                    | integer                     | not null default 10
 default_project_visibility             | integer                     | 
 default_snippet_visibility             | integer                     | 
 domain_whitelist                       | text                        | 
 user_oauth_applications                | boolean                     | default true
 after_sign_out_path                    | character varying           | 
 session_expire_delay                   | integer                     | not null default 10080

Are there any modification for the position of the "signin_enabled" item in the new version? How should I resolve my problem for the current Gitlab version? Thanks in advance.