Environment: Windows, Java 2 SDK 1.4.2_03, MySQL 4.0.17, Tomcat LE 4.1.30
JIRA: Enterprise 2.6 EAR/WAR
In the
JIRA Tomcat 4.1 documentation, there is a big warning that you cannot install JIRA under Tomcat 4.1 LE "Light Edition". In my ISP environment, I had to install JIRA under Tomcat 4.1 LE, so I needed to at least test things to see if they would break and how bad. This is a straight "out of the box" installation with some minor modifications to the online JIRA installation instructions noted below.
1. Unpack JIRA
2. Configure JIRA
There seems to be an error with OFBiz using mysql, at least in my configuration. On startup, it would always use the HSQL field definitions. This was causing much confusion as the syntax differs from MySQL. To get around this, I had to copy $JIRA_HOME/webapp/WEB-INF/classes/entitydefs/fieldtype-mysql.xml to $JIRA_HOME/webapp/WEB-INF/classes/entitydefs/fieldtype-hsql.xml. Those two files remain along with the entitygroup.xml and entitymodel.xml files, but I deleted all the other fieldtype-*.xml files.
3. Update Tomcat Libraries before building
Unpack the extra Tomcat JAR files into the $JIRA_HOME/webapp/WEB-INF/lib directory. Also copy the MySQL DB driver JAR file into this directory.
4. Build JIRA
4. Update Tomcat Libraries
5. Configure Tomcat
Copy the jira.xml file from the $JIRA_HOME/dist-tomcat directory to your Tomcat 4.1.30 LE webapps directory. The "url" parameter in the ResourceParams definition looks as follows:
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/jiradb?autoReconnect=true</value>
</parameter>
6. Create the JIRA user and database
First, use the mysql program to connect to the server as the MySQL root user:
shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO 'jirauser'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> quit
Log back in as the JIRA user and create the database:
shell> mysql --user=jirauser --password=some_pass
mysql> create database jiradb;
7. Start Tomcat
Point your browser to
http://localhost:8080/jira. You should now see the setup wizard.
