RE: strange problem - ldapsearch cannot find exact integer value

["Howard Chu" <hyc@highlandsun.com>]

The schema for your attributeType needs to define an EQUALITY matching rule
if you want to be able to do this kind of search.

  -- Howard Chu
  Chief Architect, Symas Corp.       Director, Highland Sun
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support

> -----Original Message-----
> From: owner-openldap-software@OpenLDAP.org
> [mailto:owner-openldap-software@OpenLDAP.org]On Behalf Of Probst,
> Carsten
> Sent: Wednesday, March 24, 2004 1:23 AM
> To: openldap-software@OpenLDAP.org
> Cc: Carsten Probst
> Subject: strange problem - ldapsearch cannot find exact integer value
>
>
> hello all,
>
> i've got a strange problem here. i'm in the middle of testing some new
> objectclasses required by one of our developers and yesterday i
> experienced the following:
>
> [cprobst@test2 cprobst]$ ldapsearch -v -b
> "cn=netm,ou=resellers,ou=netmservice,o=netmldap" -LLL -x
> '(&(objectClass=netmMOKeyword)(netmLargeAccount=*))' -C
> ldap_initialize( <DEFAULT> )
> filter: (&(objectClass=netmMOKeyword)(netmLargeAccount=*))
> requesting: ALL
>
> dn:
> cn=101,cn=2360,cn=SMSGW,ou=portals,cn=3000694,cn=netm,ou=resel
> lers,ou=netm
>  service,o=netmldap
> objectClass: netmMOKeyword
> netmKeyword: TEST
> netmCarrierName: D1
> netmKeywordDestination: bla
> netmKeywordSessionTime: 3600
> netmKeywordTS: 20040323120000Z
> netmKeywordStatus: wasichwill
> netmLargeAccount: 84
>
> so this searchstring is returning me the whole object with all
> attributes BUT if i use ldapsearch like below (as far is i understand
> the same thing but slightly more detailed (netmLageAccount=84
> instead of
> *)):
>
> [cprobst@test2 cprobst]$ ldapsearch -v -b
> "cn=netm,ou=resellers,ou=netmservice,o=netmldap" -LLL -x
> '(&(objectClass=netmMOKeyword)(netmLargeAccount=84))' -C
> ldap_initialize( <DEFAULT> )
> filter: (&(objectClass=netmMOKeyword)(netmLargeAccount=84))
> requesting: ALL
>
> it returns nothing! Can someone of you explain me what i'm
> doing wrong?
> normally it should return me the object with all attributes
> like before,
> shoudn't it?! the netmLargeAccount is defined as an integer in the
> schema:
>
> <snip>
> attributetype ( 1.3.6.1.4.1.13255.1.1.1.1 NAME 'netmInteger'
>         SYNTAX 1.3.6.1.4.1.1466.115.121.1.27 SINGLE-VALUE )
> <...>
> attributetype ( 1.3.6.1.4.1.13255.1.1.2.166 NAME
> 'netmLargeAccount' SUP
> netmInteger )
> </snap>
>
> exactly like in the RFC:
> http://www.rfc-editor.org/rfc/rfc2252.txt
>
> >6.16. INTEGER
> >
> >  ( 1.3.6.1.4.1.1466.115.121.1.27 DESC 'INTEGER' )
> >
> >  Values in this syntax are encoded as the decimal representation of
> >  their values, with each decimal digit represented by the its
> >  character equivalent. So the number 1321 is represented by the
> >  character string "1321".
>
> i tested it with the other (text)attributes and its working
> fine. is it
> possible at all to look for integer values? i need your help! thanx in
> advance!
>
> regards,
> carsten
>
> --
> net mobile AG
> -------------------------------------------
> Carsten Probst
> Operations Department
> UNIX & Network Administrator
> -------------------------------------------
> Moersenbroicher Weg 200
> D - 40470 Duesseldorf
>
> F642 531B EB06 FEE2 7340  86EF EA75 FF98 CF11 9A15
>