Re: Uniqueness across multiple attributes

Stefan Schmidt wrote:

Hello Andreas, thank you for your reply. The idea would have been to prevent duplicates across mail and mailAlias from being created in the first place, but you are right if OpenLDAP doesn't allow this then using an external script to check if the mail addresses are unique could be a workaround.

You could also try writing your schema such that mail and mailAlias are related through inheritance. E.g., make mailAlias a subtype of mail, or make them both inherit from a common supertype. Then set the uniqueness constraint on the supertype.

Cheers, Stefan Schmidt

Am Mi., 12. Juni 2019 um 20:09 Uhr schrieb A. Schulze <sca@andreasschulze.de mailto:sca@andreasschulze.de>:

Am 12.06.19 um 13:51 schrieb Stefan Schmidt:
> Hello,
>
> is it possible define a unique constraint across attributes? We have a mail field and a mailAlias field and would like to assure that if a mail address
exists either in mail or mailAlias it cannot be added again to either field, meaning mail addresses are unique in the complete tree.
>
> We are using OpenLDAP 2.4 and currently we use the following LDIF to load the unique module and assure that the mail attribute is unique:
>
> dn: cn=module,cn=config
> cn: module
> objectclass: olcModuleList
> objectclass: top
> olcmoduleload: unique
> olcmodulepath: /usr/lib/ldap
>
> dn: olcOverlay=unique,olcDatabase={1}hdb,cn=config
> objectClass: olcOverlayConfig
> objectClass: olcUniqueConfig
> olcOverlay: {0}unique
> olcUniqueAttribute: mail
>
> Which LDIF would I use to assure uniqueness across mail and mailAlias?
>
> Cheers,
> Stefan Schmidt

see my question http://www.openldap.org/lists/openldap-technical/201905/msg00021.html
and the answer http://www.openldap.org/lists/openldap-technical/201905/msg00022.html