upgrade jira 9.3 mysql 5.7 can not connect

[bowen chen]

dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql57</database-type>
<jdbc-datasource>
<url>jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&amp;characterEncoding=UTF8&amp;sessionVariables=default_storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>jiradbuser</username>
<password>password</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>

<pool-test-while-idle>true</pool-test-while-idle>
<pool-test-on-borrow>false</pool-test-on-borrow>
<validation-query-timeout>3</validation-query-timeout>
</jdbc-datasource>
</jira-database-config>

issue description：

i upgrade jira 8 to 9.3.0

if i change dbconfig.xml <database-type>mysql57</database-type> to 

<database-type>mysql</database-type>

error "Database: We've found an error in MySQL supported version!" will disappear

but error can not connect mysql still there

[Fabio Racobaldo _Catworkx_]

Hi @bowen chen ,

welcome to the Atlassian community!

Please could you verify version of your MySQL server version?

Fabio

[bowen chen]

Server version: 5.7.40-log MySQL Community Server (GPL)

[bowen chen]

dbname:jira

dbuser:jira

[Fabio Racobaldo _Catworkx_]

Please verify lib connector jar that you have il JIRA-INST lib folder.

[bowen chen]

you mean this ?

[root@cbw-jira-test1 lib]# ll | grep connector
-rw-r--r--. 1 root root 1006959 1月 11 08:20 mysql-connector-java-5.1.48-bin.jar
[root@cbw-jira-test1 lib]# pwd
/opt/atlassian/jira/atlassian-jira/WEB-INF/lib

[Fabio Racobaldo _Catworkx_]

Hi @bowen chen ,

lib seems ok. Btw, based on https://confluence.atlassian.com/adminjiraserver0903/supported-platforms-1167688915.html JIRA9.3 doesn't support MySQL 5.7 and it means that you need to upgrade your MySQL to 8.0.

Fabio

[bowen chen]

thanks , in  8.0 plan upgrade health check ,mysql 5.7 has passed the check.So there made a misunderstanding .i will upgrade my database

[JBennett]

Are there any instructions for updating the database to MySQL 8.x? I'm currently using Jira 9.1 and MySQL 5.7 so cannot upgrade Jira to a newer version until MySQL is updated.

The online documentation I've found hasnt helped with this task. Thanks