幸せのちから

???? 昨天轉載了Judy Shen的《使用JIRA搭建企業問題跟蹤系統》，在這篇文章中Jude Shen著重講解了JIRA的特性和常用的設置。但是對于安裝卻沒有提及，在本人實際安裝JIRA的過程中，出現了一些問題，雖然最終解決但是花費了本人一下午的時間。為了幫助大家順利安裝，今天本人把安裝的過程重新梳理一遍，請特別留意紅色字體的部分。

1. ???? 安裝JDK(JDK1.4.2以上)，配置JAVA_HOME，安裝Mysql(本人使用的版本是5.0.19)，安裝tomcat(5.0.28)
   
2. ? ?? 下載JIRA: 本人下載的版本為----3.6 Enterprise EAR/WAR的Zip文件
3. ? ? ? 解壓縮JIRA，編輯解壓縮目錄\edit-webapp\WEB-INF\classes\entityengine.xml文件，原文件定義使用hsql(紅色字體為增加部分)：??
   
4. ??? <transaction-factory class="org.ofbiz.core.entity.transaction.JNDIFactory">
   ????? <user-transaction-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/>
   ????? <transaction-manager-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/>
   ??? </transaction-factory>
5. ? ? 原來的field-type-name="hsql"，改為“mysql”
   
6. ???? <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">
   ??????? <jndi-jdbc jndi-server-name="default" jndi-name="java:comp/env/jdbc/JiraDS"/>
7. ???? 修改完entityengine.xml文件的上述兩個地方后，執行加壓縮目錄下的build加壓縮目錄下的build.bat將默認地生成JIRA的war包
8. ???? 下載mysql-connector-java-3.1.12-bin.jar拷貝到Tomcat安裝目錄的\common\lib下，請特別注意版本號必須為3.1.12
9. ???? 從Atlassian下載jira-jars-tomcat5.zip拷貝到Tomcat安裝目錄的\common\lib下

? 10. ?? 配置Tomcat安裝目錄conf/server.xml,增加?

useBodyEncodingForURI="true"

<Connector?port="8080"
????maxThreads="150"?minSpareThreads="25"?maxSpareThreads="75"
????enableLookups="false"?redirectPort="8443"?acceptCount="100"
????debug="0"?connectionTimeout="20000"
????disableUploadTimeout="true"?useBodyEncodingForURI="true"/>

? 11.?? 創建數據庫(我命名為jiradb,使用utf8編碼)
? 12.?? 創建數據庫的使用用戶(jirauser)
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on
? jiradb.* TO 'jirauser'@'localhost' IDENTIFIED BY 'mypassword';
? 13.? 拷貝dist-tomcat目錄下的war包拷貝到tomcat安裝目錄下的webapps/目錄下，拷貝dist-tomcat/tomcat-5/jira.xml到tomcat安裝目錄下/conf/Catalina/localhost/ 并修改該該文件
?????? 刪除下列配置(適用于hsqldb)

 <!-- NOTE: If NOT using hsqldb, delete the next two parameters -->
    <!-- Give unused connections 4 secs before eviction. -->
    <parameter>
      <name>minEvictableIdleTimeMillis</name>
      <value>4000</value>
    </parameter>
    <!-- Check for evictions every 5 secs. -->
    <parameter>
      <name>timeBetweenEvictionRunsMillis</name>
      <value>5000</value>
    </parameter>
修改后的jira.xml文件如下：
<!--
A?sample?configuration?file?for?Tomcat?4.1.x?and?5.0
Customize?the?docBase?attribute,?drop?in?your?$CATALINA_HOME/webapps/?(4.1.x)?or
$CATALINA_HOME/conf/Catalina/localhost/?(5.0)?directory?and?restart?Tomcat.
Note?the?JOTM?dependencies;?you'll?need?to?copy?various?jars?to?Tomcat's?common/lib/?directory.
See?http://www.atlassian.com/software/jira/docs/latest/servers/tomcat41.html?for?details.
-->
?
<Context?path="/jira"?docBase="C:\usr\Apache\Tomcat5\webapps\jira"?debug="0">
??<Resource?name="jdbc/JiraDS"?auth="Container"?type="javax.sql.DataSource"/>
??<ResourceParams?name="jdbc/JiraDS">
????<parameter>
??????<name>driverClassName</name>
????????<!--?NOTE:?if?you?change?the?database?type,?you?will?need?to?change?it?in?WEB-INF/classes/entityengine.xml?-->
??????<value>com.mysql.jdbc.Driver</value>
????</parameter>
????<parameter>
??????<name>url</name>
??????<value>jdbc:mysql://localhost/jiradb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8&amp;mysqlEncoding=utf8</value>
????</parameter>
????<parameter>
??????<name>username</name>
??????<value>jirauser</value>
????</parameter>
????<parameter>
??????<name>password</name>
??????<value>mypassword</value>
????</parameter>
?????<parameter>
??????<name>factory</name>
??????<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
????</parameter>
?</ResourceParams>

??<Resource?name="UserTransaction"?auth="Container"?type="javax.transaction.UserTransaction"/>
??<ResourceParams?name="UserTransaction">
????<parameter>
??????<name>factory</name>
??????<value>org.objectweb.jotm.UserTransactionFactory</value>
????</parameter>
????<parameter>
??????<name>jotm.timeout</name>
??????<value>60</value>
????</parameter>
??</ResourceParams>
</Context>
14. 啟動tomcat，敲入http://.../jira，應該就能看到JIRA的配置向導了
                  （全文完）