JIRA_3.13.2_Standalone + mysql 配置（Linux）

准备：安装JDK、Mysql

 

1. 从 http://www.atlassian.com/software/jira下载JIRA 3.13.2 Enterprise - Standalone，tar解压 %JIRA%表示JIRA所在的目录

 

2. Mysql 创建数据库和用户

 

mysql> create database jiradb as utf8;
Query OK, 1 row affected (0.02 sec)

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on
  jiradb.* TO 'jirauser'@'localhost' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye


3. 复制 mysql-connector-java-3.0.10.jar 到 %JIRA%/common/lib 

4. 修改 %JIRA% /conf/server.xml 文件

        <Context path="" docBase="${catalina.home}/atlassian-jira" reloadable="false">
          <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
            username="jirauser"
            password="mypassword"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost/jiradb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8"
            maxActive="20" 
	validationQuery="select 1"/>

5. 修改 %JIRA% /atlassian-jira/WEB-INF/classes/entityengine.xml


    <datasource name="defaultDS" field-type-name="mysql"
      helper-class="org.ofbiz.core.entity.GenericHelperDAO"
      check-on-start="true"
      use-foreign-keys="false"
      use-foreign-key-indices="false"
      check-fks-on-start="false"
      check-fk-indices-on-start="false"
      add-missing-on-start="true"
      check-indices-on-start="true">

6. 运行 %JIRA% /bin/startup.sh 启动 JIRA


参考： http://www.atlassian.com/software/jira/docs/v3.6/mysql-guide-linux.html