Changing database server name only

I have used the JIRA Configuration Tool to change the Database Hostname.

The database is exactly the same database as before, running onthe same server, however IT have asked me to use a new DNS alias for the machine. The Test Connection button on the JIRA Configuration Tool tells me that the connection is successful, but afer restarting the JIRA service, on attempting to access Jira via my browser I am met with a JIRA Setup page (Step 2 of 4: Application properties).

I do not wish to re-setup Jira. I wish to continue with everything as it was. I have an option of entering my licence key, but do not know whether this is safe to do (will I lose any data?). I have an option of importing existing data, but as I was not intending on re-installing I did not export data beforehand (I do have an export from earlier in the day but do not wish to use this) .

How do I safely continue to use JIRA with my existing database and existing settings?

Thank you.

3 answers

1 accepted

To fix this, in the end I bit the bullet and went through the process to import existing data. I took a backup of the SQL database before thinking I could try restoring it over the top afterwards, but once the server was back up, we wtill had data that was more recent than the backup, so it seems this really is an "import", and not an overwrite.

1 votes
Stop Jira and have a look in its home directory. There should be a file called dbconfig.XML . See if the old database location is still in it and change it if it is. Then start Jira again. (I may be wrong here, but the last time I did that, it worked perfectly, no need to even redo the setup)

Thanks for the very fast response, but unfortunately that doesn't fix the problem - dbconfig.xml already has the new name in it (I assume that all the config tool did is update this file).

Possibly worth noting that for now the old server name is still valid (it will be retired in a couple of weeks). However even if I change back to the old name, I have the same problem.

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,076 views 13 18
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