Android mail client capable of utilizing FTS?
Hello
I enabled FTS Full Text Search using Tika in dovecot and have all the emails now reindexed. Using either "IMAP by hand" (ie via telnet or openssl s_client), SOGo webmail, or Thunderbird on macOS, I can search for and also find emails based on text which is only in a PDF attachment.
Using Thunderbird or the now dead k-9, I'm not finding anything.
Can someone maybe suggest an email client for Android which is able to find emails based on text in FTS? Technically, I guess it should do a "search TEXT "foo bar"" query.
Here's a complete session done in "IMAP by hand":
$ openssl s_client -crlf -connect my-sys:993 …
read R BLOCK
- OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE LITERAL+ AUTH=PLAIN AUTH=LOGIN] Dovecot ready. a LOGIN myuser@sysd pass a OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW STATUS=SIZE SAVEDATE LITERAL+ NOTIFY METADATA SPECIAL-USE COMPRESS=DEFLATE QUOTA ACL RIGHTS=texk] Logged in b SELECT INBOX
- FLAGS (\Answered \Flagged \Deleted \Seen \Draft $label1 Drausssen $Forwarded $activity $label3 $stopped)
- OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft $label1 Drausssen $Forwarded $activity $label3 $stopped \*)] Flags permitted.
- 10 EXISTS
- 0 RECENT
- OK [UNSEEN 8] First unseen.
- OK [UIDVALIDITY 1671377672] UIDs valid
- OK [UIDNEXT 1709] Predicted next UID
- OK [HIGHESTMODSEQ 2613] Highest b OK [READ-WRITE] Select completed (0.001 + 0.000 secs). c SEARCH TEXT "Veloplatzreservierung"
- SEARCH 3 c OK Search completed (0.042 + 0.000 + 0.041 secs).
d FETCH 3 (BODY.PEEK[HEADER.FIELDS (Message-ID Date)])
- 3 FETCH (BODY[HEADER.FIELDS (MESSAGE-ID DATE)] {124} Message-Id: <202504100258.53A2waba008043-53A2wabb008043@mailqueue01.leuchter-cloud.ch> Date: 10 Apr 2025 04:58:36 +0200
) d OK Fetch completed (0.001 + 0.000 secs). z LOGOUT
- BYE Logging out z OK Logout completed (0.001 + 0.000 secs). closed
Alexander
Hello
I enabled FTS Full Text Search using Tika in dovecot and have all the emails now reindexed. Using either "IMAP by hand" (ie via telnet or openssl s_client), SOGo webmail, or Thunderbird on macOS, I can search for and also find emails based on text which is only in a PDF attachment.
Using Thunderbird or the now dead k-9, I'm not finding anything.
Can someone maybe suggest an email client for Android which is able to find emails based on text in FTS? Technically, I guess it should do a "search TEXT "foo bar"" query.
Here's a complete session done in "IMAP by hand":
$ openssl s_client -crlf -connect my-sys:993 …
read R BLOCK
- OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE LITERAL+ AUTH=PLAIN AUTH=LOGIN] Dovecot ready. a LOGIN myuser@sysd pass a OK [CAPABILITY IMAP4rev1 SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS BINARY MOVE SNIPPET=FUZZY PREVIEW=FUZZY PREVIEW STATUS=SIZE SAVEDATE LITERAL+ NOTIFY METADATA SPECIAL-USE COMPRESS=DEFLATE QUOTA ACL RIGHTS=texk] Logged in b SELECT INBOX
- FLAGS (\Answered \Flagged \Deleted \Seen \Draft $label1 Drausssen $Forwarded $activity $label3 $stopped)
- OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft $label1 Drausssen $Forwarded $activity $label3 $stopped \*)] Flags permitted.
- 10 EXISTS
- 0 RECENT
- OK [UNSEEN 8] First unseen.
- OK [UIDVALIDITY 1671377672] UIDs valid
- OK [UIDNEXT 1709] Predicted next UID
- OK [HIGHESTMODSEQ 2613] Highest b OK [READ-WRITE] Select completed (0.001 + 0.000 secs). c SEARCH TEXT "Veloplatzreservierung"
- SEARCH 3 c OK Search completed (0.042 + 0.000 + 0.041 secs).
d FETCH 3 (BODY.PEEK[HEADER.FIELDS (Message-ID Date)])
- 3 FETCH (BODY[HEADER.FIELDS (MESSAGE-ID DATE)] {124} Message-Id: <202504100258.53A2waba008043-53A2wabb008043@mailqueue01.leuchter- cloud.ch> Date: 10 Apr 2025 04:58:36 +0200
) d OK Fetch completed (0.001 + 0.000 secs). z LOGOUT
- BYE Logging out z OK Logout completed (0.001 + 0.000 secs). closed
Alexander
On 2025-04-20, Alexander Skwar via dovecot <dovecot@dovecot.org> wrote:
I enabled FTS Full Text Search using Tika in dovecot and have all the emai= ls now reindexed=2E Using either "IMAP by hand" (ie via telnet or openssl s= _client), SOGo webmail, or Thunderbird on macOS, I can search for and also = find emails based on text which is only in a PDF attachment=2E
Using Thunderbird or the now dead k-9, I'm not finding anything=2E
Can someone maybe suggest an email client for Android which is able to fin= d emails based on text in FTS? Technically, I guess it should do a "search = TEXT "foo bar"" query=2E
I'm using aquamail which does FTS, I would expect fairemail to do so too.
On 4/20/2025 2:06 PM, Stuart Henderson via dovecot wrote:
On 2025-04-20, Alexander Skwar via dovecot <dovecot@dovecot.org> wrote:
I enabled FTS Full Text Search using Tika in dovecot and have all the emai= ls now reindexed=2E Using either "IMAP by hand" (ie via telnet or openssl s= _client), SOGo webmail, or Thunderbird on macOS, I can search for and also = find emails based on text which is only in a PDF attachment=2E
Using Thunderbird or the now dead k-9, I'm not finding anything=2E
Can someone maybe suggest an email client for Android which is able to fin= d emails based on text in FTS? Technically, I guess it should do a "search = TEXT "foo bar"" query=2E
I'm using aquamail which does FTS, I would expect fairemail to do so too. Fairemail supports IMAP FTS, it indicates any server-side missing search capabilities where appropriate. It works well with dovecot in my experience.
https://github.com/M66B/FairEmail/blob/master/FAQ.md#faq13
Tom.
participants (3)
-
Alexander Skwar
-
Stuart Henderson
-
Tom Talpey