Aki Tuomi
2022-Feb-10 09:43 UTC
Different handling of upper and lower case while indexing/searching with Solr
> 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
Patrik Peng
2022-Feb-10 09:58 UTC
Different handling of upper and lower case while indexing/searching with Solr
On 10.02.22 10:43, Aki Tuomi wrote:> Probably easiest fix is to fix the users in database to all lowercase, as you are likely returning `user` attribute in your SQL queries.We thought about this as well, but there are 500+ affected accounts and they are used by our customers which would mean for each of them to reconfigure all their clients. -------------- next part -------------- A non-text attachment was scrubbed... Name: OpenPGP_signature Type: application/pgp-signature Size: 840 bytes Desc: OpenPGP digital signature URL: <https://dovecot.org/pipermail/dovecot/attachments/20220210/019a2d01/attachment.sig>