<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>It seems you are not using mailbox_list_index=yes, I suspect you
want to turn this on. It might help with this problem, too.</p>
<p>Aki<br>
</p>
<div class="moz-cite-prefix">On 8.10.2019 8.09, Erik de Waard via
dovecot wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAENcd0bUqDTNnX1wLvzDsr74Ba9-BS5LQqhzVSJKbPvrV=AFHw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"># 2.3.4.1 (f79e8e7e4): /etc/dovecot/dovecot.conf<br>
<div><br>
</div>
<div>Hello, we're using mail on NFS and the indexes on
localdisk, with a director setup. (18K+ users) now to get more
performance i thought to use the ITERINDEX option. however
this has the side-effect on some mailboxes that it doesn't
show the subfolders under INBOX.</div>
<div>they seem 'disappeared'. Removing the ITERINDEX option
fixes this again.</div>
<div><br>
</div>
<div>Deleting the local indexes to be recreated doesn't solve
the problem.</div>
<div>What could cause this? and how to fix it.</div>
<div><br>
</div>
<div># 2.3.4.1 (f79e8e7e4): /etc/dovecot/dovecot.conf<br>
# Pigeonhole version 0.5.4 ()<br>
# OS: Linux 4.9.0-11-amd64 x86_64 Debian 9.11 <br>
# Hostname: somemail.host.domain<br>
auth_cache_negative_ttl = 0<br>
auth_cache_size = 10 M<br>
auth_cache_ttl = 1 days<br>
auth_username_chars =
"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@#"<br>
default_client_limit = 1500<br>
default_vsz_limit = 1 G<br>
disable_plaintext_auth = no<br>
info_log_path = /dev/null<br>
listen = *<br>
log_timestamp = "%Y-%m-%d %H:%M:%S "<br>
login_trusted_networks = <a href="http://10.0.10.0/24"
moz-do-not-send="true">10.0.10.0/24</a><br>
mail_fsync = never<br>
mail_max_userip_connections = 100<br>
mail_prefetch_count = 10<br>
mail_privileged_group = mail<br>
mailbox_list_index_include_inbox = yes<br>
mmap_disable = yes<br>
namespace inbox {<br>
inbox = yes<br>
location = <br>
mailbox Drafts {<br>
special_use = \Drafts<br>
}<br>
mailbox Junk {<br>
special_use = \Junk<br>
}<br>
mailbox Sent {<br>
special_use = \Sent<br>
}<br>
mailbox "Sent Messages" {<br>
special_use = \Sent<br>
}<br>
mailbox Trash {<br>
special_use = \Trash<br>
}<br>
prefix = INBOX.<br>
separator = .<br>
type = private<br>
}<br>
passdb {<br>
args = username_format=%{rip} /etc/dovecot/passdb<br>
default_fields = noauthenticate=y<br>
driver = passwd-file<br>
}<br>
passdb {<br>
args = /etc/dovecot/dovecot-sql.conf<br>
driver = sql<br>
}<br>
plugin {<br>
sieve_execute_bin_dir = /etc/dovecot/sieve-executables<br>
sieve_global_extensions = +vnd.dovecot.execute<br>
sieve_plugins = sieve_extprograms<br>
}<br>
protocols = imap lmtp<br>
service anvil {<br>
unix_listener anvil-auth-penalty {<br>
mode = 0600<br>
}<br>
}<br>
service auth {<br>
user = root<br>
}<br>
service imap-login {<br>
client_limit = 6000<br>
process_limit = 4<br>
process_min_avail = 4<br>
service_count = 0<br>
vsz_limit = 600 M<br>
}<br>
service imap {<br>
client_limit = 1<br>
process_limit = 1024<br>
service_count = 50<br>
}<br>
service lmtp {<br>
inet_listener lmtp {<br>
port = 24<br>
}<br>
}<br>
ssl = no<br>
ssl_cert = </etc/dovecot/dovecot.crt<br>
ssl_key = # hidden, use -P to show it<br>
userdb {<br>
driver = prefetch<br>
}<br>
userdb {<br>
args = /etc/dovecot/dovecot-sql.conf<br>
driver = sql<br>
}<br>
verbose_proctitle = yes<br>
protocol lmtp {<br>
mail_fsync = optimized<br>
mail_plugins = " sieve"<br>
plugin {<br>
sieve = ~/filters.sieve<br>
sieve_after = /etc/dovecot/sieve/after.sieve<br>
sieve_before = /etc/dovecot/sieve/before.sieve<br>
}<br>
userdb {<br>
args = /etc/dovecot/dovecot-sql-lmtp.conf<br>
driver = sql<br>
name = <br>
}<br>
}<br>
</div>
<div><br>
</div>
<div>dovecot-sql.conf</div>
<div>driver = mysql <br>
connect = host=10.0.10.150 dbname=maildb user=mail
password=5ecret!<br>
default_pass_scheme = SHA <br>
password_query = select login as user, crypt_sha1 as password,
home as userdb_home, uid AS userdb_uid, gid AS userdb_gid,
concat('maildir:',maildir,':INDEX=/data/indexes/',login,':ITERINDEX',':VOLATILEDIR=/data/indexes/',login)
as userdb_mail from mailbox left join aliases on
aliases.systemid = aliasid where login = '%u' and inactive =
0;<br>
user_query = select home, maildir as mail, uid, gid from
mailbox left join aliases on aliases.systemid = aliasid where
login = '%u' and inactive = 0;<br>
iterate_query = select distinct login as user from mailbox;<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</blockquote>
</body>
</html>