How do I recover JIRA, Confluence, Stash, & Bamboo from downed server?

Question

Server CPU or MB died and the quoted repair costs make no sense so we need to migrate machines.  What I am left with is a harddrive from a Win 2008 server with JIRA (+Agile addon), Confluence, Stash, & Bamboo installed on it. Unfortunately my next project was supposed to be setting up backups on the stack (I know...I know...) so all I have is the raw install, not a backup.  I am thinking about maybe going to hosting it on a Linux server since I think I could get the setup of the server scripted so next time the host dies I can get another going quickly, but if moving to a Linux server would present problems vs using another Windows server then I would probably be sticking it on a Win 2012 R2 server.  How do I get the data out of these applications and on  to another server without having the standard backup/restore process in place like I should have?  I think the licensing tied them to the machine right?  I would assume it is not a problem to change that over to a new server?

Steven F Behnke · Answer

@Greg Cobb, I'm sure you will find some help here but I implore you to open a ticket at support.atlassian.com to have them assist with what they can, they are very very helpful. When re-initializing a server, you usually either need an export or a backup. Since the applications are not running, running an export isn't possible. So this means we need to pursue a restoration through the database. As Renato noted, you need to obtain a database dump. Let me walk you through the basic idea here: * Backup the database! * Backup the home folders, and you might as well backup the install folders as well! * Dump each application's table from the database* I assume that all applications were running through individual accounts on the database, writing to their own tables * Restore the install directories to an appropriate location, or rebuild them from the SAME VERSION * Restore the home directories * Restore the database tables in a live database * Configure the INSTALL directory, and ensure it is pointing to the right HOME folder * Configure the HOME directory, and ensure it is pointing to the right DATABASE * Test, verify, repair, repeat /logs/catalina.out and /logs/atlassian-application.log will be very helpful to you as you troubleshoot, please tail both of them and provide them to support engineers. The related documentation, starting at each application, I started below here. Good luck! * https://confluence.atlassian.com/display/JIRA/Restoring+Data * https://confluence.atlassian.com/display/DOC/Restoring+Data+from+other+Backups * https://confluence.atlassian.com/display/STASH/Data+recovery+and+backups * https://confluence.atlassian.com/display/BAMBOO/Importing+data+from+backup

Greg Cobb · Answer

I am starting with JIRA and looked in its config file and noticed the database url listed as jdbc:postgresql://localhost:5432/jiradb

JIRA obviously is connecting to the db via the postgresql server service which doesnt exist anymore since the OS installed on the HD is not running and rather the HD is mounted as a secondary drive on a new computer.  Hopefully there is a way to take the files from a postgresql installation and move them, but either way I guess I need to solve my PostgreSQL problem first before anything else can be done. :(

Greg Cobb · Answer

Right now I have the server harddrive mounted in to a Win7 box.  If I am understanding correctly, I could install JIRA for instance on that Win7 box.  Go on the Atlassian site and generate a license for that "server".  Back up the production database on the old harddrive just in case.  Modify the JIRA install to point to the database in the old harddrive.  Start up JIRA and it will now load up our old JIRA site?  Then apply the new license.  Perform a backup of JIRA.  I should then be able to take that backup and restore it on whatever new production server I end up using for JIRA and the rest of the stack.  Regenerate the license yet again for the new "real" production server and I should then have JIRA successfully migrated to a new server?