Does anyone have step-by-step information for setting up Jira on MySQL. My build crashes.

Mikal Peterson

Build process:

CentOS 7 Disk (102400 MB, ext4)
2048MB Swap Image (2048 MB, swap)
Boot

My SQL installation

sudo yum update

Install wget:
yum install wget

Install MySQL:
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
sudo yum install mysql-server
sudo systemctl start mysqld

Set up the MySQL securty and create a root password
sudo mysql_secure_installation

Remove anonymous users? Y
Disallow root login remotely? Y
Remove test database and access to it? Y
Reload privilege tables now? Y

mysql -u root -p
Server version: 5.6.43 MySQL Community Server (GPL)

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER jiradbuser IDENTIFIED BY 'Password';
GRANT ALL ON jiradb.* TO jiradbuser IDENTIFIED BY 'Password';
SHOW GRANTS FOR jiradbuser;
\q

Edit my.cnf:
/etc/my.cnf
nano my.cnf

Under [mysqld] add the following lines:
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2048M

// remove this if it exists
sql_mode = NO_AUTO_VALUE_ON_ZERO

sudo systemctl stop mysqld
sudo systemctl start mysqld

Install Jira
Filezilla
Created atlassian directory
/opt/atlassian/
Transfered Jira software
Jira Software at https://www.atlassian.com/software/jira/download

chmod a+x atlassian-jira-software-8.0.2-x64.bin
sudo ./atlassian-jira-software-8.0.2-x64.bin

Express install at port 8080

sudo iptables -F

MySQL JDBC connector:
Copy mysql-connector-java-8.0.15.jar to:
/opt/atlassian/jira/lib

Starting Jira software:
cd atlassian/jira/bin
./startup.sh

Create connection to production database:
MySQL 5.6
localhost
3306
jiradb
jiradbuser

CRASH:

This page isn’t working

45.79.81.13 is currently unable to handle this request.

HTTP ERROR 503

Andy Heinzer

Hi Mikal,

I see two major problems with your steps here.

1. You are using the mysql 8.0.x jdbc database driver.  Jira doesn't yet support this version of that database driver.  Instead we recommend using the very latest 5.1.xx version of that driver with the current versions of Jira when using mysql as a database. 
2. You are using a MySQL 5.6.x version, but trying to use the utf8mb4 encoding/collation.  This is also a known limitation with that version of MySQL. Jira 8.x does support that encoding now, but it requires you to use a 5.7.x version of MySQL for Jira to work correctly with that setting.  This is also noted in the Jira supported platforms document for 8.0.x.

However I think if you can address those two problems you should be able to get this up and running.  I would also recommend our guide in Connecting Jira applications to MySQL 5.7 as this guide does provide some good detailed steps to follow.

Let me know if you run into any problems with this.

Andy