How to Change email domain in jira

[Yogesh Mude[Jira]]

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..

[Yogesh Mude[Jira] · Accepted solution]

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>;

[Jonas Andersson]

I assume you run JIRA on Linux.

• Shut down jira.
• Dump database to a file named your.database.dump.sql
• do this:

cat your.database.dump.sql | sed 's/@abc\.com/@xyz\.com/g' > new.database.dump.sql

• import the database again

• start up Jira, reindex it.

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!

[Yogesh Mude[Jira]]

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??