Search code examples
gitldapgitlabgitlab-ce

How do I unblock LDAP users in GitLab-CE

Some of our GitLab users who where authenticated through LDAP got blocked when the LDAP authentication user account was locked. How can I unlock them? GitLab-EE seems to provide this feature by force syncing the LDAP state. How can I do that with GitLab-CE?

Solution

  • I basically went straight into the database:

    sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq

    and

    update public.users set state='active';

    Note: this will unblock all users