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 <[email protected] 
> <mailto:[email protected]>>:
> 
> 
> 
>     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
> 


-- 
  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/

Reply via email to