当前位置：服务支持 > 软件文章 > JIRA Standalone连接MySQL数据库的配置教程

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

阅读数 4105

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.

, , ,

武汉格发信息技术有限公司，格发许可优化管理系统可以帮你评估贵公司软件许可的真实需求，再低成本合规性管理软件许可,帮助贵司提高软件投资回报率，为软件采购、使用提供科学决策依据。支持的软件有: CAD,CAE,PDM,PLM,Catia,Ugnx, AutoCAD, Pro/E, Solidworks ,Hyperworks, Protel,CAXA,OpenWorks LandMark,MATLAB,Enovia,Winchill,TeamCenter,MathCAD,Ansys, Abaqus,ls-dyna, Fluent, MSC,Bentley,License,UG,ug,catia,Dassault Systèmes,AutoDesk,Altair,autocad,PTC,SolidWorks,Ansys,Siemens PLM Software,Paradigm,Mathworks,Borland,AVEVA,ESRI,hP,Solibri,Progman,Leica,Cadence,IBM,SIMULIA,Citrix,Sybase,Schlumberger,MSC Products...

返回上级列表