Uploaded image for project: 'Crowd'
  1. Crowd
  2. CWD-3882

Add unique constraint on columns external_id and directory_id

          Details

          • Type: Improvement
          • Status: Open
          • Priority: Medium
          • Resolution: Unresolved
          • Affects Version/s: None
          • Fix Version/s: None
          • Component/s: None
          • Labels:
            None

            Description

            In the table cwd_user, there should be no rows where the external_id is repeated for the same directory_id. Said in another way, the external_id should be unique for the same directory_id.

            To avoid this from causing problems, we should add a unique constraint at a database level in the table cwd_user.

            When two users share external_id and directory_id, the user is not able to login or update new information from the external user directory. Those actions will fail with the following error:

            org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
        at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590)
        at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUserByExternalId(HibernateUserDao.java:501)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByExternalId(HibernateUserDao.java:473)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByExternalId(HibernateUserDao.java:449)
        at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId(CachedCrowdUserDao.java:164)
...

            This also affects embedded Crowd.

              Attachments

                Issue Links

                is related to

                Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

                • Medium - Medium priority issues
                • Resolved

                Bug - A problem which impairs or prevents the functions of the product. CWD-3984 Rename user in external directory create new user with same external_id

                • Medium - Medium priority issues
                • Resolved
                relates to

                Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22515 After change an username in Active Directory and resynchronize, there are two accounts showing in Confluence (the old and the new username).

                • Medium - Medium priority issues
                • Resolved

                New Feature - A new feature of the product, which has yet to be developed. CWD-1133 Provide ability to rename users in Crowd.

                • Medium - Medium priority issues
                • Resolved
                is blocked by

                KRAK-615 Loading...

                links to

                Web Link CSP-126414

                  Activity

                    People

                    • Votes:
                      7 Vote for this issue
                      Watchers:
                      16 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Last commented:
                        33 weeks, 6 days ago