Email address wont update after changing it in LDAP

edwin vasquez_f9df79

Hello Friends,

Im running into an issue where the email field was updated in LDAP and the sync occurs with Jira but the Email address field doesn't get updated. Is updating in the database the only way to do it?

 

Doesn't anyone know the sql command to update this if thats the only way?

Sachin_q0v8o8

hello @edwin vasquez , sometimes the incremental sync doesn't update those details, did you try doing a full sync? To perform a full sync, click on "edit" for LDAP user directory, make any random change and hit "Save and Test" and let it do a full sync.

If you still have the issue you can follow below steps to update your email. However, I would recommend you to perform this on your test environment before making changes on your prod.

PostgreSQL:

1. select * from cwd_user where lower_user_name = 'username';

(id is in the first column, also make sure you chose the id for the ldap directory_id)

2. update cwd_user set email_address = 'xyzz@test.com' where id=10000;

3. update cwd_user set lower_email_address = 'xyzz@test.com' where id=10000;

confirm if everything looks good

4. select * from cwd_user where id=10000;

Note: After making the updates clear the "Jira internal caches" using scriptrunners inbuilt script.


Best,
Sachin.