JIRA
From Briki
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
- Extract tar.gz file to /opt (eg. /opt/atlassian-jira-enterprise-4.0.1)
- Edit /opt/atlassian-jira-enterprise-4.0.1/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&useUnicode=true&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