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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

121 views 4 9
Read article

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