Collection of useful stuff for interacting with gitlab.

README.md

Reset root/admin password

Lost the root/admin password? You can reset it using the command-line. Recipe adapted from gitlab issue #308.

# start the console
sudo gitlab-rails console

Then in the ruby interpreter:

# find the user:
# user = User.find_by(email: "[email protected]")
# user = User.find_by(username: "root")
# user = User.find_by(name: "Administrator")
# user = User.find_by(admin: true)
user = User.find_by(username: "root")

# change the password
# or use the ask function from 'highline/import'
user.password = 'secret_pass'
user.password_confirmation = 'secret_pass'

# and save
user.save

Re-enable standard login

# locate application settings
# ApplicationSetting.find_each
appsettings = ApplicationSetting.find_by(signin_enabled: false)
appsettings.signin_enabled = true
appsettings.save

Pre-populate users

I have found that you can just post the info with your admin token:

• https://github.com/gitlabhq/gitlabhq/blob/master/doc/api/users.md
• http://doc.gitlab.com/ce/api/README.html

import requests
headers = { 'PRIVATE-TOKEN' : 'insert-token-here' }
data = {
    'email': email,
    'extern_uid': dn,
    "provider": "ldapmain",
    "name": name,
    "username": username,
    'password': '1234567890',
    "confirm": False,
}
requests.post('https://gitlab.example.com/api/v3/users/', data, headers=headers)

I get the email, dn, name, username from ldap by using python-ldap; I use a filter to only match engineers. The password is required, but you can use a dummy value that matches the security parameters (min 8 characters ...etc)

Pre-confirm users

In case you missed to add confirm=false when creating users.

gitlab-rails console production

then

for user in User.where(confirmed_at: nil) do
    user.confirmed_at = Time.now
    user.confirmation_token = nil
    user.save!
end

one line command to reset password:
gitlab-rails runner "user = User.where(id: 1).first; user.password = 'secret$'; user.password_confirmation = 'secret$';"

I was doing this to change the root password because it would not log in, but it didn't work.

Finally after hours of looking at the database differences (because had one that could not migrate) the root user had password_automatically_set to true.

So changing that in the console:

user = User.find(1)
user.password_automatically_set=false
user.save!

fixed the problem.

I too could not log in for a while, after getting GitLab running on my macos via Docker Desktop. Eventually, I realised here, it tells you where to get the root password:

docker exec -it dockerContainerIDHere grep 'Password:' /etc/gitlab/initial_root_password

In my case:

sbarcoe@macbookm2 gitlab-ee % docker exec -it f2d006d2944e grep 'Password:' /etc/gitlab/initial_root_password
Password: c8OuRl4Hf0UECI+tFo5WRWVNIdW3sdUuTges3YnvtQI=``