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

0 votes
Accepted answer

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 vote
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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,815 views 18 22
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