I can't setup the connection to MySQL

[Reto Duss]

I managed to get a connection from Jira to the MySQL data base. I need to mention that I run both in a docker container (jira and mysql).

MySQL is version: 8.0.20 MySQL (I assume to use MySQL 5.7+)

The connection between the data base and Jira basically works. But I still get stuck in the "Database setup" dialog. The error message is:

This MySQL instance is not properly configured. Please follow the documentation for MySQL 5.7+ setup.

I did the following steps:

# Get and initialize
docker pull mysql
docker run -p 3306:3306 --name red-mysql -e MYSQL_ROOT_PASSWORD=test -d mysql:latest

#########################
# Wait a few minutes, let the docker container start properly

# Shell to run command within the docker
docker exec -it red-mysql bash

# Setup the data base
mysql -u root -p
the password is 'test', as set above
CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER 'jiradbuser'@'%' IDENTIFIED BY 'test_password';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jiradbuser'@'%';
flush privileges;
quit

# Prepare JIRA
docker volume create --name jiraVolume
docker run -v jiraVolume:/var/atlassian/application-data/jira --name="jira" -d -p 8080:8080 atlassian/jira-software

# Make them restart @ PC boot
docker update --restart=always jira
docker update --restart=always red-mysql

# Prepare the mysql connector
docker cp mysql-connector-java-5.1.49.tar.gz jira:/
docker exec -it jira bash
mv mysql-connector-java-5.1.49.tar.gz opt/atlassian/jira/lib (in the container)

Settings (Database setup dialog in webbrowser):
Database Type: MySQL 5.7+
Hostname: 192.168.1.146
Port: 3306
Database: jiradb
Username: jiradbuser
Password: test_password

Then I do get the error mentioned above. Reading the link provided with the error I found that I am short of the following settings in my.cnf.

Locate the [mysqld] section in the file, and add or modify the following parameters:

• Set the default storage engine to InnoDB:

  [mysqld]
  ...
  default-storage-engine=INNODB
  ...

• Specify the character set used by the database server:

  [mysqld]
  ...
  character_set_server=utf8mb4
  ...

• Set the default row format to DYNAMIC:

  [mysqld]
  ...
  innodb_default_row_format=DYNAMIC
  ...

• Enable the large prefix:

  [mysqld]
  ...
  innodb_large_prefix=ON
  ...

• Set the InnoDB file format to Barracuda:

  [mysqld]
  ...
  innodb_file_format=Barracuda
  ...

• Specify the value of innodb_log_file_size to be at least 2G:

  [mysqld]
  ...
  innodb_log_file_size=2G
  ...

• Ensure the sql_mode parameter does not specify NO_AUTO_VALUE_ON_ZERO

  // remove this if it exists
  sql_mode = NO_AUTO_VALUE_ON_ZERO

As soon as I have added these settings in /etc/mysql/my.cnf the data base server does not start anymore. If I restore the my.cnf the error is back.

• Do you have any hint where I can find some more info to debug?
• Is there some more in what is properly configured on MySQL?
• Is there somewhere a log in Jira I could analyze?

Any tip is welcome.

Kind regards,
Reto

[Reto Duss]

Thanks for your support. I will have a look at it as soon as possible.

[Akhtaruzzaman SM]

Settings (Database setup dialog in webbrowser):
Database Type: MySQL 5.7+
Hostname: 192.168.1.146
Port: 3306
Database: jiradb
Username: jiradbuser
Password: test_password


Please Check your Base is 
properly connected or hands off. AKTAR

[Nic Brough -Adaptavist-]

The parameters that are requested in the Jira document are required for a stable safe running version of Jira.

If you're making changes to the my.cnf and those prevent the database service from starting, then you need to debug the database service, not Jira.

You'll need to read the database logs to find out why it is not starting up.