Uploaded image for project: 'LDAP'
  1. LDAP
  2. LDAP-52

"Data too long for column 'XWS_VALUE' at row 1" error during LDAP authorization

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 9.0
    • Fix Version/s: 9.2.5
    • Component/s: Authenticator
    • Labels:
      None
    • Environment:
      xwiki 9.1.1
      LDAP Application 9.2.4
      LDAP Authenticator 9.2.4
    • Similar issues:

      Description

      There is a problem with LDAP authorization: users cannot login if 'dn' field is larger then 255 symbols (

      {name=dn value=CN=..., OU=..., DC=... }

      ).

      Logs contain following error:
      Data truncation: Data too long for column 'XWS_VALUE' at row 1 (attached)

      If we change XWS_VALUE filed type of xwikistrings table in DB (set it to TEXT instead of VARCHAR(255)) - all users can log in. Maybe there is a way to store that info in xwikilargestrings table?

      We have xwiki 9.1.1, but got the same error on 9.4 local test version.

        Attachments

          Activity

            People

            • Assignee:
              tmortagne Thomas Mortagne
              Reporter:
              abtaranov Taranov Alexey
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

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