gitlab 7.6.2 ldap user cn changed cant login

Update gitlab psql ldap user cn

Posted by Dongyupu on June 27, 2018
  • 处理ladp cn组变化问题,步骤如下:
  • 找到用户新的cn
  • vi /tmp/u.sql,
update identities set extern_uid='CN=董玉璞,OU=大数据与技术部,OU=战略支持事业群,DC=9fgroup,DC=local' where user_id=123
  • ssh to gitlab
su - gitlab-psql
psql -d template1

\l
\c gitlabhq_production
select * from identities ;
(找到对应的用户id,如,将上面的sql user_id=xxxx换成对应的id)

\i /tmp/u.sql