Confleunce on Linux with Oracle Backend. Moved to Virtual guest, lost front end vm. How to reinstal

Question

I have the oracle backend, how can I install a new confleunce front end that will connect to me current backend?  To make matters worse,  I "think"   I was on version 5 or 5.1.  Can I check that in oracle? Is the version stored in the database?

I really do not want to start over again with me data.

John

Nic Brough -Adaptavist- · Answer

Unfortunately, the confversion table only has the build number in it, and that's not readily translatable to a version of confluence.

If you're sure you were on 5.0 or 5.1, then download both, install one of them (using separate clean empty databases) and get them working, then stop it.

Edit the config file in the new <confluence home> and point it to the old database.  Backup the old database and try starting Confluence.  If it's the wrong version, it will tell you (and stop).  You can also check the clean database for the build number in there to see how close you are getting.

If 5.0 doesn't work, try 5.1

AnnWorley · Answer

Hi John,

You can find the build number in the database by running:

select buildnumber from confversion;

against your database and then cross referencing the build number on this page: Confluence build information

If you lost your data directory you probably lost your attachments - they are stored on the file system for most instances. However, most of your content is in the database so here is my suggestion:

* Install a new Confluence instance of the same version you had before. Use a new database because the setup wizard overwrites the database.
* Close down the new confluence and edit <Confluence_Home>/confluence.cfg.xml (or <Conflunece_install/conf/ server.xml) if you use a datasource connection) to point to the new database.

Those are the high level steps - for step by step details please see Method two . (It says its for large volumes of attachments but it is really an alternative to the XML restore method which you cannot use because you don't have the front end application server to make the XML backup.

Best wishes,

Ann