On 2021-12-04 22.18, I wrote:
> Hi there,
>
> I've updated Dovecot from v2.3.14 (cee3cbc0d) to v2.3.17 (e2aa53df5b).
> Right after the update, dovecot begun flooding the mail.log and
> PostgreSQL's log.
> ...
just in case someone has missed `doveconf -n` output and SQL related
configuration files, they are attached now.
Let me know if you have any questions.
Regards,
Pascal
--
The trapper recommends today: face1e55.2135...@localdomain.org# 2.3.17 (e2aa53df5b): /usr/local/etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.17 (054dddfa)
# OS: Linux 5.15.0-2-amd64 x86_64 Debian bookworm/sid
# Hostname: host.example.org
auth_mechanisms = plain login cram-md5
auth_verbose = yes
auth_verbose_passwords = plain
base_dir = /var/run/dovecot
debug_log_path = /var/log/dovecot_dbg.log
dict {
quota = pgsql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
}
first_valid_gid = 7
first_valid_uid = 7
hostname = mail.example.org
import_environment = TZ CORE_OUTOFMEM=yeah CORE_ERROR=1
listen = 203.0.113.143, 127.0.0.1, ::1, 2001:db8::143
lmtp_save_to_detail_mailbox = yes
login_access_sockets = tcpwrap
mail_access_groups = dovemail
mail_location = mdbox:~/mdbox
mail_plugins = quota old_stats zlib
managesieve_notify_capability = mailto
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
namespace inbox {
inbox = yes
location =
mailbox Drafts {
special_use = \Drafts
}
mailbox Junk {
special_use = \Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
mailbox name {
special_use = \Drafts \Junk \Sent \Trash
}
prefix =
separator = /
}
passdb {
args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
old_stats_refresh = 1min
quota = dict:user:%{uid}:noenforcing:proxy::quota
quota_rule = *:storage=2G:messages=0
quota_rule2 = Trash:storage=+100M
recipient_delimiter = +
sieve = ~/.dovecot.sieve
sieve_dir = ~/sieve
zlib_save = bz2
zlib_save_level = 6
}
postmaster_address = postmas...@example.org
protocols = lmtp pop3 imap sieve
service auth-worker {
unix_listener auth-worker {
group = $default_internal_user
mode = 0660
user = doveauth
}
user = doveauth
}
service auth {
client_limit = 1425
unix_listener /var/spool/postfix/private/dovecot-auth {
group = postfix
mode = 0600
user = postfix
}
user = doveauth
}
service dict {
idle_kill = 150 secs
unix_listener dict {
group = dovemail
mode = 0660
}
}
service imap-login {
process_limit = 256
}
service imap {
process_limit = 256
}
service lmtp {
executable = lmtp -D
inet_listener lmtp {
address = ::1 127.0.0.1
port = 24
}
unix_listener /var/spool/postfix/private/dovecot-lmtp {
group = postfix
mode = 0600
user = postfix
}
}
service old-stats {
executable = old-stats
fifo_listener old-stats-mail {
mode = 0666
}
fifo_listener old-stats-user {
mode = 0666
}
unix_listener old-stats {
mode = 0666
}
}
service tcpwrap {
unix_listener login/tcpwrap {
group = $default_login_user
mode = 0600
user = $default_login_user
}
}
ssl = required
ssl_cert =
dovecot-dict-sql.conf.ext
Description: application/vnd.novadigm.ext
dovecot-sql.conf.ext
Description: application/vnd.novadigm.ext