Accentuated email addresses stored in LDAP

[Andre Rodier]

On 19/03/2018 07:23, Steffen Kaiser wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Mon, 19 Mar 2018, André Rodier wrote:
> 
>> I had to use base64 encoding to store email addresses, because they 
>> are
>> rejected otherwise, with an error message of illegal characters. I 
>> also
> 
> you are using the stock "mail" attribute in LDAP as:
> 
> olcAttributeTypes: ( 0.9.2342.19200300.100.1.3
>   NAME ( 'mail' 'rfc822Mailbox' )
>   DESC 'RFC1274: RFC822 Mailbox'
>     EQUALITY caseIgnoreIA5Match
>     SUBSTR caseIgnoreIA5SubstringsMatch
>     SYNTAX 1.3.6.1.4.1.1466.115.121.1.26{256} )
> 
> http://www.oid-info.com/get/1.3.6.1.4.1.1466.115.121.1.26
> https://en.wikipedia.org/wiki/IA5STRING
> IA5 :- 7bit
> 
>> noticed that some of the fields, like 'dn' and 'cn' where 
>> automatically
>> encoded in base64 when stored when including accentuated chars.
> 
> you mean when you use ldapsearch or similiar tool to export data? LDIF
> traditionally encode all data in 7bit ASCII, which is noted by the
> double "::" after the LDAP attribute name. The data in LDAP is UTF8
> and binary connections need not encode it either.
> 
> - -- Steffen Kaiser
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1
> 
> iQEVAwUBWq9lWMQnQQNheMxiAQL3ywgAtbWsT1U+PQgdK0D3StI9c44r8KgEG7dr
> AXhIvFPowuD3U0KH0ZJ8VHc+/WN0DMqCONvuaUyueaGY8bgqx+cNw8z01zMC9hTF
> xfs8x1lQsgikacyyjo3o9WehOJzgnlGvt33LLwjsI62WOLFE8PXnkZFXpkAWI1f4
> yTWoTFOxPnAA90CDBS4aBHdBaFI0TwbiGP5oIyjGCvI1aHJSTy5lNKfwUkvTdI+L
> tH4Z0JDkB3YBnRVIL6ST5W7p0VvBAQo+ia+UXpsZ4b1t3/xYCKtNV0ls9jIoqVzg
> dEFeyUoKQe8k5N8k6/vVVElzwtW6fxzQUJQXj01u03udqVMmTqXhrw==
> =8rp9
> -----END PGP SIGNATURE-----

Hello Steffen,

Thank you for your answer.

In fact, I am using the otherMailBox attribute, from the standard 
OpenLDAP distribution, which is also IA5String.

- Is there any way in Dovecot to encode the fields in base 64, to send 
queries? as the query is "eq", this would be enough, I think.
- Or is the LDAP server is supposed to store attributes as UTF8, and in 
this case, how to configure it that way?

Thanks!

# RFC1274: Cosine and Internet X.500 schema:
# 9.3.18.  Other Mailbox
#
#  The Other Mailbox attribute type specifies values for electronic
#  mailbox types other than X.400 and rfc822.
#
#    otherMailbox ATTRIBUTE
#        WITH ATTRIBUTE-SYNTAX
#            SEQUENCE {
#                    mailboxType PrintableString, -- e.g. Telemail
#                    mailbox IA5String  -- e.g. X378:Joe
#            }
#    ::= {pilotAttributeType 22}
#
  attributetype ( 0.9.2342.19200300.100.1.22 NAME 'otherMailbox'
	SYNTAX 1.3.6.1.4.1.1466.115.121.1.39 )




-- 
https://github.com/progmaticltd/homebox