View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005955 | SOGo | Backend Address Book | public | 2024-04-20 16:03 | 2024-04-20 16:03 |
| Reporter | mstilkerich | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | Server | OS | Debian | OS Version | 11 |
| Product Version | 5.10.0 | ||||
| Summary | 0005955: CardDAV addressbook-query report prop-filter equals match yields no result | ||||
| Description | The CardDAV addressbook-query report supports searching for vcards where a property's value (e.g. EMAIL) matches a search value. SOGo always returns an empty result. Using the collation "i;unicode-casemap", which is also the default per RFC 6352, the text match should furthermore be performed case insensitive. (Tests 1+2 in the attached file). As a special case, for properties with a group prefix (e.g., GROUPX.EMAIL), the prop-filter must only match properties having the specified group prefix. Interestingly, using an equals match on a property with group prefix, SOGo shows different behavior and returns all cards o the addressbook. (Test 3 in the attached file) Test 3 is also helpful as the result will show you that the addressbook actually contains an object that should have matched in Tests 1 and 2. | ||||
| Steps To Reproduce | Simply issue an addressbook-query report with a prop-filter containing a text-match with match-type "equals" to an addressbook, with a search value that should match at least on object of the addressbook. The result will be empty. See example attached. | ||||
| Tags | No tags attached. | ||||
 |
AbookQuery_PropFilterEqualsMatch_WrongResult.txt (7,673 bytes)
Test 1+2: Query an addressbook for vcards where the EMAIL property EQUALS as search value.
Expected result: Only contacts with an EMAIL property containing the exact search value are returned.
Actual result: SOGo returns an empty result.
- Test 1: Search cards with EMAIL=johndoe@example.com. The card with
UID=sabre-vobject-04122e61-c800-4099-b0e9-6cf91b96f985 should have been returned.
- Test 2: Search cards with EMAIL=johNDOE@EXAmple.com to check that match is case-insensitive
Test 3: Query an addressbook for vcards where an EMAIL property belonging to a specific group EQUALS a search value.
Expected result: Only contacts with a SEARCHGROUP.EMAIL property containing the exact search value are returned.
Actual result: SOGo returns all cards of the addressbook.
RFC6352 references:
- 8.3: Collations supported by the server MUST support "equality" and "substring" match operations as per [RFC4790],
Section 4.2, including the "prefix" and "suffix" options for "substring" matching.
- 8.3: CardDAV servers are REQUIRED to support the "i;ascii-casemap" [RFC4790] and "i;unicode-casemap" [RFC5051]
collations
- 10.5.1 (prop-filter XML element): When the "name" attribute does not specify a group prefix, it MUST match properties
in the vCard data without a group prefix or with any group prefix. When the "name" attribute includes a group
prefix, it MUST match properties that have exactly the same group prefix and name.
=== TEST 1: Search cards with EMAIL=johndoe@example.com ===
[2024-03-31 08:38:28]: [2 NFO] "REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1" 207
>>>>>>>>
REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1
Content-Length: 513
User-Agent: GuzzleHttp/7
Host: etain.mike2k.de
Depth: 1
Content-Type: application/xml; charset=UTF-8
<?xml version="1.0"?>
<CARDDAV:addressbook-query xmlns:DAV="DAV:" xmlns:CARDDAV="urn:ietf:params:xml:ns:carddav" xmlns:CS="http://calendarserver.org/ns/">
<DAV:prop>
<DAV:getetag/>
<CARDDAV:address-data/>
</DAV:prop>
<CARDDAV:filter test="anyof">
<CARDDAV:prop-filter name="EMAIL" test="anyof">
<CARDDAV:text-match negate-condition="no" collation="i;unicode-casemap" match-type="equals">johndoe@example.com</CARDDAV:text-match>
</CARDDAV:prop-filter>
</CARDDAV:filter>
</CARDDAV:addressbook-query>
<<<<<<<<
HTTP/1.1 207 Multi-Status
Server: nginx
Date: Sun, 31 Mar 2024 08:38:28 GMT
Content-Type: text/xml; charset=utf-8
Content-Length: 127
Connection: keep-alive
Cache-Control: no-cache
Pragma: no-cache
X-Frame-Options: SAMEORIGIN
<?xml version="1.0" encoding="utf-8"?>
<D:multistatus xmlns:D="DAV:" xmlns:C="urn:ietf:params:xml:ns:carddav"></D:multistatus>
--------
NULL
=== TEST 2: Search cards with EMAIL=johNDOE@EXAmple.com (check case-insensitive match) ===
[2024-03-31 08:38:28]: [2 NFO] "REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1" 207
>>>>>>>>
REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1
Content-Length: 513
User-Agent: GuzzleHttp/7
Host: etain.mike2k.de
Depth: 1
Content-Type: application/xml; charset=UTF-8
<?xml version="1.0"?>
<CARDDAV:addressbook-query xmlns:DAV="DAV:" xmlns:CARDDAV="urn:ietf:params:xml:ns:carddav" xmlns:CS="http://calendarserver.org/ns/">
<DAV:prop>
<DAV:getetag/>
<CARDDAV:address-data/>
</DAV:prop>
<CARDDAV:filter test="anyof">
<CARDDAV:prop-filter name="EMAIL" test="anyof">
<CARDDAV:text-match negate-condition="no" collation="i;unicode-casemap" match-type="equals">johNDOE@EXAmple.com</CARDDAV:text-match>
</CARDDAV:prop-filter>
</CARDDAV:filter>
</CARDDAV:addressbook-query>
<<<<<<<<
HTTP/1.1 207 Multi-Status
Server: nginx
Date: Sun, 31 Mar 2024 08:38:28 GMT
Content-Type: text/xml; charset=utf-8
Content-Length: 127
Connection: keep-alive
Cache-Control: no-cache
Pragma: no-cache
X-Frame-Options: SAMEORIGIN
<?xml version="1.0" encoding="utf-8"?>
<D:multistatus xmlns:D="DAV:" xmlns:C="urn:ietf:params:xml:ns:carddav"></D:multistatus>
--------
NULL
=== TEST 3: Search cards where item1.EMAIL=foo@ex.com ===
[2024-03-31 08:38:28]: [2 NFO] "REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1" 207
>>>>>>>>
REPORT /SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/ HTTP/1.1
Content-Length: 510
User-Agent: GuzzleHttp/7
Host: etain.mike2k.de
Depth: 1
Content-Type: application/xml; charset=UTF-8
<?xml version="1.0"?>
<CARDDAV:addressbook-query xmlns:DAV="DAV:" xmlns:CARDDAV="urn:ietf:params:xml:ns:carddav" xmlns:CS="http://calendarserver.org/ns/">
<DAV:prop>
<DAV:getetag/>
<CARDDAV:address-data/>
</DAV:prop>
<CARDDAV:filter test="anyof">
<CARDDAV:prop-filter name="item1.EMAIL" test="anyof">
<CARDDAV:text-match negate-condition="no" collation="i;unicode-casemap" match-type="equals">foo@ex.com</CARDDAV:text-match>
</CARDDAV:prop-filter>
</CARDDAV:filter>
</CARDDAV:addressbook-query>
<<<<<<<<
HTTP/1.1 207 Multi-Status
Server: nginx
Date: Sun, 31 Mar 2024 08:38:28 GMT
Content-Type: text/xml; charset=utf-8
Content-Length: 2493
Connection: keep-alive
Cache-Control: no-cache
Pragma: no-cache
X-Frame-Options: SAMEORIGIN
<?xml version="1.0" encoding="utf-8"?>
<D:multistatus xmlns:D="DAV:" xmlns:C="urn:ietf:params:xml:ns:carddav"><D:response><D:href>/SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/sabre-vobject-a44a962d-110a-42b6-8e1b-f7df655404db.vcf</D:href><D:propstat><D:prop><D:getetag>"gcs00000000"</D:getetag><C:address-data>BEGIN:VCARD
VERSION:3.0
PRODID:-//Sabre//Sabre VObject 4.5.4//EN
UID:sabre-vobject-a44a962d-110a-42b6-8e1b-f7df655404db
FN:CardDavClient Test25842248
N:Test25842248;CardDavClient
NICKNAME:Jonny1
EMAIL:maxmu@abcd.com
X-CUSTOMPROP;X-SPACEPARAM="HELLO, WORLD";X-CUSTOMPARAM=HOME,WORK:foobar
END:VCARD</C:address-data></D:prop><D:status>HTTP/1.1 200 OK</D:status></D:propstat></D:response><D:response><D:href>/SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/sabre-vobject-9e667a3a-10f7-4315-a127-cfa4b2a0fe97.vcf</D:href><D:propstat><D:prop><D:getetag>"gcs00000000"</D:getetag><C:address-data>BEGIN:VCARD
VERSION:3.0
PRODID:-//Sabre//Sabre VObject 4.5.4//EN
UID:sabre-vobject-9e667a3a-10f7-4315-a127-cfa4b2a0fe97
FN:CardDavClient Test31398396
N:Test31398396;CardDavClient
NICKNAME:Jonny2
TEL;TYPE=HOME:12345
TEL:555
END:VCARD</C:address-data></D:prop><D:status>HTTP/1.1 200 OK</D:status></D:propstat></D:response><D:response><D:href>/SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/sabre-vobject-e30b7469-dfb1-41b8-8300-a21205c8b358.vcf</D:href><D:propstat><D:prop><D:getetag>"gcs00000000"</D:getetag><C:address-data>BEGIN:VCARD
VERSION:3.0
PRODID:-//Sabre//Sabre VObject 4.5.4//EN
UID:sabre-vobject-e30b7469-dfb1-41b8-8300-a21205c8b358
FN:CardDavClient Test916984687
N:Test916984687;CardDavClient
NICKNAME:Jonny3
ITEM1.EMAIL:foo@ex.com
ITEM1.X-ABLABEL:CustomLabel
IMPP;TYPE=HOME;X-SERVICE-TYPE=Jabber:xmpp:foo@example.com
END:VCARD</C:address-data></D:prop><D:status>HTTP/1.1 200 OK</D:status></D:propstat></D:response><D:response><D:href>/SOGo/dav/mikey@dev.mike2k.de/Contacts/personal/sabre-vobject-04122e61-c800-4099-b0e9-6cf91b96f985.vcf</D:href><D:propstat><D:prop><D:getetag>"gcs00000000"</D:getetag><C:address-data>BEGIN:VCARD
VERSION:3.0
PRODID:-//Sabre//Sabre VObject 4.5.4//EN
UID:sabre-vobject-04122e61-c800-4099-b0e9-6cf91b96f985
FN:CardDavClient Test953816473
N:Test953816473;CardDavClient
NICKNAME:Jonny0
EMAIL;TYPE=WORK:doe@big.corp
EMAIL;TYPE=HOME:johndoe@example.com
X-CUSTOMPROP;X-CUSTOMPARAM=WORK:foobar
END:VCARD</C:address-data></D:prop><D:status>HTTP/1.1 200 OK</D:status></D:propstat></D:response></D:multistatus>
--------
NULL
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-04-20 16:03 | mstilkerich | New Issue | |
| 2024-04-20 16:03 | mstilkerich | File Added: AbookQuery_PropFilterEqualsMatch_WrongResult.txt |
