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

    • Bug
    • Resolution: Fixed
    • Major
    • 9.2.5
    • 9.0
    • Authenticator
    • None
    • xwiki 9.1.1
      LDAP Application 9.2.4
      LDAP Authenticator 9.2.4

    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

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

            Dates

              Created:
              Updated:
              Resolved: