Email address wont update after changing it in LDAP

[edwin vasquez]

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]

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.

[edwin vasquez]

@Sachin Thanks, for your suggestion. The full sync didnt work after making the edit to the directory.

Our Jira Service Desk is configured with a SQL instance. Any idea what the command would be in SQL or is it the same?

[Sachin]

hello @edwin vasquez , those queries should work in SQL, give it a try and let me know if they don't.

[Hannes]

Hi @Sachin , I‘ve followed your guide. But my problem is: In cwd_User there is a mail address and a lower mail address, but the mail field in the Jira Application is still empty. Do you have any idea?