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

2022-02-10 Thread Patrik Peng
On 10.02.22 12:52, Aki Tuomi wrote: It is applied, but, your sql database overrides it by having non-lowercased usernames. Ah, I see. I was able to adjust our config accordingly. Thanks for your help :) OpenPGP_signature Description: OpenPGP digital signature

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

2022-02-10 Thread Patrik Peng
On 10.02.22 11:25, Aki Tuomi wrote: You can configure dovecot with auth_username_format=%Lu which downcases the username provided by the customer, as well. According to the docs [1], is '%Lu' already the default and this value is not changed in our config. I guess 'auth_username_format=%Lu'

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

2022-02-10 Thread Patrik Peng
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 fo

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

2022-02-10 Thread Patrik Peng
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

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

2022-02-09 Thread Patrik Peng
Woops, this time with better formatting. On 09.02.22 12:21, Patrik Peng wrote: Hello there We stumbled upon an user account with Solr FTS, which returned no search results for any given search query. Further investigation revealed an issue between indexing mails and querying the index. The

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

2022-02-09 Thread Patrik Peng
Hello there We stumbled upon an user account with Solr FTS, which returned no search results for any given search query. Further investigation revealed an issue between indexing mails and querying the index. The user name contains upper and lower case characters (eg. some.u...@domain.net). W

Re: Indexer error after upgrade to 2.3.11.3 [trial patch]

2020-11-06 Thread Patrik Peng
wcett wrote: On 21/10/2020 19:00, John Fawcett wrote: On 21/10/2020 16:44, Patrik Peng wrote: On 16.10.20 18:34, Patrik Peng wrote: On 16.10.20 18:00, Scott Q. wrote: This reminds me, the way I was able to reproduce this consistently was by having large headers ( 100+

Re: Indexer error after upgrade to 2.3.11.3

2020-10-21 Thread Patrik Peng
On 16.10.20 18:34, Patrik Peng wrote: On 16.10.20 18:00, Scott Q. wrote: This reminds me, the way I was able to reproduce this consistently was by having large headers ( 100+ lines ). On Friday, 16/10/2020 at 11:49 Patrik Peng wrote: On 19.08.20 17:37, Josef 'Jeff' Sipek wrote

Re: Indexer error after upgrade to 2.3.11.3

2020-10-16 Thread Patrik Peng
On 16.10.20 18:00, Scott Q. wrote: This reminds me, the way I was able to reproduce this consistently was by having large headers ( 100+ lines ). On Friday, 16/10/2020 at 11:49 Patrik Peng wrote: On 19.08.20 17:37, Josef 'Jeff' Sipek wrote: On Wed, Aug 19, 2020 at 17:0

Re: Indexer error after upgrade to 2.3.11.3

2020-10-16 Thread Patrik Peng
On 19.08.20 17:37, Josef 'Jeff' Sipek wrote: On Wed, Aug 19, 2020 at 17:03:57 +0200, Alessio Cecchi wrote: Hi, after the upgrade to Dovecot 2.3.11.3, from 2.3.10.1, I see frequently these errors from different users: It looks like this has been around for a while and you just got unlucky and

Dovecot FTS with Solrcloud

2020-07-10 Thread Patrik Peng
Greetings We are looking into a solution to set up full text search for our multiple Dovecot instances. According to the Dovecot Wiki, fts_solr is one of the recommended plugins to use. Since we have more than just a few hundred mailboxes, I guess one Solr instance will not suffice. So I took a l