Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-70071

Jira Docker image with MySQL adds a schema name in dbconfig.xml breaking the connection to the database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • None
    • 8.4.2
    • Installation
    • None

    Description

      Issue Summary

      Running a docker image with MySQL, the dbconfig will have the schema name tag:

      <schema-name>public</schema-name>
      

      Environment

      Docker Setup
      Jira 8.4.2

      Steps to Reproduce

      1. Run docker with MySQL. Example:
        docker run -v jiraVolume:/var/atlassian/application-data/jira --name="jira" -d -p 8080:8080 -e "ATL_JDBC_URL=jdbc:mysql://192.168.1.0:3306/jiradb" -e "ATL_JDBC_USER=username" -e "ATL_JDBC_PASSWORD=password" -e "ATL_DB_DRIVER=com.mysql.jdbc.Driver" -e "ATL_DB_TYPE=mysql" atlassian/jira-software:8.4.2
        
      2. Once this is up, check the dbconfig.xml

      Expected Results

      This should be as per Connecting Jira applications to MySQL 5.7 without a Schema Name.

      Actual Results

      There is a line in the dbconfig.xml that has a schema name:

      <schema-name>public</schema-name>
      

      Workaround

      Manually remove this line.

      Attachments

        Issue Links

          Activity

            People

              dchevell Dave Chevell
              mriza Mohamed Riza (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: