Hi,
I think exactly that is the Problem. Your shema only allow Ineger Matches, so 177* isn't a valid integer, and so the match always finds nothing.
Greetings John
Von: openldap-technical [mailto:openldap-technical-bounces@openldap.org] Im Auftrag von Michael Gesendet: Dienstag, 15. September 2015 23:26 An: Frank Swasey Cc: openldap Betreff: RE: OpenLDAP wildcard searches.
Date: Tue, 15 Sep 2015 14:53:37 -0400 From: Frank.Swasey@uvm.edumailto:Frank.Swasey@uvm.edu To: mlstarling31@hotmail.commailto:mlstarling31@hotmail.com CC: openldap-technical@openldap.orgmailto:openldap-technical@openldap.org Subject: Re: OpenLDAP wildcard searches.
Today at 10:51am, Michael wrote:
Hello all, I've come across an issue where java developers using one of our LDAP environments want to be able to do wildcard searches on non-standard LDAP attributes. They are using a custom schema in the LDAP environment which contains the following attributes for example. retailerId:jurisdictionID: They want to be able to perform the following search filter to pull all entries with 21 as the jurisdictionID and any wildcard for the retailerID. '(&(retailerId=*)(jurisdictionID=21))' works as expected but of course this returns all objects with any retailerID. They would like to narrow the search results using the filters below. Is there something that needs to be added to the custom schema to allow this to work like it does for the standard LDAP attributes like cn,sn,mail etc? '(&(retailerId=177*)(jurisdictionID=21))' returns zero results'(&(retailerId=*389)(jurisdictionID=21))' returns zero results'(&(retailerId=1*389)(jurisdictionID=21))' returns zero results
From your examples - I can guess. But nobody can know.
How does this custom schema define retailerID? What are the matching rules?
-- Frank Swasey | http://www.uvm.edu/~fcs Sr Systems Administrator | Always remember: You are UNIQUE, University of Vermont | just like everyone else. "I am not young enough to know everything." - Oscar Wilde (1854-1900)
Hi Frank. See below.
attributetype ( 3.0.0.3 NAME 'retailerId' DESC 'ID of the retailer a user is assigned to' EQUALITY integerMatch SYNTAX 1.3.6.1.4.1.1466.115.121.1.27 SINGLE-VALUE )