JIRA

Configure a new JIRA war instance for mysql and tomcat

• Extract tar.gz file to /opt (eg. /opt/atlassian-jira-enterprise-3.11)
• sudo cp /media/old/opt/atlassian-jira-enterprise-3.9.1/webapp/WEB-INF/classes/entityengine.xml /opt/atlassian-jira-enterprise-3.11/webapp/WEB-INF/classes/entityengine.xml
• Edit /opt/atlassian-jira-enterprise-3.11/webapp/WEB-INF/classes/entityengine.xml and change:

    <datasource name="defaultDS" field-type-name="hsql"
       schema-name="PUBLIC"

to

    <datasource name="defaultDS" field-type-name="mysql"

• sudo cp /opt/atlassian-jira-enterprise-3.11/etc/tomcat-5.5-jira.xml /var/lib/tomcat5.5/conf/Catalina/localhost/jira.xml
• Edit /var/lib/tomcat5.5/conf/Catalina/localhost/jira.xml
  • Set @JIRA_WEBAPP@ = /opt/atlassian-jira-enterprise-3.11/dist-tomcat/atlassian-jira-3.11.war
  • Delete the resource named jdbc/JiraDS, and replace with:

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
          username="jira"
          password="jira"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost/jira?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"/>

• From /opt/atlassian-jira-enterprise-3.11, run sudo ./build.sh war
• Either edit /etc/default/tomcat5.5 and set TOMCAT5_SECURITY=no or go through the pain of getting the security policy all setup
• Install libmysql-java and sudo ln -s /usr/share/tomcat5.5/common/lib/
• Login to mysql as root, and 'create database jira; grant all on jira.* to jira@localhost identified by 'jira';
• Download http://www.atlassian.com/software/jira/docs/servers/jars/v1/jira-jars-tomcat5.zip, extract, and copy extracted jars to /usr/share/tomcat5.5/common/lib/
• Restart tomcat, cross your fingers, and n