My Oracle Support Banner

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

Last updated on SEPTEMBER 09, 2019

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


In this example there are two uid=user_ubik in two different branches.

A) Search directly on Directory Server



ldapsearch -h <HOSTNAME> -p PORT -b "dc=example,dc=com"  uid=user_ubi* uid
version: 1
dn: cn=user_ubik,ou=user,dc=example,dc=com
uid: user_ubik

dn: cn=user_ubik,ou=mirroring,dc=example,dc=com
uid: user_ubik



B) Search via DPS ( and construction of virtual attribute uidvir  in dataview)

 
extract of configuration:
dn: cn=dv1,cn=data views,cn=config
dataSourcePool: dsp1
viewBase: dc=example,dc=com
objectClass: top
objectClass: configEntry
objectClass: dataView
objectClass: ldapDataView
cn: dv1
attributeRule: dv1_mapping_add-attr-value_uidvir
attributeRule: dv1_read_remove-attr_uid
attributeRule: dv1_read_remove-attr_cn

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


For further information on virtual transformation/attribute,  reference the ODSEE documentation here.



1) search filter with uid ( real attribute ) and wildcard and request only the virtual attribute uidvir

 
ldapsearch -h <HOSTNAME> -p <port> -b "dc=example,dc=com"  uid=user_ubi* uidvir
version: 1
dn: cn=user_ubik,ou=user,dc=example,dc=com
uidvir: user_ubik

dn: cn=user_ubik,ou=mirroring,dc=example,dc=com
uidvir: user_ubik

2) search filter with uidvir=user_ubik ( virtual attribute ) and request only the virtual attribute uidvir


ldapsearch -h <HOSTNAME> -p <port> -b "dc=example,dc=com"  uidvir=user_ubik uidvir
version: 1
dn: cn=user_ubik,ou=user,dc=example,dc=com
uidvir: user_ubik

dn: cn=user_ubik,ou=mirroring,dc=example,dc=com
uidvir: user_ubik

3) search filter with uidvir=user_ubi*  (wildcard in virtual attribute) and request the virtual attribute uidvir

$ ldapsearch -h <HOSTNAME> -p <port> -b "dc=example,dc=com"  uidvir=user_ubi* uidvir
$

In the above, it should be observed that the ldapsearch returns directly to command line [ie; nothing found]






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
Cause
Solution


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