Database problem after clone Jira for test or staging purpose

We used system snapshot method to clone a production environment to the other VM server for test/staging purpose.  However, we encountered the problem that everything we changed on the cloned server would change to production one.  Wondering what config. settings should be changed on the staging environment to avoid this problem.  We are using Jira server v6.3.15, BTW.  

Besides, we were thinking maybe we can change the database location via Jira configuration tool but we got "Access Denied" error while testing the connection in the last step.   However, using mySQL command to do the same thing seems to work.  Therefore, we don't know how we can solve the problem.  Can anyone advise the correct step when using system snapshot to clone the environment and how to config. the data to the right clone environment instead of still connecting with production one?  Thanks.Jira_ConfigurationDB_Error.png

 

1 answer

0 vote

Hey Niki,

You staging and production are pointing to the same database. In your staging environment, go to your JIRA_HOMe folder and review the configuration on the dbconfig.xml file. This should be updated to point to the staging database and not production.

Have a read through https://confluence.atlassian.com/adminjiraserver071/establishing-staging-server-environments-for-jira-applications-802592273.html

Cheers

Bhushan

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,304 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot