Confluence and JIRA Upgrade Instructions

This is the log from out most recent upgrade of Jira and Confluence

1. Download:  confluence-1.4.1.zip
2. Download:  atlassian-jira-enterprise-3.2.1.zip
3. Unpack both into:  D:\java
4. Run export on bugs.freehep.org and jira.slac.stanford.edu:
   d:\fh-jira-15jun2005.zip (902 kB)
   d:\slac-jira-15jun2005.zip (2564 kB)
5. Turn off tomcat service.
6. Backup confluence directory:
   d:\ConfluenceData -> d:\Copy of ConfluenceData
7. To be extra safe, also back up MySQL databases using phpMyAdmin.
8. Upgrade Jira using instructions at:http://atlassian.com/software/jira/docs/v3.2.1/upgrading.html

SLAC-Jira

1. Edit entityengine.xml, only change:
   datasource name hsql -> mysql, and jndi-name ->java:comp/env/jdbc/SLACJiraDS
   AND name="java:comp/env/UserTransaction" (X2)
2. Run build.bat
3. In D:\java\tomcat-base2\conf\Catalina\jira.slac.stanford.edu edit ROOT.xml,
   change to use url="jdbc:mysql://localhost/slacjiradb?autoReconnect=true"
4. Drop all tables in: slacjiradb using phpMyAdmin
5. Unpack dist-tomcat war files into: D:\java\tomcat-base2\slac-jira-apps\ROOT

FreeHEP-JIRA

1. Edit entityengine.xml again, and change:
   jndi-name->java:comp/env/jdbc/JiraDS
2. Run build.bat
3. In D:\java\tomcat-base2\conf\Catalina\bugs.freehep.org edit ROOT.xml,
   change to use: url="jdbc:mysql://localhost/fhjiradb2?autoReconnect=true"
4. Unpack dist-tomcat war files into:  D:\java\tomcat-base2\bugsapps\ROOT

Upgrade Jira

1. Use  instructions at:http://confluence.atlassian.com/display/DOC/How+to+update+Confluence
2. Edit confluence-init.properties in D:\java\confluence-1.4.1\confluence\WEB-INF\classes
3. Add: confluence.home=D:ConfluenceData
4. Edit: D:\java\tomcat-base2\conf\Catalina\confluence.slac.stanford.edu\Root.xml
   Point docBase=D:/java/confluence-1.4.1/confluence
   Change to: point to slacjiradb (for authorization)
5. Delete old stuff in:  D:\java\tomcat-base2\work\Catalina
6. Restart tomcat, and load backed up data into JIRA
7. Copy old osuser.xml into:  confluence\WEB-INF\classes