Tagged: ldapsearch, OpenDJ 3.0, wildcard
This topic has 4 replies, 3 voices, and was last updated 3 years, 1 month ago by cliff_tian.
-
AuthorPosts
-
April 16, 2019 at 8:23 am #25554
ShitalPatil
ParticipantOpenDJ 3.0
When we search with wildcard in front of search string, it shows as attribute not indexed.
But searching with wildcard at the end, works fine.
Is this something known issue in 3.0? It use to work well in 2.6.>ldapsearch -h localhost -p 389 -D “cn=Manager” -w pass -b “o=org” “(cn=*min)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=*min)[INDEX:cn.substring][NOT-INDEXED] scope=sub[COUNT:488] final=[COUNT:488]>ldapsearch -h localhost -p 389 -D “cn=Manager” -w pass -b “o=org” “(cn=Admin*)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=Admin*)[INDEX:cn.substring][COUNT:2] final=[COUNT:2
]-
This topic was modified 3 years, 1 month ago by
ShitalPatil.
April 16, 2019 at 8:34 am #25556Ludo
ModeratorOpenDJ has an optimization for initial substrings where it can use the cn.equality index, even though no substring index was configured.
April 16, 2019 at 9:22 am #25574cliff_tian
ParticipantHi Ludo,
The search returns only 1 result, and it appears it could not use the cn.equality index – even after removing the substring index from cn and uid.
ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(cn=*wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=*wcadmin)[INDEX:cn.substring][NOT-INDEXED] scope=su
b[COUNT:488] final=[COUNT:488]ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(uid=*wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(uid=*wcadmin)[INDEX:uid.substring][NOT-INDEXED] scope=
sub[COUNT:488] final=[COUNT:488]ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(uid=wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(uid=wcadmin)[INDEX:uid.equality][COUNT:1] final=[COUNT
:1]ldapsearch -h localhost -p 389 -D “cn=Manager” -w wcadmin -b “o=ptc” “(cn=wcadmin)” debugsearchindex
dn: cn=debugsearch
debugsearchindex: filter=(cn=wcadmin)[INDEX:cn.equality][COUNT:0] final=[COUNT:0
]April 16, 2019 at 9:50 am #25575cliff_tian
ParticipantAlso refer to screenshot for comparison:
April 17, 2019 at 12:08 pm #25635cliff_tian
ParticipantHi Ludo,
It will be appreciated if you can look the replies.
Cliff
-
This topic was modified 3 years, 1 month ago by
-
AuthorPosts
You must be logged in to reply to this topic.