Re: search with a wildcard works, with exactly matching string it doesn'

Re: search with a wildcard works, with exactly matching string it doesn't

To: Michael Ströder <michael@stroeder.com>

Subject: Re: search with a wildcard works, with exactly matching string it doesn't

From: Gregory House <raintown.us@gmail.com>

Date: Wed, 5 Aug 2015 09:51:52 +0200

Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=qVXi4i1ED+Tmy6J5bcjnm8J13RXM9VMfTRrgjgX7xEo=; b=C9ppMAPlbgUVlvOoHN8hFBE2qSQKATFvcDc/djcQBW9bd3paXt2jcJ1N1VPK/KmtBh glTtn+7p41Wf5YF7KY0OtpCbUTuTFMg7xyb50D23JkmwdsGqtqr/oaqJdve1tVPJB5xx dMft1AecMDhBOwSaQqoNLJC7YxFmwJCdQPFqAZhIH9g6jf5V8q/gGukqz1H+9zytrPMq MlugIDTSQXVw5bMnbSoE9eg3S85xgHi4GkhWMD7hV00PM4vQlEcrTtdjs7nhiljV5Zeg aR0LONzhr+dE95VOBULMFbz3iOa8l/oggdyHdCnaMi3vUP/qXeetjXYrvTXkTMhax2zD oz7A==

In-reply-to: <55BA7AB6.5090203@stroeder.com>

References: <CADYSyWwEtgcatxLBajXAAcZa2LkbeqZ6d=qRwggtVBBzeNpu1w@mail.gmail.com> <55BA7AB6.5090203@stroeder.com>

Michael: Thanks for tip. As it happens there was no index at all for myDeviceId. I created one via:

dn: olcDatabase={2}mdb,cn=config
changetype: modify
add: olcDbIndex
olcDbIndex: myDeviceId

and it seemed to work OK after that.

On Thu, Jul 30, 2015 at 9:27 PM, Michael Ströder <michael@stroeder.com> wrote:

Gregory House wrote:
> If I run a query against my directory with this filter:
>
> "(myDeviceId=ZZZ-07430.08.12345678*)"
>
> it returns a match showing precisely that myDeviceId =
> "ZZZ-07430.08.12345678"
>
> If I use this filter, without the wildcard and just the actual value
>
> "(myDeviceId=ZZZ-07430.08.12345678)"
>
> it returns no match.

Wild guess:
You've added eq-only index for 'myDeviceId' *after* adding the entry.

See also:

"How do I add an index after populating the database?"
http://www.openldap.org/faq/data/cache/136.html

Ciao, Michael.