RSS

JIRA & Jira Agile installation: A step-by-step guide with snapshots

29 Apr

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:

ifconfig

image

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):

ssh user@192.168.136.129

where user is Ubuntu login user name.

All right, everything seems to be ready, let’s start the journey!

  • Install Java on Ubuntu
  • java -version
    sudo apt-get update
    sudo apt-get install default-jre or sudo apt-get install default-jdk

  • 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.

  image

sudo apt-get install mysql-server 

imageimage


 

  • 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;

imageGrant database access right:

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 root@192.168.136.129;

image

  • open 3306 port to allow internet access:

sudo nano /etc/mysql/my.cnf

     comment the line in the above file /etc/mysql/my.cnf

#bind-address 127.0.0.1

imageimage

    Ctrl + O to save,  Ctrl + X to exit. Then restart mysql service:

    sudo service mysql restart

  • Download MySQL MySQL JDBC driver to Ubuntu server

wget  http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.35.zip

image

  • 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

image



wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-6.4.3-x64.bin
chmod a+x atlassian-jira-6.4.3-x64.bin

and then execute the bin file:

./atlassian-jira-6.4.3-x64.bin

Follow the instruction as below. Note that you should select [2] Custom Install, instead of [1] (which uses in-memory databases)

image

Wait for the process to finish installation, see below GIF animation:

jira

  • In your browser, launch http://192.168.136.129:8080, or whichever IP address and port number you specified durng the installation:

image

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:

image

Click “Test Connection” button:

  • You will see an error pops up:

image

  • 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/

or

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
  • cd ~/atlassian/jira/bin
    sudo ./stop-jira.sh
    sudo ./start-jira.sh

  • Go back to the browser where database setup is stopped as shown in the above figure, click “Test Connection” button again:

image

  • Yeah!~
  • Click Next, and say HELLO to JIRA & JIRA Agile! You are now infinitely close to JIRA full installation.

image  image

image  image

image  image

image

image  image

Happy Managing!

 
Leave a comment

Posted by on April 29, 2015 in Project Management

 

Tags: , , , , , , , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: