mysql
create database jiradb character set utf8;
grant all privileges on jiradb.* to jirauser@localhost identified by 'mypassword' with grant option;
flush privileges;
quit
测试是否成功 用jirauser用户手动登陆试试
第四步:安装MYSQL/J JDBC 驱动
作用就是让JAVA可以通过JDBC连接MYSQL
下载: http://dev.mysql.com/downloads/connector/j/5.1.html
JDBC下载要跟你的MYSQL基本相同 mysql 5.0选择5.0的驱动 依以类推
wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.8.tar.gz/from/ftp://ftp.jaist.ac.jp/pub/mysql/
tar zxvf mysql-connector-java-5.0.8.tar.gz
cp mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /home/jira/common/lib
第五步:修改JIRA配置
修改一、
vim /home/jira/conf/server.xml
修改成如下几项
username="jirauser"
password="mypassword"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/jiradb? autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
删除以下两行
minEvictableIdleTimeMillis="4000"
timeBetweenEvictionRunsMillis="5000"
修改二、
vim /home/jira/atlassian-jira/WEB_INF/classes/entityengine.xml
将其中的hsql改成mysql 数据库类型<datasource name="defaultDS" field-type-name="hsql"
<datasource name="defaultDS" field-type-name="mysql"
删除 schema-name="PUBLIC"
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
3. Run bin/startup.sh (*nix) or bin\startup.bat (Windows). Check that there
are no errors on the console. See below for troubleshooting advice.
问题A、main ERROR [jira.appconsistency.db.DatabaseConsistencyCheck] There was a SQL exception checking for database driver correctness. Skipping
2009-07-14 17:12:57,743 main ERROR [core.entity.jdbc.DatabaseUtil] Unable to esablish a connection with the database… Error was:org.apache.tomcat.dbcp.dbcp.SQLNestedExceptio
n: Cannot load JDBC driver class ‘org.mysql.jdbc.Driver’
问题C:rg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Server connection failure during transaction. Due to underlying exception: ‘java.sql.SQLException: Access denied for user ‘jirauser’@'127.0.0.1′ (using password: YES)’.