We need some assistance in identifying the root user and administrator for our GitLab account. Here’s a brief overview of our situation:
• Our GitLab instance has a primary group (let’s call it Group A), with 4 users assigned the role of Owner. Within Group A, we have created multiple sub-groups and projects.
• However, when we review the members list for Group A, none of the users are listed as an Admin or root user.
• Over time, several employees have left the company, which has made it challenging for us to track who originally held the root or administrator privileges for our GitLab account.
We are using Free version: GitLab 17.5
Could someone guide us on how to determine who the root user and admin are in our instance? Are there specific commands or settings we should check to uncover this information?
Thank you in advance for your help!
Versions
Please add an x whether options apply, and add the version information.
gitlab-psql
select id,username,name,admin from users where admin = 't';
if that doesn’t give any records, just do the command without the where admin = 't' part.
If one of the users still exists at your workplace then you can then login as that person and do whatever you need to do as an admin - like get them to give you admin rights or whatever. If the user doesn’t work there anymore, you can reset the password using the gitlab-rails console. Reset a user's password | GitLab explains on how to do that.
A working example from my server:
gitlabhq_production=# select id,username,name,admin from users where admin = 't';
id | username | name | admin
----+-------------+---------------+-------
1 | root | Administrator | t
2 | iwalker | Ian Walker | t
Thank you @dnsmichi for your response. Yeah we have few owners for the groups. We have not been blocked by not having the admin access so far, but we wanted to get the admin access, just in case, for the future. Do you mean to say that we don’t really need to have admin access?
Hello GitLab Community,
