[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Indexes not building correctly in OpenLDAP 2.0.21?
I'm getting flaky search results from trailing wildcards. I have 30
people that should match the first two searches and 33 that should match
the last two. I just dumped and reloaded my database
(slapindex/slapcat/slapadd -c/slapindex). The LDIF file looks OK. I'm
on Red Hat 7.1. I suspect the indexes are not building correctly.
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=computer services' -LLL dn |
wc -l
60
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=computer services' -LLL dn |
sort | uniq | wc -l
31
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=computer services*' -LLL dn |
wc -l
60
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=computer services*' -LLL dn |
sort | uniq | wc -l
28
(3 people missing, one gets returned 4x)
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=*computer services*' -LLL dn |
wc -l
44
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=*computer services*' -LLL dn |
sort | uniq | wc -l
23
(11 people missing)
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=*computer services' -LLL dn |
wc -l
66
[jpdalbec@mail03 perl]$ ldapsearch -x 'ou=*computer services' -LLL dn |
sort | uniq | wc -l
34
/etc/openldap/slapd.conf:
# $OpenLDAP: pkg/ldap/servers/slapd/slapd.conf,v 1.8.8.6 2001/04/20
23:32:43 kurt Exp $
#
# See slapd.conf(5) for details on configuration options.
# This file should NOT be world readable.
#
include /etc/openldap/schema/core.schema
include /etc/openldap/schema/cosine.schema
include /etc/openldap/schema/inetorgperson.schema
include /etc/openldap/schema/nis.schema
include /etc/openldap/schema/redhat/rfc822-MailMember.schema
include /etc/openldap/schema/redhat/autofs.schema
include /etc/openldap/schema/redhat/kerberosobject.schema
include /etc/openldap/schema/ysulocal/eduPerson-schema
include /etc/openldap/schema/ysulocal/ysuEduPerson.schema
# Define global ACLs to disable default read access.
access to * by * read
sasl-secprops none
sizelimit 50
# Do not enable referrals until AFTER you have a working directory
# service AND an understanding of referrals.
#referral ldap://root.openldap.org
#pidfile /var/run/slapd.pid
#argsfile /var/run/slapd.args
# Create a replication log in /var/lib/ldap for use by slurpd.
#replogfile /var/lib/ldap/master-slapd.replog
# Load dynamic backend modules:
# modulepath /usr/sbin/openldap
# moduleload back_ldap.la
# moduleload back_ldbm.la
# moduleload back_passwd.la
# moduleload back_shell.la
# The next two lines allow use of TLS for connections using a dummy test
# certificate, but you should generate a proper certificate by changing
to
# /usr/share/ssl/certs and running "make slapd.pem".
TLSCertificateFile /usr/share/ssl/certs/slapd.pem
TLSCertificateKeyFile /usr/share/ssl/certs/slapd.pem
#######################################################################
# ldbm database definitions
#######################################################################
database ldbm
suffix "dc=ysu,dc=edu"
#suffix "o=My Organization Name,c=US"
#rootdn "uid=root@mail03.cc.ysu.edu"
rootdn "cn=Manager,dc=ysu,dc=edu"
#rootdn "cn=Manager,o=My Organization Name,c=US"
# Cleartext passwords, especially for the rootdn, should
# be avoided. See slappasswd(8) and slapd.conf(5) for details.
# Use of strong authentication encouraged.
# rootpw secret
# rootpw {crypt}ijFYNcSNctBYg
rootpw *edited*
# The database directory MUST exist prior to running slapd AND
# should only be accessible by the slapd/tools. Mode 700 recommended.
directory /var/lib/ldap
# Indices to maintain
# index objectClass,uid,uidNumber,gidNumber,memberUid eq
# index cn,mail,surname,givenname eq,subinitial
index objectClass,uid,uidNumber,gidNumber,memberUid,member pres,eq
# index cn,sn,givenname,o,ou,mail,telephoneNumber,fax pres,eq,sub
# facsimileTelephoneNumber has no equality or substring match defined
index cn,sn,givenname,o,ou,mail,telephoneNumber pres,eq,sub
index eduPersonAffiliation,eduPersonPrimaryAffiliation pres,eq
index eduPersonNickname,eduPersonPrincipalName pres,eq,sub
index ysuEduPersonMajor,ysuEduPersonSchool pres,eq
index ysuEduPersonOutlookDept pres,eq,sub
# Replicas to which we should propagate changes
#replica host=ldap-1.example.com:389 tls=yes
# bindmethod=sasl saslmech=GSSAPI
# authcId=host/ldap-master.example.com@EXAMPLE.COM
# ldbm access control definitions
access to attr=userPassword
by self write
by anonymous auth
by * none
access to attrs=mail,uid
by * peername="IP=127\.0\.0\.1" read
by * peername="IP=150\.134\.10\.20[123]" read
by anonymous search
by group="cn=Staff,ou=DNGroups,dc=ysu,dc=edu" read
by group="cn=Faculty,ou=DNGroups,dc=ysu,dc=edu" read
by * search
access to attr=entry
by * read
access to *
by * peername="IP=127\.0\.0\.1" read
by * peername="IP=150\.134\.10\.20[123]" read
by anonymous none
by group="cn=Staff,ou=DNGroups,dc=ysu,dc=edu" read
by group="cn=Faculty,ou=DNGroups,dc=ysu,dc=edu" read
by * none