Different handling of upper and lower case while indexing/searching with Solr

Aki Tuomi aki.tuomi at open-xchange.com
Thu Feb 10 09:43:59 UTC 2022


> On 10/02/2022 11:36 Patrik Peng <patrik.peng at hostpoint.ch> wrote:
> 
>  
> On 09.02.22 17:47, Christian Kivalo wrote:
> 
> > How are your users added to your auth backend?
> 
> We use a SQL DB as auth backend. Users are added by an external application.
> New accounts are all added as lowercase, but it could be possible that 
> there was a time in the past where accounts were added without conversion.
> At least the DB contains a few accounts with uppercase letters in the 
> localpart.
> 
> > Please post your doveconf -n output
> 
> Here you go (I stripped a few irrelevant sections):

Probably easiest fix is to fix the users in database to all lowercase, as you are likely returning `user` attribute in your SQL queries.

Aki


More information about the dovecot mailing list