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

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

    XMLWordPrintable

    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: