LinuxQuestions.org - [SOLVED] OpenLDAP : bdb_substring_candidates: (telephoneNumber) not indexed

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - OpenLDAP : bdb_substring_candidates: (telephoneNumber) not indexed (https://www.linuxquestions.org/questions/linux-server-73/openldap-bdb_substring_candidates-telephonenumber-not-indexed-894054/)

OpenLDAP : bdb_substring_candidates: (telephoneNumber) not indexed

Hello,

I'm getting the following notice in slapd.conf when looking up an phone number to get the name of this contact :

Code:

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 fd=16 ACCEPT from IP=XX.XX.231.181:2898 (IP=0.0.0.0:389) 

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 op=0 BIND dn="cn=110305,ou=110305,dc=myldap" method=128 

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 op=0 BIND dn="cn=110305,ou=110305,dc=myldap" mech=SIMPLE ssf=0 

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 op=0 RESULT tag=97 err=0 text= 

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 op=1 SRCH base="dc=myldap" scope=2 deref=0 filter="(&(telephoneNumber=32777300999*)(sn=*))" 

Jul 27 13:46:26 sip1 slapd[25587]: conn=68 op=1 SRCH attr=cn sn telephoneNumber 

Jul 27 13:46:26 sip1 slapd[25587]: <= bdb_substring_candidates: (telephoneNumber) not indexed

What do I need to do to "index" telephoneNumber so searching becomes possible ?

Hi,

Have a look at this similar thread here at LQ
Don't forget to stop slapd and run slapindex to create the indexes.

Regards

Thank you for your reply !

Is it important where these index-definitions are written in the slapd.conf file ? In the beginning ? At the end ?

Hi,

You should already have some index definitions in your current slapd.conf. Anyway, they are usually towards the end of the file.

Regards