{{tag>atlassian jira}}

====== Jira troubleshooting ======
If there are problems with displaying non-english characters (čćšđž..) change the database to mysql and set correct encoding. Jira container by default uses h2db which is a java DB.

===== Run mysql docker container =====

   docker run --name mysql-jira -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=jira -d mysql:5.7

===== Download mysql connector =====

   wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.20.tar.gz

===== Unzip the file and copy jar to container =====

   docker cp mysql-connector-java-8.0.20.jar jira-container:/opt/atlassian/jira/lib

===== Restart container =====

   docker restart jira-container

===== Enter container and change db connection =====

Locate the dbconfig.xml file at the root of your JIRA home directory, the default locations are:

///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.

====== See also ======
[[wiki:confluence_troubleshooting|Confluence troubleshooting]]

====== References ======
  * https://confluence.atlassian.com/jirakb/jira-service-desk-internationalization-675188939.html
  *     https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html
  *     https://confluence.atlassian.com/jirakb/change-mysql-connection-url-for-jira-server-874744240.html