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

    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 (Inactive)
            Participants of an Issue:
            Recent user:
            Rafaela Nascimento
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Days since last comment:
              1 year, 6 weeks, 6 days ago

                Packages

                Version Package