Moving JIRA to a new server, since the license used the old servers ID what do I need to do?

We started this on windows but discovered subversion and so on are not to happy with IIS and it wasrecommendedthat we move over to linux. SoI started the process but it won't allow me to use the same db (needs to be empty during install) and after i create a new db (hoping i can imprt the old data or use the od db) it get to the part with the server ID number which of course is diffeent. What doi need to do?

Thanks

rinorio

3 answers

1 accepted

Accepted Answer
0 votes

IMHO, easiest way :

1) stop jira

2) stop database

3) create enviroment on a new server ( install DB, apache, create users, etc )

4) copy %installdir% and %homedir% on the new server

4a) change path's win->linux in %installdir%/atlassian-jira/WEB-INF/classes/jira-application.properties

5) copy jira database on a new server

6) start jira on a new server

P.S. and it's much faster than full-backup way

You can try full backup of the system and then import the system on the new linux server.

If this is a new JIRA setup, it should ask for the license you have.

Cheers, Tihomir.

There are 2 ways of changing server ID, easiest one is by restoring XML backup from existing version, other is to change server ID while running setup. For this you need to locate server ID in database.

You may locate server ID in propertyentry and propertystring table (oracle query below)

Select Ps.Id, Ps.Propertyvalue, Pe.Entity_Name, Pe.Property_Key
From Propertystring Ps, Propertyentry Pe Where Ps.Id=Pe.Id
and pe.entity_name='jira.properties' and pe.property_key like'jira.sid.key'

Below are steps that you should be following in case XML restore fails to get jira application going as per your expectation. Note that you are required to have appropriate rights in DB schema for dropping tables.

  1. Note down server ID from your existing server.
  2. Start jira application against empty database schema.
  3. Hit jira home page from browser. Note down server ID displayed in setup screen.
  4. Stop jira application.
  5. Go to database and using query above (or equivalent depending on your database) locate existing server ID. This should be same as that you noted in step 3 above.
  6. Update the row in propertystring table with server ID that you noted in step above. Commit.
  7. start jira application again.
  8. Hit jira home page again from browser, note that server ID should be same as what you have in old server (as in step 1 above).
  9. Complete setup of jira.
  10. Apply all your customizations.
  11. Import projects from your current XML backup.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

78 views 0 3
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