[SOLVED] OpenLDAP : bdb_substring_candidates: (telephoneNumber) not indexed

jonaskellens · 07-27-2011, 06:57 AM

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 ?

bathory · 07-28-2011, 03:23 AM

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

jonaskellens · 07-28-2011, 04:52 AM

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 ?

bathory · 07-28-2011, 08:16 AM

Hi,

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

Regards