JIRA Standalone连接MySQL数据库的配置教程

1. Configure MySQL,1. Create a database user which JIRA will connect as (e.g. jirauser). ,2. Create a database for JIRA to store issues in (e.g. jiradb). ,The database must have a character set of UTF8. Enter the following command from within the MySQL command client: ,

create database jiradb character set utf8;

,(if you want your database to be named jiradb). ,3. Ensure that the user has permission to connect to the database, and create and populate tables. , , ,2. Copy the MySQL driver to your application server,1. Download the MySQL Connector/J JDBC driver, eg. version 3.1.12 ( tar.gz or zip) which we have verified to work. NOTE: the older 3.1.11 driver is broken.,2. Add the MySQL JDBC driver jar (mysql-connector-java-3.x.x-bin.jar) to the common/lib/ directory. NOTE: Do not place the Debug Driver (mysql-connector-java-3.x.x-bin-g.jar) on the CLASSPATH as this can cause issues ( JRA-8674). , ,3. Configure your application server to connect to MySQL,1. Edit conf/server.xml (if you are using JIRA Standalone) and customise the username, password, driverClassName and url parameters for the Datasource. (If you are using JIRA WAR/EAR, edit the appropriate file on your application server; e.g. for Tomcat, edit conf/Catalina/localhost/jira.xml.),

<Context path="" docBase="${catalina.home}/atlassian-jira" 1.

  reloadable="false">1.

  <Resource name="jdbc/JiraDS" auth="Container" 1.

   type="javax.sql.DataSource"1.

      username="[enter db username]"1.

      password="[enter db password]"1.

      driverClassName="com.mysql.jdbc.Driver"1.

      url="jdbc:mysql://localhost:3306/jiradb?autoReconnect=true1.

     &amp;useUnicode=true&amp;characterEncoding=UTF8"1.

            [ Jiradb：前面为Jira创建的数据库名称 ]1.

            [ delete the minEvictableIdleTimeMillis and 1.

      timeBetweenEvictionRunsMillis params here ]1.

            />1.

            <Resource name="UserTransaction" auth="Container" 1.

            type="javax.transaction.UserTransaction" 1.

            factory="org.objectweb.jotm.UserTransactionFactory" 1.

            jotm.timeout="60"/>1.

          <Manager className="org.apache.catalina.1.

         session.PersistentManager" saveOnRestart="false"/>1.

        </Context>1.

, , ,4. Configure the JIRA Entity Engine,Edit atlassian-jira/WEB-INF/classes/entityengine.xml (if you are using JIRA Standalone) or edit-webapp/WEB-INF/classes/entityengine.xml (JIRA WAR/EAR), and change the field-type-name attribute to mysql. (If you forget to do this and start JIRA, it may create database tables incorrectly. See this page if this happens to you.) Also delete the schema-name="PUBLIC" attribute, if it exists, ,

<datasource name="defaultDS" field-type-name="mysql"1.

      [ delete this, if it exists: schema-name="PUBLIC" ]1.

      helper-class="org.ofbiz.core.entity.GenericHelperDAO"1.

      check-on-start="true"1.

      use-foreign-keys="false"1.

, , ,

返回上级列表

请

联系我们

，获取更多内容

< 上一篇: Linux下Jira的安装与配置全面指南

下一篇: Linux部署Jira与MySQL的详细步骤 >

相关推荐

jira standalone连接mysql数据库的配置教程

mysql5.7数据库安装指南：InnoDB存储引擎优化配置

mysql双主高可用：VIP漂移与连接池配置

mysql 8.0官方安装教程：数据库入门实用篇

GPLv3草案前瞻：mysql数据库授权模式调整

mysql数据库常用命令速查手册

mysql远程连接：bind-address参数详解

mysql远程连接三部曲：用户授权与bind-address调整‌

CentOS mysql远程访问配置：bind-address与防火墙放行‌

mysql远程访问配置：防火墙规则与用户权限管理

技术文档

企业许可管理新篇章：从减少用户浪费到全面优化

许可资源的高效整合：企业许可优化的必经之路

用户许可浪费的根源剖析：企业如何对症下药

多模块许可的合规使用：企业许可管理的核心要点

企业许可管理升级：减少用户浪费，提升资源利用率

许可闲置浪费的解决方案：企业许可管理新思路

软件下载