Johann Botha wrote:
>
> Hi!
>
> phpQLAdmin
> (http://www.adfinis.ch/projects/phpQLAdmin/)
> allows me to search for substrings in 'Mail Alias',
>
> then i tried to add an index for this,
>
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
> # qmail-ldap
> index mail,mailAlternateAddress,mailForwardingAddress pres,eq,sub
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
>
> but OpenLDAP 2.0.27 would not allow me to do a substring index until i
> changed the mailAlternateAddress attribute in qmail.schema to look like
> this:
Ok, I changed this for 20021201.
--
Andre
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
> attributetype ( 1.3.6.1.4.1.7914.1.2.1.4 NAME 'mailAlternateAddress'
> DESC 'Secondary (alias) mailaddresses for the same user'
> EQUALITY caseIgnoreIA5Match
> SUBSTR caseIgnoreIA5SubstringsMatch
> SYNTAX 1.3.6.1.4.1.1466.115.121.1.26{256} )
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
>
> i was wondering which attributes are best to index:
>
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
> # General
> index ou,objectClass pres,eq
> index cn,uid pres,eq,sub
>
> # qmail-ldap
> index mail,mailAlternateAddress,mailForwardingAddress pres,eq,sub
> --8<---------:- snip -:---------8<---------:- snip -:---------8<--
>
> anything i missed ?
>
> --
> Regards
> Johann
>
> 'Simplicity is the ultimate sophistication.'
> - Leonardo da Vinci
> ________________________________________________________________
> Johann L. Botha Frogfoot Networks ISP
> [EMAIL PROTECTED] http://www.frogfoot.net/
> +27.82.562.6167 Built and Managed with Attention to Detail
> +27.21.683.1563
> http://blue.frogfoot.net/
