Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-134963

Specific attribute mapping blocks login to SP for all users

    Details

    • Fix Priority:
      2

      Description

      Requirement:
      Have an already working SAML link between and IdP and an SP, with a user present in both!

      Steps to reproduce:

      1. On IdP side make sure digest is sent, but firstName is not sent towards SP
      2. On SP side enter the following mapping: User Field Expression is firstName, SAML attribute is digest
      3. Try to log in to SP with any of the users

      Actual result:
      User is denied of entry, gets redirected to SP landing page, with warning pop-up. Portal throws SQLException

      Expected result:
      User can log in and user's first name is updated with digest value

      Reproduced on:
      Tomcat 9.0.43 + MySQL 8.0.25 | Portal master DXP GIT ID: fa392694486a70c3eb29f5e2d47ea7f1d01480f4

      Print screen of the warning is attached!
      Exception:

      2021-06-30 16:04:39.096 DEBUG [http-nio-8080-exec-1][DefaultUserResolver:386] Updating user 46742 with attributes map {lastName=[Sigvartsen, updatedJobTitle], firstName=[6d0012355176af07f1a9fa596037fae6,0abfc1ba9d6c9c1e9353e7ddee4e3e40,b22ed0e35fe59f44bc6bb08de65fad0e], emailAddress=[[email protected]], middleName=[1], screenName=[user], userId=[46713]}
      2021-06-30 16:04:39.103 ERROR [http-nio-8080-exec-1][JDBCExceptionReporter:234] Data truncation: Data too long for column 'firstName' at row 1
      2021-06-30 16:04:39.104 DEBUG [http-nio-8080-exec-1][WebSsoProfileImpl:213] com.liferay.portal.kernel.exception.PortalException: org.springframework.dao.DataIntegrityViolationException: could not update: [com.liferay.portal.model.impl.UserImpl#46742]; SQL [update User_ set mvccVersion=?, modifiedDate=?, firstName=? where userId=? and mvccVersion=?]; nested exception is org.hibernate.exception.DataException: could not update: [com.liferay.portal.model.impl.UserImpl#46742]
      com.liferay.portal.kernel.exception.PortalException: org.springframework.dao.DataIntegrityViolationException: could not update: [com.liferay.portal.model.impl.UserImpl#46742]; SQL [update User_ set mvccVersion=?, modifiedDate=?, firstName=? where userId=? and mvccVersion=?]; nested exception is org.hibernate.exception.DataException: could not update: [com.liferay.portal.model.impl.UserImpl#46742]
      	at com.liferay.saml.opensaml.integration.internal.processor.BaseProcessorImpl._consumePatches(BaseProcessorImpl.java:334) ~[bundleFile:?]
      

      cc:Zsigmond Rab

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              ferenc.onodi Ferenc Onodi
              Participants of an Issue:
              Recent user:
              Nóra Szél
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Days since last comment:
                16 weeks, 2 days ago

                  Packages

                  Version Package