1、安装MYSQL数据库,本文假定安装目录是d:\mysql
2、在MYSQL中创建数据库
开始 -> 运行->输入cmd,按确定打开dos窗口
在命令行下输入
c:\>d:
d:\>cd d:\mysql\bin
d:\mysql\bin>mysql -uroot -p
Enter password: //第一安装没有密码,可直接回车
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 5.0.0-alpha-n
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database jira;
mysql> use jira;
mysql> show tables;
mysql> exit;
3、解压jira企业版到硬盘中,本文假定存放目录为d:\jira3.6.4
打开文件 D:\jira3.6.4\edit-webapp\WEB-INF\classes\entityengine.xml,修改之
段落1
原文
helper-class="org.ofbiz.core.entity.GenericHelperDAO"
field-type-name="hsql"
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">
jndi-name="java:comp/env/jdbc/JiraDS" />
修改文
helper-class="org.ofbiz.core.entity.GenericHelperDAO"
field-type-name="mysql"
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">
jndi-name="java:comp/env/jdbc/JiraDS" />
段落2
原文
修改文
4、编译jira
d:\mysql\bin>cd\
d:\>cd jira3.6.4
d:\jira3.6.4>build
5、拷贝配置文件
将D:\jira3.6.4\dist-tomcat\tomcat-5.5\jira.xml 文件拷贝到%TOMCAT_HOME%\conf\Catalina\localhost中,本文作者的TOMCAT_HOME为D:\apache-tomcat-5.5.15\
修改如下:
原文:
username="sa"
password=""
driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:D:\jira3.6.4/database/jiradb"
minEvictableIdleTimeMillis="4000"
timeBetweenEvictionRunsMillis="5000"/>
修改文
username="root"
password=""
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/jira?useUnicode=true"
minEvictableIdleTimeMillis="4000"
timeBetweenEvictionRunsMillis="5000"/>
6、修改TOMCAT配置文件:server.xml
原文
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true"/>
修改文
maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" useBodyEncodingForURI="true"/>
7、拷贝jira下的tomcat架包
解压jira-jars-tomcat5.zip,将其中的jar文件拷贝到%TOMCAT_HOME%\common\lib下
8、拷贝mysql的jdbc驱动包到tomcat的%TOMCAT_HOME%\common\lib下
9、启动tomcat,打开ie在地址栏中输入http://localhost:8080/jira
备注:
遇到过如下问题:
执行tomcat的启动文件startup.bat失败
解决办法,在环境变量中添加tomcat变量,变量名:CATALINA_HOME,值:D:\apache-tomcat-5.5.15