My Oracle Support Banner

Directory Proxy Server Does not Accept Wildcards in the Search when Using Virtual Attribute in Filter (Doc ID 1383620.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Directory Server Enterprise Edition - Version: 6.3 SP1 to 11.1.1.5.0 - Release: 6.0 to 11gR1
Information in this document applies to any platform.

Symptoms

Example of Symptoms:

In this example  I have only two uid=user_ubik in two different branches.

A) Search directly on Directory Server


ldapsearch -h coxal -p 7389 -b "o=stk.com"  uid=user_ubi* uid
version: 1
dn: cn=user_ubik,ou=user,o=stk.com
uid: user_ubik

dn: cn=user_ubik,ou=mirroring,o=stk.com
uid: user_ubik



B) Search via DPS ( and construction of virtual attribut uidstk  in dataview)
 
extract of configuration:
dn: cn=dv1,cn=data views,cn=config
dataSourcePool: dsp1
viewBase: o=stk.com
objectClass: top
objectClass: configEntry
objectClass: dataView
objectClass: ldapDataView
cn: dv1
attributeRule: dv1_mapping_add-attr-value_uidstk
attributeRule: dv1_read_remove-attr_uid
attributeRule: dv1_read_remove-attr_cn

dn: cn=dv1_mapping_add-attr-value_uidstk,cn=attribute rules,cn=config
model: mapping
viewAttributeValue: ${uid}
objectClass: top
objectClass: configEntry
objectClass: attributeRule
transformation: add value
attributeName: uidstk
cn: dv1_mapping_add-attr-value_uidstk


Remark:  to configure  virtual transformation/attribute  refer to ODSEE documentation
http://docs.oracle.com/cd/E20295_01/html/821-1222/virtual_transformations.html#symmetric_transformations)


1) search filter with uid ( real attribute ) and wildcard and ask only the virtual attribut uidstk

 
ldapsearch -h coxal -p 9389 -b "o=stk.com"  uid=user_ubi* uidstk
version: 1
dn: cn=user_ubik,ou=user,o=stk.com
uidstk: user_ubik

dn: cn=user_ubik,ou=mirroring,o=stk.com
uidstk: user_ubik

2) search filter with uidstk=user_ubik ( virtual attribut ) and ask only the virtual attribut uidstk


ldapsearch -h coxal -p 9389 -b "o=stk.com"  uidstk=user_ubik uidstk
version: 1
dn: cn=user_ubik,ou=user,o=stk.com
uidstk: user_ubik

dn: cn=user_ubik,ou=mirroring,o=stk.com
uidstk: user_ubik

3) search filter with uidstk=user_ubi*  (wildcard in virtual attribute) and  ask  the virtual attribut uidstk

[duse@coxal ~]%  ldapsearch -h coxal -p 9389 -b "o=stk.com"  uidstk=user_ubi* uidstk
[duse@coxal ~]%

Here you can see the ldapsearch return nothing and no errors





Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
  Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.