Debian – ldap_add: Constraint violation (19) additional info: some attributes not unique

databasedatabase-backupdebianldapopenldap

Well I have already gone through ldap_add: Constraint violation (19) but couldn't solve my problem!

Problem I'm facing is that, when I'm trying to add users from bckup.ldif file by issuing following command

ldapadd -x -D "dc=admin,dc=domain,dc=lcl -f bckup.ldif -W

It's throwing following error 

adding new entry "uid=doctor.lcl,ou=People,dc=domain,dc=lcl"
ldap_add: Constraint violation (19)
    additional info: some attributes not unique

I took backup by using ldapsearch only not slapcat

So my question is What causing the error and How to resolve the error?

Best Answer

It seems that one (or more) attribute for uid=doctor.lcl,ou=People,dc=domain,dc=lcl contains duplicate value with an already existing LDAP entry, for an attribute defined as unique.

First, check your slapd.conf to search for attributes marked as unique. e.g :

# index since the unique overlay will search for matching mail attributes
index mail eq

overlay unique
unique_attributes mail

Then perform an ldap search on this (these) unique attribute(s) and find the one which is a duplicate with uid=doctor.lcl attributes.

Related Topic