How to unlock a locked user from the command line

After six failed login attempts a user gets in a locked state.

To unlock a locked user:

  1. SSH into your GitLab server.
  2. Start a Ruby on Rails console:

    ## For Omnibus GitLab
    sudo gitlab-rails console production
    
    ## For installations from source
    sudo -u git -H bundle exec rails console RAILS_ENV=production
    
  3. Find the user to unlock. You can search by email or ID.

    user = User.find_by(email: 'admin@local.host')
    

    or

    user = User.where(id: 1).first
    
  4. Unlock the user:

    user.unlock_access!
    
  5. Exit the console with Ctrl+d

The user should now be able to log in.