<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">you have different userdb setup for protocols imap, doveadm and lmtp?</div><div class=""><br class=""></div><div class="">try to check differences in 'doveconf -f protocol=doveadm -n' and 'doveconf -f protocol=doveadm -n'</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Sami</div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 19. Sep 2022, at 16.10, Philip Warner <<a href="mailto:pjw@rhyme.com.au" class="">pjw@rhyme.com.au</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta charset="UTF-8" class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">OK...I have made some progress with this. Looking through the SOLR logs, the query that IMAP is sending has “user:FULL-EMAIL-ADDRESS” whereas the doveadm search has “user:USERNAME”. The indexing was done using just the username.<o:p class=""></o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Is there a way to change the IMAP search command username to match the username used to login?<o:p class=""></o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">This is further complicated by the fts automatic update setting: it seems to use the domain-less username when updating SOLR.<o:p class=""></o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">Something to ensure a consistent username for indexing would be great.<o:p class=""></o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">-<o:p class=""></o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(225, 225, 225); padding: 3pt 0cm 0cm;" class=""><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; border: none; padding: 0cm;" class=""><b class="">From:<span class="Apple-converted-space"> </span></b><a href="mailto:pjw@rhyme.com.au" style="color: blue; text-decoration: underline;" class="">Philip Warner</a><br class=""><b class="">Sent:<span class="Apple-converted-space"> </span></b>Monday, 19 September 2022 10:30 PM<br class=""><b class="">To:<span class="Apple-converted-space"> </span></b><a href="mailto:dovecot@dovecot.org" style="color: blue; text-decoration: underline;" class="">dovecot@dovecot.org</a><br class=""><b class="">Subject:<span class="Apple-converted-space"> </span></b>doveadm-search finds emails, but IMAP search fails to find any</div></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div class=""><div class=""><p class="">Using dovecot 2.3.7.2 with solr 8.11.2 when I do:</p><p class=""><code style="font-family: "Courier New";" class=""><span style="font-size: 10pt;" class="">doveadm search -u user mailbox INBOX subject "something"</span></code></p><p class="">I get multiple mail ID's.</p><p class="">When I start a manual IMAP session and login as that user, select INBOX, and try the command:</p><p class=""><code style="font-family: "Courier New";" class=""><span style="font-size: 10pt;" class="">. search subject "something"</span></code></p><p class="">It returns zero mail ID's; this is consistent across all searches using IMAP - no results returned, no matter what I search for in IMAP.</p><p class="">The<span class="Apple-converted-space"> </span><code style="font-family: "Courier New";" class=""><span style="font-size: 10pt;" class="">dovecot -n</span></code><span class="Apple-converted-space"> </span>command returns:</p><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""># 2.3.7.2 (3c910f64b): /etc/dovecot/dovecot.conf<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""># Pigeonhole version 0.5.7.2 ()<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""># OS: Linux 5.4.0-125-generic x86_64 Ubuntu 20.04.5 LTS<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""># Hostname: WITHELD<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">mail_location = maildir:~/Mail<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">mail_plugins = " fts fts_solr virtual"<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">mail_privileged_group = mail<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">managesieve_notify_capability = mailto<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">namespace {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> location = virtual:~/Mail/virtual<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> prefix = virtual.<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> separator = .<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">namespace inbox {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> inbox = yes<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> location =<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox Drafts {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \Drafts<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox Junk {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \Junk<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox Sent {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \Sent<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox "Sent Messages" {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \Sent<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox Trash {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \Trash<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mailbox virtual.All {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> comment = All my messages<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> special_use = \All<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> prefix =<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">passdb {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> args = /etc/dovecot/dovecot-sql.conf.ext<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> driver = sql<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">passdb {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> driver = pam<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">plugin {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> fts = solr<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> fts_autoindex = yes<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> fts_enforced = yes<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> fts_solr = url=<a href="http://localhost:8983/solr/dovecot/" class="">http://localhost:8983/solr/dovecot/</a><o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> sieve = file:~/sieve;active=~/.dovecot.sieve<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">protocols = " imap lmtp sieve pop3 sieve"<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">service imap {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> vsz_limit = 4 G<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">service index-worker {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> vsz_limit = 2 G<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">service indexer-worker {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> vsz_limit = 2 G<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">service lmtp {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> inet_listener lmtp {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> address = 127.0.0.1<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> port = 24<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> }<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">ssl_cert = </etc/letsencrypt/live/WITHELD/fullchain.pem<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">ssl_client_ca_dir = /etc/ssl/certs<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">ssl_dh = # hidden, use -P to show it<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">ssl_key = # hidden, use -P to show it<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">userdb {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> args = /etc/dovecot/dovecot-sql.conf.ext<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> driver = sql<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">userdb {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> driver = passwd<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">protocol lmtp {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mail_plugins = " fts fts_solr virtual sieve"<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> postmaster_address = WITHELD<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">protocol lda {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mail_plugins = " fts fts_solr virtual sieve"<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">protocol imap {<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class=""> mail_max_userip_connections = 40<o:p class=""></o:p></code></pre><pre style="margin: 0cm; font-size: 10pt; font-family: "Courier New";" class=""><code style="font-family: "Courier New";" class="">}<o:p class=""></o:p></code></pre></div></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm; font-size: 11pt; font-family: Calibri, sans-serif;" class="">-</div></div></div></blockquote></div><br class=""></div></body></html>