Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can you update the lower_user_name for a user?

khughesbp
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 3, 2020

We recently had an issue where our LDAP directory simply disappeared from Jira. When we added it back, all of the users federated through it were left with usernames of "username#1" rather than "username".

Before LDAP directory deletion:

jira=# select * from app_user where user_key = 'username';
id | user_key | lower_user_name
-------+----------+-----------------
10000 | username | username

 

After LDAP directory deletion and recreation:

jira=# select * from app_user where user_key = 'username';
id | user_key | lower_user_name
-------+----------+-----------------
10000 | username | username#1

 

This has left all Jira issues, watchers, comments, etc. attributed to the "username#1" user, which is now an invalid Jira user. Has anyone experienced anything similar to this and if so, what was the fix?

 

Thanks! 

2 answers

0 votes
Kevin Thieling
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 26, 2021

We have just run into this problem as well.  Any good solutions?

0 votes
Vincent Pochard November 9, 2020

Hi @khughesbp

We are facing the exact same issue.
Did you manage to fix it?
Thanks!

Vincent

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.2.2
TAGS
AUG Leaders

Atlassian Community Events