JIRA and JIRA Agile are powerful tools for project management. In my recent work, I tried to install JIRA and JIRA Agile on a Ubuntu Server or Ubuntu Desktop, and though seemingly this is a straightforward process, however to really get it up and running as you expected, this is far from a trivial work.
The motivation of this post is to offer a step-by-step guide, with as many snapshots as possible, so as to make it easier for others to repeat this installation process.
I assume the Ubuntu Server is installed on another machine, be it a physical or a virtual machine, to get he IP of this Ubuntu server, run the below command in a terminal:
Then I first remote logged into the server, using either ssh (in MacOSX) or putty (in windows):
Open a terminal (in MacOSX) or command window (in windows):
where user is Ubuntu login user name.
All right, everything seems to be ready, let’s start the journey!
- Install Java on Ubuntu
- Install mysql on Ubuntu: this is especially useful if you want to use Jira in serious projects. The built-in JIRA installation uses in-memory database, and you should use a database like mysql or sqlserver etc. if you really want to have a stable JIRA for your project management.
sudo apt-get update
sudo apt-get install default-jre or sudo apt-get install default-jdk
sudo apt-get install mysql-server
- Create database on Ubuntu, the databases (jiradbuser & jiradb) are to be used by JIRA, of course you can use any database name you like:
sudo mysql -u root -p
mysql> CREATE DATABASE jiradbuser; // optional
mysql> CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
mysql> use jiradb;
mysql> GRANT ALL ON *.* to root@’192.168.136.129′ IDENTIFIED BY ‘mysqlpassword’;
mysql> FLUSH PRIVILEGES;
To verify DB access is success or not:
SHOW GRANTS FOR firstname.lastname@example.org;
- open 3306 port to allow internet access:
sudo nano /etc/mysql/my.cnf
comment the line in the above file /etc/mysql/my.cnf
- Download MySQL MySQL JDBC driver to Ubuntu server
Ctrl + O to save, Ctrl + X to exit. Then restart mysql service:
sudo service mysql restart
- Extract the driver file zip → jar, for later use:
sudo apt-get install unzip
unzip mysql-connector-java-5.1.35.zip -d mysql_driver //[***] , mysql_driver is unzip directory
- Next, Go to https://www.atlassian.com/software/jira/download to download JIRA server, copy the download link button, and in Terminal:
chmod a+x atlassian-jira-6.4.3-x64.bin
and then execute the bin file:
Follow the instruction as below. Note that you should select  Custom Install, instead of  (which uses in-memory databases)
Wait for the process to finish installation, see below GIF animation:
- In your browser, launch http://192.168.136.129:8080, or whichever IP address and port number you specified durng the installation:
Select the 2nd option “I will set it up myself”, click “Next”
- Input the below information as shown below: the Database “iiradb” is the one we created earlier, and the Username and Password are mysql user name and psw:
Click “Test Connection” button:
- You will see an error pops up:
- To solve this, refer to the earlier procedures we have done to unzip the MySQL JDBC driver, we extracted the zip file, and we can get a JAR file, e.g. mysql-connector-java-5.1.35-bin.jar.
- Copy the unzipped jar file (JDBC driver) to jira application directory/WEB-INF/lib/
sudo cp mysql-connector-java-5.1.35-bin.jar /opt/atlassian/jira/atlassian-jira/WEB-INF/lib/
sudo cp mysql-connector-java-5.1.35-bin.jar ~/atlassian/jira/atlassian-jira/WEB-INF/lib/
which depends on where you have installed JIRA.
- Go back to the browser http://192.168.136.129:8080, refresh, it should work now
- But unfortunately, it won’t work. This is because you need to let JIRA know you have changed the JDBC driver setting, to do so, restart JIRA
- Go back to the browser where database setup is stopped as shown in the above figure, click “Test Connection” button again:
- Click Next, and say HELLO to JIRA & JIRA Agile! You are now infinitely close to JIRA full installation.