Connecting to JIRA 4.2 or Earlier for User Management

Atlassian JIRA is an issue and project tracking tool. Like Confluence, JIRA offers the ability to store its users and groups in its database. You can configure Confluence to look for its users and groups in the JIRA database. This page describes the legacy JIRA database connector, which provides a direct connection to the JIRA database.

When to use this option: Choose the legacy JIRA database connector if your JIRA server is JIRA 4.2 or earlier, for backwards compatibility with the already-existing option for Confluence to use JIRA for user management.

If you are using JIRA 4.3 or later, you cannot use the legacy JIRA database connector. Instead, choose the 'Atlassian JIRA' directory type.

On this page:

Connecting Confluence to JIRA

To connect Confluence to JIRA 4.2 or earlier:

  1. Edit the Confluence server.xml file, to construct the datasource location, as described below.
  2. Restart Confluence.
  3. Choose the cog icon , then choose General Configuration under Confluence Administration.
  4. Click User Directories in the left-hand panel.
  5. Add a directory and select type Legacy Atlassian JIRA (4.2 and earlier). Enter the settings as described below.
  6. Save the directory settings.
  7. Define the directory order by clicking the blue up- and down-arrows next to each directory on the 'User Directories' screen. Here is a summary of how the directory order affects the processing:
    • The order of the directories is the order in which they will be searched for users and groups.
    • Changes to users and groups will be made only in the first directory where the application has permission to make changes.
    For details see Managing Multiple Directories.
  8. In order to use Confluence, users must be a member of the confluence-users group or have Confluence 'can use' permission. Follow these steps to configure your Confluence groups in your JIRA application:
    1. Add the confluence-users and confluence-administrators groups in your JIRA application.
    2. Add your own username as a member of both of the above groups.
    3. Choose one of the following methods to give your existing JIRA users access to Confluence:
      • Option 1: In your JIRA application, find the groups that the relevant users belong to. Add the groups as members of one or both of the above Confluence groups.
      • Option 2: Log in to Confluence using your JIRA account and go to the Confluence Administration Console. Click 'Global Permissions' and assign the 'can use' permission to the relevant JIRA groups.

JIRA Settings in Confluence

Setting

Description

Name

A meaningful name that will help you to identify this JIRA server amongst your list of directory servers. Examples:

  • JIRA
  • Example Company JIRA

Datasource Location

The JNDI name of the JIRA datasource configured in your application server. Example:
java:comp/env/jdbc/YourJiraDatasource

In JIRA standalone distributions (using the default application server, Tomcat 6) you can construct the datasource location as follows:

  1. Open your <jira_install>/conf/server.xml file in a text editor.
  2. Look for the database setup section in that file. It looks something like this:

    <Resource auth="Container"
    driverClassName="com.mysql.jdbc.Driver"
    maxActive="20"
    name="*jdbc/JiraDS*"
    password="jirauser"
    type="javax.sql.DataSource"
    url="jdbc:mysql://localhost/jiradb?useUnicode=true&characterEncoding=UTF8"
    username="jirauser"
    validationQuery="select 1"/>
    
  3. Copy the above lines (the 'Resource' section) and paste it to your Confluence's server.xml file (located at <confluence_install>/conf/server.xml), under the Context path. This will then expose the value of the name attribute as the JNDI resource locator.
  4. Copy the JNDI name from the name parameter. In this example, the datasource location is:
    java:comp/env/jdbc/JiraDS

RELATED TOPICS

Configuring User Directories

Was this helpful?

Thanks for your feedback!

Why was this unhelpful?

Have a question about this article?

See questions about this article

Powered by Confluence and Scroll Viewport