Server dead, How to restore Confluence 6.1.0 with Atlassian directory + SQL Backups?

[Raymond Moy]

I'm having trouble digging through the available docs regarding doing this particular type of restore. 

The original server hosting Confluence got hosed. My plan here is to restore the data on a new install but can't seem to figure out how to do it properly.

Any help would be appreciated. 

[Nic Brough -Adaptavist- · Accepted solution]

The overview of the process is

Install a new clean Confluence 6.1.0, pointed at an empty database.  Get it working to the point where the admin user (created during installation) can log in and see an empty Confluence.

Compare all the settings files from your backup with the clean install, absorbing any changes you've made and want to keep (for example, my Confluence at home has had its server.xml changed so it can live behind a proxy on a different url, I've set it up for SSO, given it a bit more memory, etc)

Stop Confluence, and point it at a restored copy of the database.  Start it and log in.  Run a full re-index.

You'll also want to restore the attachments directory, but that doesn't need any complex actions, just restore it from the backup directly where it used to be.

[Raymond Moy]

I'm not sure if I'm doing it wrong but I did these things after stopping the confluence service:

1: Restored the confluence sql db

2. Created the sqluser like before with same username and password

3. Edited the confluence.cfg file to change

<property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/confluence</property> to the restored database name (in my case it's called confluence)

4. I replaced the attachments folder with the original one.

5. Restarted the server and it still doesn't work. 

It doesn't load anything when I try to access localhost:8090 or localhost :80

I also just checked the server.xml the only difference was the broken one was set up with the connector port being 80 and the new one I build being 8090, should I change that on the new server.xml?

[Raymond Moy]

edit- actually this is all set! Thanks! It got a little tricky at some places but is all set.