Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-14240

Data too long for column 'XWS_VALUE' issue when saving the ldap fields mapping

    Details

    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      The issue appears when I try to save a big list of LDAP fields mappings because the property (ldap_fields_mapping) used to save the fields mappings on the XWiki.XWikiPreferences object is a String property, so an error is returned when we try to save a string longer than the property limits.

      A better solution is to change the type of the property 'ldap_fields_mapping' to text like the ldap group mapping field.

      To reproduce

      • Install LDAP Application 9.2.3
      • Open the LDAP configuration form on Administration>>LDAP
      • On 'Mapping Of the fields of the LDAP users' add the values below and click on the save button

      first_name=givenName
      last_name=sn
      email=mail
      xxxxxx1=yyyyyyyyyyyyyyyyyyy1
      xxxxxxxx2=yyyyyyyyyyyyyyyyyy2
      xxxxx3=yyyyyyyyyyyyyyyyyy3
      xxxxx4=yyyyyyyyyyyyyyyyyy4
      xxxxx5=yyyyyyyyyyyyyyyyyy5
      xxxxx6=yyyyyyyyyyyyyyyyyy6
      xxxxx7=yyyyyyyyyyyyyyyyyy7
      xxxxx8=yyyyyyyyyyyyyyyyyy8

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                mouhb Mohamed Boussaa
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: