Uploaded image for project: 'ejabberd development'
  1. ejabberd development
  2. EJAB-1258

Unable to retrieve vcard information in ejabberd 2.1.4 if mod_vcard_ldap is used and user has jpegPhoto attribute in the LDAP

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: ejabberd 2.1.4, ejabberd 2.1.5, ejabberd 3.0.0-alpha-1
        • Fix Version/s: ejabberd 2.1.6, ejabberd 3.0.0-alpha-2
        • Component/s: vCard
        • Labels:
          None

          Description

          Problem also reported in http://www.ejabberd.im/node/4107

          Unable to retrieve vcard information in ejabberd 2.1.4 if mod_vcard_ldap is used and user has jpegPhoto attribute in the LDAP. Everything was fine in 2.1.3

          fragment of my configuration file:

          {mod_vcard_ldap,[

          {ldap_rootdn, ""}

          ,

          {ldap_password, ""}

          ,

          {ldap_base, "dc=st"}

          ,

          {ldap_uidattr, "uid"}

          ,

          {ldap_uidattr_format, "%u"}

          ,
          {ldap_vcard_map,
          [

          {"NICKNAME", "%s %s", ["sn", "givenName"]}

          ,

          {"FN", "%s", ["cn"]}

          ,

          {"GIVEN", "%s", ["givenName"]}

          ,

          {"FAMILY", "%s", ["sn"]}

          ,

          {"EMAIL", "%s", ["mail"]}

          ,

          {"ORGUNIT", "%s", ["ou"]}

          ,

          {"ROLE", "%s", ["title"]}

          ,

          {"TEL", "%s", ["telephoneNumber"]}

          ,

          {"BDAY", "%s", ["birthDay"]}

          ,

          {"PHOTO", "%s", ["jpegPhoto"]}

          ]},
          %% Search form
          {ldap_search_fields,
          [

          {"User", "%u"}

          ,

          {"Name", "givenName"}

          ,

          {"Family Name", "sn"}

          ,

          {"Organization Unit", "ou"}

          ]},
          %% vCard fields to be reported
          %% Note that JID is always returned with search results
          {ldap_search_reported,
          [

          {"Full Name", "FN"}

          ,

          {"Nickname", "NICKNAME"}

          ,

          {"Organization Unit", "ORGUNIT"}

          ,

          {"Birthday", "BDAY"}

          ]}]},

          In XML Console of PSI jabber client I can see following:

          [request]

          <iq type="get" to="user1@myjabberhost" id="aacba" >
          <query xmlns="jabber:iq:last"/>
          </iq>

          <iq type="get" to="user1@myjabberhost" id="aacca" >
          <vCard xmlns="vcard-temp" version="2.0" prodid="-//HandGen//NONSGML vGen v1.0//EN" />
          </iq>

          [response]

          <iq from="user1@myjabberhost" type="error" to="user2@myjabberhost/Psi" id="aacba" >
          <query xmlns="jabber:iq:last"/>
          <error type="cancel" code="405" >
          <not-allowed xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/>
          </error>
          </iq>

          <iq from="user1@myjabberhost" type="error" to="user2@myjabberhost/Psi" id="aacca" >
          <vCard xmlns="vcard-temp" version="2.0" prodid="-//HandGen//NONSGML vGen v1.0//EN" />
          <error type="wait" code="500" >
          <internal-server-error xmlns="urn:ietf:params:xml:ns:xmpp-stanzas"/>
          </error>
          </iq>

            Issue Links

            is duplicated by

            Bug - A problem which impairs or prevents the functions of the product. EJAB-1281 ejabberd sending invalid XML

            • Major - Major loss of function.
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. EJAB-1306 Unescaped special characters in vCard with Active Directory

            • Major - Major loss of function.
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. EJAB-957 Avatar picture sometimes broken (occurence of inappropriate string replacement)

            • Minor - Minor loss of function, or other problem where easy workaround is present.
            • Closed

            New Feature - A new feature of the product, which has yet to be developed. EJAB-722 LDAP extensible match

            • Major - Major loss of function.
            • Closed

              Expenses

                Activity

                Ascending order - Click to sort in descending order
                5 older comments
                Hide
                Permalink
                ekhramtsov ekhramtsov added a comment -

                OK, guys, since I cannot reproduce the bug, could you please provide raw LDAP field or SQL record?

                Show
                ekhramtsov ekhramtsov added a comment - OK, guys, since I cannot reproduce the bug, could you please provide raw LDAP field or SQL record?
                Hide
                Permalink
                kraynopp Pavel Kraynov added a comment -

                Certainly.

                ldapsearch -h ldapserver -b dc=st uid=user1 -L jpegPhoto

                dn: uid=user1,ou=People,dc=p33,dc=st
                jpegPhoto:: /9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBA
                QEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEBAQEBAQEBA
                QEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/wAARC
                AAUABQDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDA
                wIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJ
                icoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl
                5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+
                Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3A
                AECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5O
                kNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanq
                KmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRA
                xEAPwD+k39ov9orxVrWrfGfT/DvxFu/gn8Af2cdK1W9+N3xf8OaS+tfEHXNW8M+GU8ceM/DvgdZd
                F16PQvDfgnw29tD4o8QaNoHiPxfr2vz6v4W8JJ4a1Xw1canqXj93YeO/hz4v8Sab8DP2k/i/P8AF
                LwJ4W8IfELxP4F+MXjf4jfGzwBrnhrx1qfjzQ/C51+z+JOq6ydOsfEOqfDnxraiP4X+K/Ceu6FPo
                cF5dQ22nXun2ms+d6/4j1f4Q/FD4+fB3xz4S0Lx98Prn4k/Gzx38Uvh1feFbrxR458dfBn9pHxbe
                ePPDfxE8B6N9uvtN+I3hDwSuueP/hp8R/g6fB+q+LfHun6ZqU3w/wBSuvFvgXRvg98cW/E39rDwP
                qWkeLLn4JeDfFGn/F7xL4asdAu/iL8Zv2cPjZ8J/B3hTwt4dk8QX+leIPHOt/Erwb8KNS+I2heB9
                R8U69e+GPhH4P8AFcfiXxL4i8V3dlbaj8OvCeseP/i14H/wI+kH45fSVj4/cYyy7irj3hmHCfGOb
                5Tw/luR5nVwHBeRZNlub5fRyWvxNltPCPD4l5pk9HMs3xVfNHilmkc1ydYFzo4fE4Gr/T/CfDHDX
                9g5VRWVZdmMMywGErYirXwtOvjcfWxGHc8SsNiJS9pB0q844eEKMqbw0qNZT5ZNVV+s/wCzV8c7D
                9of4SaH8RYdIbw1rn23WPC/jjwi922oP4R8eeFNRn0XxToKag1rZNqenw6hbNeaFq5srMa34evdJ
                1lbS2S/WCMr5j/4Jk+HdZtvgP4y+I+p29xZad8ePjN4r+Lvg+0uV2P/AMITc+GfBPgHw1q8MeTss
                fF9j4AHjfS2IRrjTPEtndOiSTsoK/3T8OM3zziDw/4Jz3ibB/2fxDnHCuQ5lneC9m6P1bNMblmGx
                GOpexl71HlxFSp+6lrS+B6xP5o4hwmDwGfZxgcvqqvgcJmeNw2EqqaqKeHo4ipTpNVFpUXLFJTWk
                0uZbn1B8cf2bvhL+0Npul2vxG0C4fWPDslxP4S8beHNUvvC/j3wfPdmA3reHPFmjzW2qWVpqP2a3
                TWNGmlutB12GCK21vStRtkWIfMXhj/gmb8CrDXbTWPiP4x+MXx9s9Ouo7vTvCXxi8S+FLzwRDNDu
                NuuqeF/AXgbwBpvjG2t2Kyx2XjuPxTZtcRQXU1vLcwQzIUV4PE/A/BWc8a8N55m/B/C+a53hrrD5
                xmXD+U47NcOsPJzoKjmGKwlXF0vYT96j7OtH2cvehyvU9DK85zjB5NmWEwmbZlhcJO3PhsPjsVQw
                8vaK1Tmo0qsacvaLSd4vmWkro/RCKKOCOOGGNIYYUSKKKJFjjijjUJHHHGgCoiKAqIoCqoAAAAFF
                FFfqW2x8uf/2Q==

                Show
                kraynopp Pavel Kraynov added a comment - Certainly. ldapsearch -h ldapserver -b dc=st uid=user1 -L jpegPhoto dn: uid=user1,ou=People,dc=p33,dc=st jpegPhoto:: /9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBA QEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEBAQEBAQEBA QEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/wAARC AAUABQDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDA wIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJ icoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl 5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+ Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3A AECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5O kNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanq KmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRA xEAPwD+k39ov9orxVrWrfGfT/DvxFu/gn8Af2cdK1W9+N3xf8OaS+tfEHXNW8M+GU8ceM/DvgdZd F16PQvDfgnw29tD4o8QaNoHiPxfr2vz6v4W8JJ4a1Xw1canqXj93YeO/hz4v8Sab8DP2k/i/P8AF LwJ4W8IfELxP4F+MXjf4jfGzwBrnhrx1qfjzQ/C51+z+JOq6ydOsfEOqfDnxraiP4X+K/Ceu6FPo cF5dQ22nXun2ms+d6/4j1f4Q/FD4+fB3xz4S0Lx98Prn4k/Gzx38Uvh1feFbrxR458dfBn9pHxbe ePPDfxE8B6N9uvtN+I3hDwSuueP/hp8R/g6fB+q+LfHun6ZqU3w/wBSuvFvgXRvg98cW/E39rDwP qWkeLLn4JeDfFGn/F7xL4asdAu/iL8Zv2cPjZ8J/B3hTwt4dk8QX+leIPHOt/Erwb8KNS+I2heB9 R8U69e+GPhH4P8AFcfiXxL4i8V3dlbaj8OvCeseP/i14H/wI+kH45fSVj4/cYyy7irj3hmHCfGOb 5Tw/luR5nVwHBeRZNlub5fRyWvxNltPCPD4l5pk9HMs3xVfNHilmkc1ydYFzo4fE4Gr/T/CfDHDX 9g5VRWVZdmMMywGErYirXwtOvjcfWxGHc8SsNiJS9pB0q844eEKMqbw0qNZT5ZNVV+s/wCzV8c7D 9of4SaH8RYdIbw1rn23WPC/jjwi922oP4R8eeFNRn0XxToKag1rZNqenw6hbNeaFq5srMa34evdJ 1lbS2S/WCMr5j/4Jk+HdZtvgP4y+I+p29xZad8ePjN4r+Lvg+0uV2P/AMITc+GfBPgHw1q8MeTss fF9j4AHjfS2IRrjTPEtndOiSTsoK/3T8OM3zziDw/4Jz3ibB/2fxDnHCuQ5lneC9m6P1bNMblmGx GOpexl71HlxFSp+6lrS+B6xP5o4hwmDwGfZxgcvqqvgcJmeNw2EqqaqKeHo4ipTpNVFpUXLFJTWk 0uZbn1B8cf2bvhL+0Npul2vxG0C4fWPDslxP4S8beHNUvvC/j3wfPdmA3reHPFmjzW2qWVpqP2a3 TWNGmlutB12GCK21vStRtkWIfMXhj/gmb8CrDXbTWPiP4x+MXx9s9Ouo7vTvCXxi8S+FLzwRDNDu NuuqeF/AXgbwBpvjG2t2Kyx2XjuPxTZtcRQXU1vLcwQzIUV4PE/A/BWc8a8N55m/B/C+a53hrrD5 xmXD+U47NcOsPJzoKjmGKwlXF0vYT96j7OtH2cvehyvU9DK85zjB5NmWEwmbZlhcJO3PhsPjsVQw 8vaK1Tmo0qsacvaLSd4vmWkro/RCKKOCOOGGNIYYUSKKKJFjjijjUJHHHGgCoiKAqIoCqoAAAAFF FFfqW2x8uf/2Q==
                Hide
                Permalink
                ekhramtsov ekhramtsov added a comment -

                I've fixed LDAP part in https://git.process-one.net/ejabberd/mainline/commit/3024bb0cbf359f3e14b5386ed14ecfb168e8a267
                Please check and report if the bug really disappears.

                I'm also waiting for details about reproducing the bug in SQL.

                Show
                ekhramtsov ekhramtsov added a comment - I've fixed LDAP part in https://git.process-one.net/ejabberd/mainline/commit/3024bb0cbf359f3e14b5386ed14ecfb168e8a267 Please check and report if the bug really disappears. I'm also waiting for details about reproducing the bug in SQL.
                Hide
                Permalink
                kraynopp Pavel Kraynov added a comment -

                The patch works fine, bug disappears. Thank you very much.

                Show
                kraynopp Pavel Kraynov added a comment - The patch works fine, bug disappears. Thank you very much.
                Hide
                Permalink
                ekhramtsov ekhramtsov added a comment -

                Pavel, thanks for the testing. I think I'll close this ticket because described problem couldn't relate to SQL.
                Efren, please create new ticket for your SQL problem and don't forget to provide SQL record to test (!!!)

                Show
                ekhramtsov ekhramtsov added a comment - Pavel, thanks for the testing. I think I'll close this ticket because described problem couldn't relate to SQL. Efren, please create new ticket for your SQL problem and don't forget to provide SQL record to test (!!!)

                  People

                  • Votes:
                    2 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Development