can`t connect db

[Anton Kuharev]

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&amp;characterEncoding=UTF8&amp;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>

[Gonchik Tsymzhitov]

Hi! 

Could you connect from your server console to the database? 

mysql -u jira_user  jira

Than you can understand can you connect it? 

Cheers,

Gonchik Tsymzhitov

[Anton Kuharev]

Hi!

that's what I tried:

=====================

alex@jira:~# mysql -u jira_user jira -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>