JIRA

Configure a new JIRA war instance for mysql and tomcat

Some more details here: http://confluence.atlassian.com/display/JIRA/Installing+JIRA+on+Tomcat+6.0. Note in the instructions below that you should only ever edit files in edit-webapp (not webapp since they will be overwritten).

• Extract tar.gz file to /opt (eg. /opt/atlassian-jira-enterprise-4.0.1)
• Edit /opt/atlassian-jira-enterprise-4.0.1/edit-webapp/WEB-INF/classes/jira-application.properties and set jira.home=/var/lib/jira
• Edit /opt/atlassian-jira-enterprise-4.0.1/edit-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"

• From /opt/atlassian-jira-enterprise-4.0.1, run sudo chmod u+x build.sh; sudo ./build.sh war

• sudo cp /opt/atlassian-jira-enterprise-4.0.1/etc/tomcat-6-jira.xml /etc/tomcat6/Catalina/localhost/jira.xml
• Edit /etc/tomcat6/Catalina/localhost/jira.xml
  • Set @JIRA_WEBAPP@ = /opt/atlassian-jira-enterprise-4.0.1/dist-tomcat/atlassian-jira-4.0.1.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&amp;useUnicode=true&amp;characterEncoding=UTF8"/>

• Either edit /etc/default/tomcat6 and set TOMCAT6_SECURITY=no or go through the pain of getting the security policy all setup
• Install libmysql-java and sudo ln -s /usr/share/java/mysql-connector-java-5.1.6.jar /usr/share/tomcat6/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-tomcat6.zip, extract, and copy extracted jars to /usr/share/tomcat6/lib/
• Restart tomcat and cross your fingers