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:

```sh ## For Omnibus GitLab sudo gitlab-rails console production

## For installations from source sudo -u git -H bundle exec rails console RAILS_ENV=production ```

1. Find the user to unlock. You can search by email or ID.

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

or

ruby user = User.where(id: 1).first

1. Unlock the user:

ruby user.unlock_access!

1. Exit the console with Ctrl+d

The user should now be able to log in.