Uploaded image for project: 'Confluence Server'
  1. Confluence Server
  2. CONFSERVER-26895

Confluence creates a USERINFO for all users from JIRA

    XMLWordPrintable

    Details

      Description

      When using a JIRA user directory, Confluence creates a USERINFO in the table content for all users, whether they have permissions to use Confluence or not. Only users with have (or may be had) can use permission should have a profile Confluence.

      If you have a big user base in JIRA and only a few have the right to use Confluence, this can be annoying as all users will appear in the people directory or in mentions.

      Workaround:

      1. Shutdown Confluence.
      2. In your database server, run the following query to identify the id of your JIRA user directory:
        delete from content where contenttype='USERINFO' and username in (
        SELECT DISTINCT
            (users.lower_user_name)
        FROM
            cwd_user users
        JOIN
            cwd_directory userdir
        ON
            users.directory_id=userdir.id
        WHERE
            userdir.id=<ID_from_step_#2>
        AND users.lower_user_name NOT IN
                                  (
                                  SELECT DISTINCT
                                      lower(permusername)
                                  FROM
                                      SPACEPERMISSIONS
                                  WHERE
                                      permtype='USECONFLUENCE')
        OR  users.lower_user_name NOT IN
            (
                SELECT
                    u.lower_user_name
                FROM
                    cwd_user u
                JOIN
                    cwd_directory d
                ON
                    u.directory_id = d.id
                JOIN
                    cwd_membership m
                ON
                    u.id = m.child_user_id
                JOIN
                    cwd_group g
                ON
                    g.id = parent_id
                JOIN
                    SPACEPERMISSIONS sp
                ON
                    g.lower_group_name =lower(sp.permgroupname)
                WHERE
                    permtype='USECONFLUENCE' )
        AND users.active='T'
        AND userdir.active='T');
        
      3. Start Confluence
      4. Long in to Confluence and rebuild your search index:
        1. Go to Browse > Confluence Admin.
        2. Click on Content Indexing on the left-hand side menu, under the heading Administration.
        3. Click on Rebuild in your Search Index panel.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              richatkins Richard Atkins
              Reporter:
              aconde Alejandro Conde Carrillo (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: