Actual Operation Process and precautions for JIRA + MySQL Configuration

The following article mainly describes the actual operation process of JIRA + MySQL configuration and the sample code used in actual operations, there are also descriptions of the things that deserve our attention in actual operations. The following is a detailed description of the article. I hope you will gain some benefits.

1. After JDK, JIRA, and MySQL are installed, stop the JIRA service.

Create a database:

 
 

  
  
mysql  
  
  
create database jiradb character set ‘UTF8′; 
 
 

Create a user and grant permissions:

 
 

  
  
create user jirauser identified by ‘jira’;  
  
  
grant all privileges on *.* to ‘jirauser’@'%’ identified by ‘jira’ with grant option;  
  
  
grant all privileges on *.* to ‘jirauser’@'localhost’ identified by ‘jira’ with grant option;  
  
  
flush privileges; 
 
 

2. Modify the JIRA Port

JIRA is integrated on Tomcat, so the method for modifying the port is the same as that for modifying the port of Tomcat.

3. The default database used by JIRA is HSql. to migrate data to MySQL, use the following JIRA + MySQL configuration changes.

1) Modify server. xml (Path:/jira/conf/server. xml)

Row 3:

 
 

  
  
Username = "jirauser"
  
  
Password = "780824 ″
  
  
DriverClassName = "com. mysql. jdbc. Driver"
  
  
Url = "jdbc: mysql: // localhost: 3306/jiradb? AutoReconnect = true & amp; useUnicode = true & amp; characterEncoding = UTF8 ″
  
  
(Delete the minEvictableIdleTimeMillis and timeBetweenEvictionRunsMillis item)
  
  
MaxActive = "20 ″
  
  
ValidationQuery = "select 1"/>
 
 

Note: The above "localhost" can be changed to the host name or "Host IP: Port", and the mysql port number is "3306".

B. Modify entityengine. xml (Path:/jira/atlassian-jira/WEB-INF/classes/entityengine. xml)

Change row 100th:

 
 

  
  
<Datasource name = "defaultDS" field-type-name = "mysql"
  
  
Delete schema-name = "PUBLIC"
 
 

4. Install the connection Driver package Mysql JDBC Driver

 
 

  
  
cp mysql-connector-java-5.1.7-bin.jar /jira/common/lib/ 
 
 

5. Start the JIRA service.

Now the JIRA database is MySQL.

If you want to go further, add the MySQL service to the dependent service of the JIRA service, you can update it in the registry.

 
 

  
  
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\JIRA240209102746 
 
 

Because the JIRA service name is too long and the name is randomly generated in the registry, add a DependOnService multi-text key value in the base and add the MySQL service name.

The result is that JIRA depends on MySQL. JIRA is started after MySQL is started. If MySQL is stopped, JIRA is stopped before MySQL.

The above content is an introduction to JIRA + MySQL configuration. I hope you will have some gains.

Original article title: JIRA + MySQL Configuration

Connection: http://www.cnblogs.com/gaotianle/archive/2009/10/27/1590659.html