we want to changes all JIRA User email domain with new domain.
example : previous mail address user@abc.com
new mail address user@xyz.com
All JIRA Users are configured through the LDAP..
Hi
We were not configured any LDAP server, crowd or other JIRA server with JIRA .
All users configured through JIRA Internal directory only.
we are done this through the database, below are the SQL queries
1.SELECT id FROM cwd_directory WHERE impl_class = 'com.atlassian.crowd.directory.InternalDirectory';
2.UPDATE cwd_user SET email_address = replace(email_address,'<PreviousDomain>','<NewDomain>') WHERE directory_id = <ID from step 2>;
3. UPDATE cwd_user SET lower_email_address = replace(lower_email_address,'<PreviousDomain>','<NewDomain>') WHERE directory_id = <ID from step 2>;
I assume you run JIRA on Linux.
cat your.database.dump.sql | sed 's/@abc\.com/@xyz\.com/g' > new.database.dump.sql
Before doing this on production, make sure you have done it on a test instance and tested everything (like that you have equally many issues assigned, and so forth.
I have merged 4 AD domains into 1 AD domain once using this technique, so know it works, but testing it will make sure you don't run into anything i did not.
Good luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Jonas Andersson
First of all thanks for ur response.
Might be this answer is correct as u assumes JIRA is running on Linux.
but our JIRA is running on Windows, for this what changes we need to do??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.