Unable to connect Jira to MySQL

Question

Hi,

I am trying to launch Jira on my local NAS using Docker. I have created a database (MySQL 8.0.19) as a separate container. Database is completely new, no tables, nothing... Only one user is created for Jira. All configurations mentioned here: Config Manual are done. Except, following [mysqld] options were deprecated, so I had to remove them:

* innodb_file_format
* innodb_large_prefix
* innodb_file_format_max

As a result, every time I try to connect Jira to the DB, I get following error:

Could you please suggest how to solve this issue?

It seems it is just incompatible with the new version.

Thanks.

UPDATE:

MySQL 5.7.9 configured properly and fully empty gives following error:

Andy Heinzer · Answer

Hi Segii,

Thanks for including that file.  I can see that you appear to be able to start Jira, but it seems that Jira is not progressing beyond this setupdatabase stage.   I would be interested to see if perhaps we can bypass connecting Jira to this database using the web gui, and instead use another method.  For example, you could use the Jira Config Tool as a means to configure the $JIRAHOME/dbconfig.xml file BEFORE starting Jira itself.

This utility can save your desired database configuration settings to the dbconfig.xml file.  Try this. Once saved, start Jira again.  See if you can get further then into the setup of Jira itself this way.  I would be interested to see the logs, as well as your dbconfig.xml file from this time (please note that this file will contain your username and password in cleartext, I don't need to see those).  I would be interested to see the syntax of your dbconfig.xml file here, and that log file, when starting Jira here if you get stuck again.

Please let me know.

Andy

Sergii Sopin_gkbz6p · Answer

Hi Andy,

Here is the link to the log file: https://we.tl/t-wZ8dcIRAUB

But it only says something about cyclic dependency there and nothing else.

Thanks.

Sergii

Andy Heinzer · Answer

Hi Sergii,

I see that you are trying to setup Jira server with a MySQL database but running into some problems in the process.  First off, you are correct, MySQL 8.x is not yet supported by Jira server.  You can see a list of the supported platforms over in https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

In the current release (Jira 8.7.x), the only supported version of MySQL is 5.7.x.   I understand that you have setup a 5.7.9 MySQL database, but you are still getting an error that the database is not empty.  The steps we have documented in Connecting Jira to MySQL 5.7 database  are still correct.  Perhaps there is something amiss here.  Would you be able to share that startup log of Jira so we can investigate further?  You can find this in either

* $JIRAINSTALL/logs/catalina.out
* $JIRAHOME/log/atlassian-jira.log

I'm afraid our Community site won't allow you to attach these files, but perhaps you could store these to a service like dropbox or google drive temporarily and then share a link to these files to us here.  That way we can more closely see what Jira is seeing when it trying to connect to that database, or startup with that database settings here.  I think these logs will tell us more about your configuration that can help us here.

Please let me know.

Andy