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: