installing jira on ubuntu

so i tried xplanner and that didnt really fly for me. now jira, but why must it be so hard to plainly state how to install it etc..

with mysql:
create database jiradb character set utf8;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on
jiradb.* TO ‘jirauser’@’localhost’ IDENTIFIED BY ‘mypassword’;
flush privileges;

download jdbc driver:
http://dev.mysql.com/downloads/connector/j
(wget … seems to difficult to get the url so seems to require a browser to download)

copy jar to /common/lib

customize entity.xml file:
http://confluence.atlassian.com/display/JIRA/Setting+up+JIRA+Standalone+and+MySQL+on+Linux

run build, cd to and
./build.sh

cd dist-tomcat/tomcat6
emacs jira.xml

move the webapp.war file to a suitable directory.. fix the user rights for tomcat6 user

driverClassName=”com.mysql.jdbc.Driver”
url=”jdbc:mysql://localhost/jiradb?useUnicode=true&characterEncoding=UTF8″