<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><font face="Calibri">Thank you for pointing me to
the source. Unfortunately I am running Plesk on my server and
thus relying on the plesk-dovecot package to ensure the seamless
integration with the rest of the packages. <br>
<br>
Besides being behind a few months on the updates Plesk also
still recommends using fts_squat
(<a class="moz-txt-link-freetext" href="https://support.plesk.com/hc/en-us/articles/115000532574-The-search-speed-is-slow-in-Roundcube-or-Horde">https://support.plesk.com/hc/en-us/articles/115000532574-The-search-speed-is-slow-in-Roundcube-or-Horde</a>)
so it seems I'm stuck here.<br>
<br>
Thanks and cheers<br>
Benjamin<br>
</font></font><br>
<div class="moz-cite-prefix">Am 20.03.2019 um 21:40 schrieb Aki
Tuomi via dovecot:<br>
</div>
<blockquote type="cite"
cite="mid:1586808439.1663.1553114400631@appsuite-dev-gw1.open-xchange.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta charset="UTF-8">
<div> We provide packages at <a class="moz-txt-link-freetext" href="https://repo.dovecot.org">https://repo.dovecot.org</a> - maybe you
can use these? </div>
<div> <br>
</div>
<div> Aki </div>
<blockquote type="cite">
<div> On 20 March 2019 22:19 Benjamin Godbersen via dovecot
<a class="moz-txt-link-rfc2396E" href="mailto:dovecot@dovecot.org"><dovecot@dovecot.org></a> wrote: </div>
<div> <br>
</div>
<div> <br>
</div>
<span style="font-family: Calibri;">Hi Michael,<br>
<br>
thanks for getting back to me. I understand the alternatives
to squat are solr and lucene and have to be explicitly
included into dovecot at compilation. Unfortunately I am not
in a position to manually compile dovecot.<br>
<br>
What other option do I have to use full text search in dovecot
without manually compilating my package?<br>
<br>
Thanks and cheers<br>
Benjamin<br>
</span> <br>
<div class="moz-cite-prefix"> Am 20.03.2019 um 20:31 schrieb
Michael Slusarz via dovecot: <br>
</div>
<blockquote type="cite">
<div> fts_squat was deprecated in 2.1. There's a high
likelihood it is buggy in a variety of ways in any recent
Dovecot release. <br>
</div>
<div> <br>
</div>
<div> michael <br>
</div>
<div> <br>
</div>
<blockquote type="cite"> On March 20, 2019 at 1:21 PM Benjamin
Godbersen via dovecot <a href="mailto:dovecot@dovecot.org"
class="moz-txt-link-rfc2396E" moz-do-not-send="true"><dovecot@dovecot.org></a>
wrote: <br>
<br>
<span style="font-family: Calibri;">Hi everyone,<br>
<br>
I have now updated to dovecot 2.3.4.1 - unfortunately the
issue still persists. Can anyone help me figure out if
this is due to a misconfiguration on my part or another
error?<br>
<br>
Any help is greatly appreciated!<br>
<br>
Cheers<br>
Benjamin<br>
</span> <br>
<div class="ox-b3ec39a82c-moz-cite-prefix"> Am 14.03.2019 um
23:28 schrieb <a href="mailto:benjamin@godbersen.info"
class="ox-b3ec39a82c-moz-txt-link-abbreviated"
moz-do-not-send="true">benjamin@godbersen.info</a>: <br>
</div>
<blockquote type="cite"> <span style="font-family:
Calibri;">Hi everyone,<br>
<br>
I am running into a problem when trying to use fts_squat
in a virtual folder. Without fts_squat plugin the search
(from, subject...) works in all folders. With activated
fts the search on the inbox folders works expectedly
well but any attempt to search anything in any virtual
folder leads to the following error. Similarly when
attempting "doveadm fts lookup". I also noticed that no
search index for the virtual folders gets build - is
this expected behaviour?<br>
</span>
<blockquote> <span style="font-family: Calibri;">Mar 14
23:14:58 *** dovecot: service=imap, user=***,
ip=[::1]. Panic: file mail-storage.c: line 1913
(mailbox_get_open_status): assertion failed:
(box->opened)</span> <br>
<span style="font-family: Calibri;">Mar 14 23:14:58 ***
dovecot: service=imap, user=***, ip=[::1]. Error: Raw
backtrace:
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(+0xba731)
[0x7f553a7ff731] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(+0xba7fa)
[0x7f553a7ff7fa] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(i_fatal+0)
[0x7f553a771638] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot-storage.so.0(mailbox_get_open_status+0x68)
[0x7f553aae4a78] ->
/usr/lib/dovecot/modules/lib21_fts_squat_plugin.so(+0x3684)
[0x7f553677a684] ->
/usr/lib/dovecot/modules/lib21_fts_squat_plugin.so(+0x3820)
[0x7f553677a820] ->
/usr/lib/dovecot/modules/lib20_fts_plugin.so(fts_backend_lookup_multi+0x163)
[0x7f5539b016a3] ->
/usr/lib/dovecot/modules/lib20_fts_plugin.so(+0xd728)
[0x7f5539b06728] ->
/usr/lib/dovecot/modules/lib20_fts_plugin.so(fts_search_lookup+0xeb)
[0x7f5539b06bbb] ->
/usr/lib/dovecot/modules/lib20_fts_plugin.so(+0xf8b8)
[0x7f5539b088b8] ->
dovecot/imap(imap_search_start+0x6a) [0x5654cb5a0d6a]
-> dovecot/imap(cmd_sort+0x293) [0x5654cb593553]
-> dovecot/imap(command_exec+0x64) [0x5654cb599874]
-> dovecot/imap(+0x1bd22) [0x5654cb597d22] ->
dovecot/imap(+0x1bdbc) [0x5654cb597dbc] ->
dovecot/imap(client_handle_input+0x1b5)
[0x5654cb5981c5] -> dovecot/imap(client_input+0xa4)
[0x5654cb5987e4] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(io_loop_call_io+0x69)
[0x7f553a8174a9] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(io_loop_handler_run_internal+0x12e)
[0x7f553a818d1e] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(io_loop_handler_run+0x4c)
[0x7f553a8175ac] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(io_loop_run+0x38)
[0x7f553a8177b8] ->
/usr/lib/x86_64-linux-gnu/dovecot/libdovecot.so.0(master_service_run+0x13)
[0x7f553a7940a3] -> dovecot/imap(main+0x339)
[0x5654cb58a539] ->
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xe7)
[0x7f553a375b97] -> dovecot/imap(_start+0x2a)
[0x5654cb58a71a]</span> <br>
<span style="font-family: Calibri;">Mar 14 23:14:58 ***
dovecot: service=imap, user=***, ip=[::1]. Fatal:
master: service(imap): child 6436 killed with signal 6
(core dumps disabled)<br>
</span> </blockquote>
<span style="font-family: Calibri;">This is my config:<br>
</span>
<blockquote> <span style="font-family: Calibri;">#
2.3.0.1 (ffd8a29): /etc/dovecot/dovecot.conf<br>
# Pigeonhole version 0.5.0.1 (d33dca20)<br>
# OS: Linux 4.15.0-46-generic x86_64 Ubuntu 18.04.2
LTS ext4<br>
auth_mechanisms = plain login digest-md5 cram-md5 apop<br>
auth_username_chars =
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890&.-_@'<br>
default_vsz_limit = 8096 M<br>
disable_plaintext_auth = no<br>
first_valid_uid = 30<br>
imap_client_workarounds = delay-newmail<br>
imap_logout_format = rcvd=%i, sent=%o<br>
mail_home = /var/qmail/mailnames/%Ld/%Ln<br>
mail_location =
maildir:/var/qmail/mailnames/%Ld/%Ln/Maildir<br>
mail_log_prefix = "service=%s, user=%u, ip=[%r]. "<br>
mail_max_userip_connections = 100<br>
mail_plugins = quota fts fts_squat virtual<br>
managesieve_logout_format = rcvd=%i, sent=%o<br>
managesieve_notify_capability = mailto<br>
managesieve_sieve_capability = fileinto reject
envelope encoded-character vacation subaddress
comparator-i;ascii-numeri$<br>
namespace inbox {<br>
inbox = yes<br>
location =<br>
prefix = INBOX.<br>
separator = .<br>
}<br>
namespace virtual {<br>
hidden = no<br>
inbox = no<br>
list = yes<br>
location =
virtual:/var/qmail/mailnames/%Ld/%Ln/virtual/:INDEX=/var/qmail/mailnames/%Ld/%Ln/virtual/<br>
prefix =<br>
separator = .<br>
}<br>
passdb {<br>
driver = plesk<br>
}<br>
plugin {<br>
fts = squat<br>
fts_squat = partial=4 full=10<br>
quota = maildir:User quota<br>
quota_grace = 0<br>
sieve = ~/.dovecot.sieve<br>
sieve_dir = ~/sieve<br>
sieve_extensions = +notify +imapflags<br>
}<br>
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh<br>
pop3_logout_format = rcvd=%i, sent=%o, top=%t/%p,
retr=%r/%b, del=%d/%m, size=%s<br>
protocols = imap pop3 sieve<br>
service auth-worker {<br>
group =<br>
user =<br>
}<br>
service auth {<br>
group =<br>
unix_listener auth-userdb {<br>
group = popuser<br>
mode = 0600<br>
user = popuser<br>
}<br>
user =<br>
}<br>
service imap-login {<br>
process_limit = 2048<br>
service_count = 1<br>
}<br>
service imap {<br>
process_limit = 2048<br>
service_count = 1<br>
}<br>
service pop3-login {<br>
process_limit = 2048<br>
service_count = 1<br>
}<br>
service pop3 {<br>
process_limit = 2048<br>
service_count = 1<br>
}<br>
ssl_cert = </etc/dovecot/private/dovecot.pem<br>
ssl_cipher_list = HIGH:!aNULL:!MD5<br>
ssl_dh = # hidden, use -P to show it<br>
ssl_key = # hidden, use -P to show it<br>
ssl_prefer_server_ciphers = yes<br>
userdb {<br>
args = uid=popuser gid=popuser<br>
driver = static<br>
}<br>
protocol imap {<br>
mail_plugins = quota fts fts_squat virtual
imap_quota<br>
}<br>
protocol pop3 {<br>
pop3_uidl_format = UID%u-%v<br>
}<br>
protocol sieve {<br>
mail_plugins = quota fts fts_squat virtual<br>
}<br>
protocol lda {<br>
mail_plugins = quota fts fts_squat virtual sieve<br>
}<br>
</span> </blockquote>
<span style="font-family: Calibri;">dovecot --version
-> 2.3.0.1 (ffd8a29)<br>
<br>
I will be greatful for any tips hinting me on how to
resolve this behaviour. Thank you very much in advance<br>
Benjamin<br>
</span> <br>
<br>
<br>
<br>
<span style="font-family: Calibri;"><br>
<br>
</span> </blockquote>
<br>
</blockquote>
<div class="default-style"> <br>
</div>
</blockquote>
<br>
</blockquote>
<div> <br>
</div>
<div class="io-ox-signature">
<pre>---
Aki Tuomi</pre>
</div>
</blockquote>
<br>
</body>
</html>