About changing forward email for mail handler (SQL command)

Hi all,

Sometime, for troubleshooting purpose, we will do the db refresh from Production database to Dev database.

After the refresh, some data are using Production data.

So, we have a script which we will execute it after db refresh.

One of the script as below: (this sql is to update the Email Handler's Forward Email from Prod email account to dev email account (devjira@abc.com)

--set the notification addresses for mail services
UPDATE propertystring
SET propertyvalue = 'devjira@abc.com'
WHERE id IN (SELECT id
FROM propertyentry
WHERE property_key = 'forwardEmail'
AND entity_name = 'ServiceConfig'
AND propertytype = 5);

From table, propertystring, I can see the propertyvalue has been updated to devjira@abc.com.

When go to GUI, Log in to Jira > System > Incoming Mail ( we can see lists of Mail Handlers) , at this page, Under Properties, you can see the Forward Email: devjira@abc.com.

But, problem now is if you click on Edit (for any of the Email Handlers), click Next (go to second page for mail Handler configuration), at Forward Email, it will state jira@abc.com(Production email account).

Can anyone advise any field in database that I miss out to update it? Thanks.

3 answers

1 accepted

This widget could not be displayed.

My team mate found another field that needed to replace, it is propertystring table (field: propertyvalue). Thanks!

This widget could not be displayed.

Hi,

Did you restart JIRA after running the sql script?

Vijay.

This widget could not be displayed.

Vijay, yes, restart after the post script running (the sql). Thanks!

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

85 views 1 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you