JIRA - MySQL/MariaDB 한글 설정

아틀라시안 JIRA를 활용하여 데이터베이스 연결을 하는 경우 MySQL/MariaDB를 활용할 수 있습니다.

이 때 DB 연결 설정을 진행해야 하는데, 우선 MySQL의 한글 및 연결을 위한 세팅은 아래와 같습니다.

[mysqld]

max_connections = 500

wait_timeout = 60

init_connect=SET collation_connection = utf8_general_ci

init_connect=SET NAMES utf8

character-set-server=utf8

collation-server=utf8_general_ci

MySQL/MariaDB를 재시작시킵니다.

<?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;useUnicode=true&amp;characterEncoding=UTF-8&amp;sessionVariables=storage_engine=InnoDB</url>

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <username>jira</username>

    <password>jira</password>

    <pool-min-size>20</pool-min-size>

    <pool-max-size>20</pool-max-size>

    <pool-max-wait>30000</pool-max-wait>

    <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-max-idle>20</pool-max-idle>

    <pool-remove-abandoned>true</pool-remove-abandoned>

    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

    <pool-test-while-idle>true</pool-test-while-idle>

    <validation-query-timeout>3</validation-query-timeout>

  </jdbc-datasource>

</jira-database-config>

dbconfig의 설정은 다음과 같습니다.

문제:  만약 설정 후 "You are using an unsupported mysql collation: latin1_swedish_ci"메시지가 나온다면?

해결방법: 

  mysql> use jira;

  mysql> alter database character set utf8 collate utf8_bin;