Change MySQL connection URL for Jira server
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Depending on your version of MySQL, you may need to change the storage engine parameter specified in your dbconfig.xml file. The following is seen on the logs:
1
JIRA-Bootstrap WARN [c.a.j.appconsistency.db.MySqlConnectionUrlCheck] You have an error in your dbconfig.xml file. Missing "default_storage_engine" in connection url. The "storage_engine" parameter is deprecated and should be replaced with "default_storage_engine"⚠️ This should only be required if you've upgraded your MySQL database, and tried to use an existing dbconfig.xml file. The dbconfig.xml file (located at the root of your JIRA home directory) defines all details for JIRA's database connection. This file is typically created by running the JIRA setup wizard on new installations of JIRA, or by configuring a database connection using the JIRA configuration tool.
The storage engine parameter should be:
storage_engine- for versions of MySQL below 5.7default_storage_engine- for versions of MySQL of 5.7 and above⚠️ Make sure the JDBC driver is upgraded to the latest version!⚠️
Expand for the full connection URL...
For versions of MySQL below 5.7
1
jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDBFor versions of MySQL of 5.7 and above
1
jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDBTo edit your dbconfig.xml file:
Locate the dbconfig.xml file at the root of your JIRA home directory, the default locations are:
C:\Program Files\Atlassian\Application Data\JIRA(on Windows) or/var/atlassian/application-data/jira(on Linux)
Open the file in a text editing program.
Change the storage engine parameter to the appropriate value.
Save the file.
You should now be able to start JIRA.
For further details on setting up Jira with MySQL 5.7 please see Connecting Jira applications to MySQL 5.7
Was this helpful?