How do I reinstall my same version of Jira

[Richard Simpson]

I have lost the machine on which the Jira application is installed.  The database is however intact. 

Tried to install current version of the JIRA , but it doesnt get past message about read only user.   The loss of the JIRA application has affected our access to the BitBucket which was integraged as well. 

So the questions are :

1. Can you determine the version of the JIRA which we had installed based on the SEN provided

2. Can we get access to the installation image for this version, so we may reinstall on new server

3. If we successfully install this previous version of the JIRA application, will we be able to port the data from the unscathed database to this new installation

4. Will out bitbucket continue to work with the new installed version of the JIRA and retain the admin users ( who are currently unable to access bitbucket )

Can you please answer each of these points in turn.  We hope to get some traction in a bid to resume our normal activities after loss of original server.

[Richard Simpson]

Hi All, thanks for your feedback on the matter as they pointed us in a direction which allowed us to make some headway.

For the benefit of others who use a similar setup to that of ours.  We were using Oracle 11g as our backing database and on a CentOS 7 platform .

We had to do the following :

1. Download the installation archive closest to the version which we had .  As our version was no longer available. We had to take 7.0.11 ( we didnt see 7.0.0)

2. Perform the installation

3. NOTE: this installation comes with the ojdbc driver already in the lib folder.  I mentioned this as we blindly copied over the drivers we had and got some failure.  

Now we are onto our next set of challenges which is to

1. get the Service Desk add on included

2. point the original database

We will notify here on progress and our steps as it may help others in a similar position.

[Tobias Ravenstein]

You can find the right Version to install if you look into the database. For example this Query:

SELECT propertyvalue FROM propertystring WHERE id=(SELECT id from propertyentry WHERE property_key='jira.version');

Gave me the Version 7.12.1 on my system. I am not sure if the table schema is the same on older systems.

[Richard Simpson]

Thanks for this. It helped. We also found the version was also available in the footnotes of the Jira alerts. That comment may help those who lost the DB as well.

[Nic Brough -Adaptavist-]

1. No, it's a key based on customer and licence, not the version (because Atlassian can't reliably know what version you've got, and a licence covers a huge range of them)
2. Yes - see https://www.atlassian.com/software/jira/download
3. Yes, although it's a bit complex.  You'll need to set up a new Jira, empty, install any add-ons you used to have on the old one, then you can reconfigure it to look at the old database (I would strongly recommend backup of the database before you do that).  Then restart the new Jira, and re-index it immediately.  You may have some "fun" with admin users if you didn't have at least one internal user set as an admin.
4. Yes, once it's all restored

[Richard Simpson]

Thanks for the feedback.  We'll soon get to the "fun" part ... trying to get the service desk component included first.