Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bulk Change Username

Hi,

Jira 7.13.1 is being used with delegated LDAP.  Which I understand, syncs with LDAP when user log into Jira.

Jira LDAP Directory settings are as below.

User Name Attribute: employeenumber
User Object Filter: (&(employeenumber=*))
User Name RDN Attribute:employeenumber
User Unique ID Attribute: uid

User log into Jira with their employeenumber i.e '123456'.

This 'employeenumber' is the field from LDAP server.

There is another field 'uid' which stores 'u123456'.  uid is also a unique id in LDAP. server.

 

We would like to change the username from '123456' to 'u123456'. That is we need make change from employeenumber to uid.

We made below change in Jira LDAP Directory settings

User Name Attribute: uid
User Object Filter: (&(uid=*))
User Name RDN Attribute: uid
User Unique ID Attribute: uid

User was asked to login with 'u123456' and he was successfully able to login. In database I could see app_user, cwd_use and cwd_membership table updated.

Now, I want to make this change for all users. Hence the obvious solution that appeared to me was to change in database the value of 'External_id' in table cwd_user from (null or 123456) to 'u123456' and restart Jira.

I did it for one record (111111) and asked another user to login with 'u111111', but this time Jira considered him as a new user and started creating its profile.

So, as a next solution, I updated all 3 tables app-user, cwd_user and cwd_membership, replaced '111111' with 'u111111'.

Restarted Jira and asked user to login with u111111, this time, Jira took long time on login page and reported the error 'Sorry username and password is incorrect'

Can you please help me what was wrong with my approach and how it can be corrected?

Thanks,

Imran

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

281 views 2 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you