Hello,
Could you please help me.
I try to migrate Jira from H2 to MySQL.
I have the following programms:
- Atlassian Jira Project Management Software v7.11.2#711002
- mysql 5.7.24
- mysql-connector-java-8.0.13.jar
- java version "1.8.0_102"
After start Jira puts in log a message that it "cannot connect to database". It seems that there is an error in my dbconfig.xml (find the content of file below).
Could you please verify whether it is correct or not and, perhaps, provide me with correct one.
Thanx in advance!
====================================================
<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql</database-type>
<jdbc-datasource>
<url>jdbc:mysql://localhost:3306/jira?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB</url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<username>jira_user</username>
<password>mypass</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>
