dovecot - Feb 2022 - Different handling of upper and lower case while indexing/searching with Solr

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):

# 2.3.15 (0503334ab1): /usr/local/etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.15 (e6a84e31)
# OS: FreeBSD 12.2-RELEASE-p11 amd64
# Hostname: XXX
auth_cache_negative_ttl = 5 mins
auth_cache_size = 20 M
auth_cache_ttl = 5 mins
auth_username_chars = 
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.+-_@
auth_verbose = yes
auth_worker_max_count = 90
config_cache_size = 50 M
disable_plaintext_auth = no
passdb {
 ? args = /usr/local/etc/dovecot/sql.conf
 ? driver = sql
 ? name = sql
}
userdb {
 ? args = /usr/local/etc/dovecot/sql.conf
 ? driver = sql
 ? name = sql
}
plugin {
 ? fts_autoindex = no
 ? fts_autoindex_exclude = \Junk
 ? fts_autoindex_exclude2 = \spam
 ? fts_autoindex_exclude3 = INBOX.spam
 ? fts_enforced = no
 ? fts_index_timeout = 120s
 ? fts_solr = url=https://XXX soft_commit=no batch_size=1000
 ? mail_log_events = copy save delete undelete expunge mailbox_create 
mailbox_delete mailbox_rename
 ? mail_log_fields = uid box msgid from size flags
 ? quota = maildir:User quota
 ? quota_grace = 10%%
 ? quota_rule = *:storage=1G
 ? quota_warning = storage=95%% quota-warning 95 %u
 ? quota_warning2 = storage=80%% quota-warning 80 %u
 ? sieve = /var/empty/sieve.current
 ? sieve_before = /usr/local/etc/dovecot/sieve.before/
 ? sieve_dir = /var/empty/sieve
 ? sieve_global_dir = /usr/local/etc/dovecot/sieve.global/
 ? sieve_global_extensions = +editheader
}
service auth-worker {
 ? process_limit = 150
 ? user = dovenull
}
service auth {
 ? client_limit = 65000
}
ssl_cert = </etc/ssl/certs/xxx
ssl_cipher_list = 
ECDHE+AESGCM:DHE+AESGCM:ECDHE+AES256:DHE+AES256:ECDHE+AES:DHE+AES:!LOW:!MEDIUM:!aNULL:!eNULL:!3DES:!DES:!DSS:!EXP:!MD5:!PSK:!RC4:!SRP
ssl_client_ca_file = /etc/ssl/certs/xxx
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
ssl_min_protocol = TLSv1
ssl_prefer_server_ciphers = yes
verbose_proctitle = yes
protocol imap {
 ? imap_client_workarounds = delay-newmail tb-extra-mailbox-sep
 ? mail_max_userip_connections = 45
 ? mail_plugins = mail_log notify quota fts fts_solr imap_quota
}
protocol pop3 {
 ? mail_max_userip_connections = 30
 ? pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
 ? pop3_uidl_format = UID%u-%v
}
protocol lmtp {
 ? mail_plugins = mail_log notify quota fts fts_solr sieve
}

-------------- 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/b0b643a6/attachment-0001.sig>

> 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