Hi,
I tried to migrate my dovecot 2.2 to a new server with a other storage
configuration and dovecot 2.3.
New (and old) Server uses mysql for user information
I use the following storage settings
mail_home = /storage1/vmail/%{userdb:path}
mail_location
mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path}
userdb:path is generated by the mysql query and ends in something like
"2000/6"
SQL: CONCAT(u.idAccount, '/', u.idUser) AS userdb_path
If I login with imap dovecot is creating the INBOX on the correct path
/storage1/fast/2000/6/mailboxes/INBOX
btw. it creates a link to dbox-alt-root but without creating the target
directory is this expected?
Now if I start
doveadm backup -u <username> remote:mailstore2
it ignores it seams that dsync-server doesn't make a database query and
doesn't use the userdb_path field. It only uses
/storage1/fast/mailboxes/INBOX
as path.
Is this a problem with my configuration?
thx
--- doveconf -n
# 2.3.3 (dcead646b): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.5.3 (f018bbab)
# OS: Linux 4.15.18-7-pve x86_64 Debian 9.6 zfs
# Hostname: mailstore2
auth_cache_negative_ttl = 1 secs
auth_cache_size = 10 M
auth_cache_ttl = 1 secs
auth_master_user_separator = *
auth_mechanisms = PLAIN LOGIN APOP
auth_verbose = yes
default_client_limit = 600
default_vsz_limit = 512 M
dict {
lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
sqlacl = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
disable_plaintext_auth = no
first_valid_gid = 1001
first_valid_uid = 1001
hostname = mailstore2
imap_hibernate_timeout = 1 mins
imap_id_log = *
imap_id_send = *
imap_idle_notify_interval = 10 mins
imap_logout_format = bytes=%i/%o
instance_name = mailstore2
last_valid_gid = 1001
last_valid_uid = 1001
lda_original_recipient_header = X-LDA-Original-To
lmtp_rcpt_check_quota = yes
login_greeting = ITronic Mail Store
login_trusted_networks = 172.22.14.0/24
mail_cache_min_mail_count = 5
mail_gid = vmail
mail_home = /storage1/vmail/%{userdb:path}
mail_location
mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path}
mail_plugins = lazy_expunge acl quota mail_log notify
mail_prefetch_count = 100
mail_server_admin = mailto:postmaster at example.com
mail_server_comment = Mail System
mail_shared_explicit_inbox = yes
mail_uid = vmail
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 vacation-seconds
mdbox_preallocate_space = yes
namespace {
hidden = yes
list = no
location
mdbox:/storage1/fast/%{userdb:path}:MAILBOXDIR=expunged:LISTINDEX=expunged.list.index:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path}
prefix = "#EXPUNGED/"
subscriptions = no
type = private
}
namespace {
list = children
location = mdbox:%%h/mdbox
prefix = "#Users/%%u/"
separator = /
subscriptions = yes
type = shared
}
namespace inbox {
hidden = no
inbox = yes
location mailbox Archvie {
special_use = \Archive
}
mailbox Drafts {
special_use = \Drafts
}
mailbox Sent {
special_use = \Sent
}
mailbox Spam {
special_use = \Junk
}
mailbox Trash {
special_use = \Trash
}
prefix separator = /
subscriptions = yes
type = private
}
passdb {
args = /etc/dovecot/master-users
driver = passwd-file
master = yes
result_success = continue-ok
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
acl = vfile
acl_shared_dict = proxy::sqlacl
last_login_dict = proxy::lastlogin
last_login_key = # hidden, use -P to show it
lazy_expunge = "#EXPUNGED/"
lazy_expunge_only_last_instance = no
mail_log_events = delete undelete expunge copy mailbox_delete
mailbox_rename flag_change save mailbox_create
mail_log_fields = uid box msgid size flags vsize from subject
quota = dict:User quota::proxy::sqlquota
quota_grace = 10%%
quota_rule = *:storage=1024M
quota_rule2 = "#EXPUNGED:storage=+1024M"
quota_warning = storage=100%% quota-warning 100 %u
quota_warning2 = storage=95%% quota-warning 95 %u
quota_warning3 = storage=80%% quota-warning 80 %u
recipient_delimiter = +
sieve = file:~/sieve;active=~/.dovecot.sieve
sieve_before = file:/storage1/vmail/%{userdb:idAccount}/
sieve_extensions = +vacation-seconds
sieve_global = /etc/dovecot/sieve
sieve_max_actions = 64
sieve_max_redirects = 8
sieve_max_script_size = 2M
sieve_quota_max_scripts = 0
sieve_quota_max_storage = 64M
sieve_vacation_default_period = 1d
sieve_vacation_min_period = 1h
}
pop3_uidl_duplicates = rename
protocols = imap lmtp sieve pop3
service auth-worker {
user = $default_internal_user
}
service auth {
inet_listener {
port = 4180
}
unix_listener auth-userdb {
mode = 0666
}
}
service dict {
unix_listener dict {
group = vmail
mode = 0666
}
}
service imap-hibernate {
unix_listener imap-hibernate {
group = vmail
mode = 0666
}
}
service imap-login {
inet_listener imap {
port = 143
}
inet_listener imaps {
port = 993
ssl = yes
}
process_min_avail = 1
service_count = 0
}
service imap {
process_limit = 1024
unix_listener imap-master {
user = dovecot
}
unix_listener imap {
group = vmail
mode = 0666
}
vsz_limit = 512 M
}
service lmtp {
inet_listener lmtp {
address = 172.22.14.136
port = 24000
}
unix_listener lmtp {
mode = 0666
}
}
service managesieve-login {
inet_listener sieve {
port = 4190
}
process_min_avail = 0
service_count = 1
vsz_limit = 64 M
}
service managesieve {
process_limit = 50
}
service pop3-login {
inet_listener pop3 {
port = 110
}
inet_listener pop3s {
port = 995
ssl = yes
}
process_min_avail = 20
service_count = 1
vsz_limit = 64 M
}
service pop3 {
process_limit = 1024
}
service quota-warning {
executable = script /opt/scripts/quota-warning.sh
unix_listener quota-warning {
user = vmail
}
user = dovecot
}
shutdown_clients = no
ssl_cert = </etc/dovecot/private/example.com.pem
ssl_cipher_list
ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA:AES256-SHA:DHE-RSA-CAMELLIA128-SHA:DHE-RSA-CAMELLIA256-SHA:CAMELLIA128-SHA:CAMELLIA256-SHA:ECDHE-RSA-DES-CBC3-SHA:DES-CBC3-SHA
ssl_dh = # hidden, use -P to show it
ssl_key = # hidden, use -P to show it
ssl_options = no_compression
ssl_prefer_server_ciphers = yes
submission_host = 192.168.14.198
syslog_facility = local0
userdb {
driver = prefetch
}
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
valid_chroot_dirs = /storage1
verbose_proctitle = yes
protocol imap {
mail_max_userip_connections = 30
mail_plugins = imap_zlib lazy_expunge quota imap_quota acl imap_acl
last_login mail_log notify
}
protocol lda {
mail_plugins = lazy_expunge acl sieve quota mail_log notify
}
protocol lmtp {
mail_plugins = lazy_expunge acl sieve quota mail_log notify
}
protocol sieve {
mail_max_userip_connections = 10
managesieve_max_compile_errors = 5
managesieve_max_line_length = 65536
}
protocol pop3 {
mail_max_userip_connections = 10
mail_plugins = lazy_expunge acl last_login mail_log notify
}
---
--
Harald Leithner
ITronic
Wiedner Hauptstra?e 120/5.1, 1050 Wien, Austria
Tel: +43-1-545 0 604
Mobil: +43-699-123 78 4 78
Mail: leithner at itronic.at | itronic.at
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 659 bytes
Desc: OpenPGP digital signature
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20181123/fc8ec043/attachment-0001.sig>
I did a debug output of the dsync-server and found out that it queries the userdb parameter but doesn't use it. --- Debug: Loading modules from directory: /usr/lib/dovecot/modules Debug: Module loaded: /usr/lib/dovecot/modules/lib01_acl_plugin.so Debug: Module loaded: /usr/lib/dovecot/modules/lib02_lazy_expunge_plugin.so Debug: Module loaded: /usr/lib/dovecot/modules/lib10_quota_plugin.so Debug: Module loaded: /usr/lib/dovecot/modules/lib15_notify_plugin.so Debug: Module loaded: /usr/lib/dovecot/modules/lib20_mail_log_plugin.so Debug: Loading modules from directory: /usr/lib/dovecot/modules/doveadm Debug: Module loaded: /usr/lib/dovecot/modules/doveadm/lib10_doveadm_acl_plugin.so Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: /usr/lib/dovecot/modules/doveadm/lib10_doveadm_expire_plugin.so: undefined symbol: expire_set_deinit (this is usually intentional, so just ignore this message) Debug: Module loaded: /usr/lib/dovecot/modules/doveadm/lib10_doveadm_quota_plugin.so Debug: Module loaded: /usr/lib/dovecot/modules/doveadm/lib10_doveadm_sieve_plugin.so Debug: Skipping module doveadm_fts_lucene_plugin, because dlopen() failed: /usr/lib/dovecot/modules/doveadm/lib20_doveadm_fts_lucene_plugin.so: undefined symbol: lucene_index_iter_deinit (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: /usr/lib/dovecot/modules/doveadm/lib20_doveadm_fts_plugin.so: undefined symbol: fts_user_get_language_list (this is usually intentional, so just ignore this message) Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() failed: /usr/lib/dovecot/modules/doveadm/libdoveadm_mail_crypt_plugin.so: undefined symbol: mail_crypt_box_get_pvt_digests (this is usually intentional, so just ignore this message) doveadm(user at example.com)<27674><>: Debug: auth USER input: user at example.com userdb_path=2000/6 quota_rule=*:bytes=0M nice=0 uid=1001 gid=1001 doveadm(user at example.com)<27674><>: Debug: Added userdb setting: plugin/quota_rule=*:bytes=0M doveadm(user at example.com)<27674><>: Debug: Added userdb setting: plugin/userdb_path=2000/6 doveadm(user at example.com): Debug: Effective uid=1001, gid=1001, home=/storage1/vmail/ doveadm(user at example.com): Debug: Quota root: name=User quota backend=dict args=:proxy::sqlquota doveadm(user at example.com): Debug: Quota rule: root=User quota mailbox=* bytes=0 messages=0 doveadm(user at example.com): Debug: Quota rule: root=User quota mailbox=#EXPUNGED bytes=+1073741824 messages=0 doveadm(user at example.com): Debug: Quota warning: bytes=0 (100%) messages=0 reverse=no command=quota-warning 100 user at example.com doveadm(user at example.com): Debug: Quota warning: bytes=0 (95%) messages=0 reverse=no command=quota-warning 95 user at example.com doveadm(user at example.com): Debug: Quota warning: bytes=0 (80%) messages=0 reverse=no command=quota-warning 80 user at example.com doveadm(user at example.com): Debug: Quota grace: root=User quota bytes=0 (10%) doveadm(user at example.com): Debug: dict quota: user=user at example.com, uri=proxy::sqlquota, noenforcing=0 doveadm(user at example.com): Debug: Namespace : type=private, prefix=#EXPUNGED/, sep=, inbox=no, hidden=yes, list=no, subscriptions=no location=mdbox:/storage1/fast/:MAILBOXDIR=expunged:LISTINDEX=expunged.list.index:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/:ALT=/storage1/slow/:VOLATILEDIR=/tmp/ doveadm(user at example.com): Debug: fs: root=/storage1/fast, index=/storage1/indexes/vmail, indexpvt=, control=, inbox=, alt=/storage1/slow doveadm(user at example.com): Debug: acl: initializing backend with data: vfile doveadm(user at example.com): Debug: acl: acl username = user at example.com doveadm(user at example.com): Debug: acl: owner = 1 doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled doveadm(user at example.com): Debug: Namespace : type=shared, prefix=#Users/%u/, sep=/, inbox=no, hidden=no, list=children, subscriptions=yes location=mdbox:%h/mdbox doveadm(user at example.com): Debug: shared: root=/var/run/dovecot, index=, indexpvt=, control=, inbox=, altdoveadm(user at example.com): Debug: acl: initializing backend with data: vfile doveadm(user at example.com): Debug: acl: acl username = user at example.com doveadm(user at example.com): Debug: acl: owner = 0 doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled doveadm(user at example.com): Debug: Namespace inbox: type=private, prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes location=mdbox:/storage1/fast/:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/:ALT=/storage1/slow/:VOLATILEDIR=/tmp/ doveadm(user at example.com): Debug: fs: root=/storage1/fast, index=/storage1/indexes/vmail, indexpvt=, control=, inbox=, alt=/storage1/slow doveadm(user at example.com): Debug: acl: initializing backend with data: vfile doveadm(user at example.com): Debug: acl: acl username = user at example.com doveadm(user at example.com): Debug: acl: owner = 1 doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled doveadm(user at example.com): Debug: quota: quota_over_flag check: quota_over_script unset - skipping dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl vfile: file /storage1/fast/mailboxes/dovecot-acl not found dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl vfile: file /storage1/fast/mailboxes/INBOX/iTrNiCs-DBOx-mAiLs/dovecot-acl not found dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl vfile: file /storage1/fast/mailboxes/INBOX/test kontakt/iTrNiCs-DBOx-mAiLs/dovecot-acl not found dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl vfile: file /storage1/fast/mailboxes/INBOX/test/iTrNiCs-DBOx-mAiLs/dovecot-acl not found dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl vfile: file /storage1/fast/mailboxes/INBOX/gsdfg/iTrNiCs-DBOx-mAiLs/dovecot-acl not found dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: Namespace : Using permissions from /storage1/fast: mode=0755 gid=default dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: Namespace #EXPUNGED/: Using permissions from /storage1/fast: mode=0755 gid=default --- Am 23.11.2018 um 12:14 schrieb Harald Leithner:> Hi, > > I tried to migrate my dovecot 2.2 to a new server with a other storage > configuration and dovecot 2.3. > > New (and old) Server uses mysql for user information > > I use the following storage settings > > mail_home = /storage1/vmail/%{userdb:path} > mail_location > mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} > > > userdb:path is generated by the mysql query and ends in something like > "2000/6" > > SQL: CONCAT(u.idAccount, '/', u.idUser) AS userdb_path > > If I login with imap dovecot is creating the INBOX on the correct path > > /storage1/fast/2000/6/mailboxes/INBOX > > btw. it creates a link to dbox-alt-root but without creating the target > directory is this expected? > > Now if I start > > doveadm backup -u <username> remote:mailstore2 > > it ignores it seams that dsync-server doesn't make a database query and > doesn't use the userdb_path field. It only uses > > /storage1/fast/mailboxes/INBOX > > as path. > > Is this a problem with my configuration? > > > thx > > --- doveconf -n > # 2.3.3 (dcead646b): /etc/dovecot/dovecot.conf > # Pigeonhole version 0.5.3 (f018bbab) > # OS: Linux 4.15.18-7-pve x86_64 Debian 9.6 zfs > # Hostname: mailstore2 > auth_cache_negative_ttl = 1 secs > auth_cache_size = 10 M > auth_cache_ttl = 1 secs > auth_master_user_separator = * > auth_mechanisms = PLAIN LOGIN APOP > auth_verbose = yes > default_client_limit = 600 > default_vsz_limit = 512 M > dict { > lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext > sqlacl = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext > sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext > } > disable_plaintext_auth = no > first_valid_gid = 1001 > first_valid_uid = 1001 > hostname = mailstore2 > imap_hibernate_timeout = 1 mins > imap_id_log = * > imap_id_send = * > imap_idle_notify_interval = 10 mins > imap_logout_format = bytes=%i/%o > instance_name = mailstore2 > last_valid_gid = 1001 > last_valid_uid = 1001 > lda_original_recipient_header = X-LDA-Original-To > lmtp_rcpt_check_quota = yes > login_greeting = ITronic Mail Store > login_trusted_networks = 172.22.14.0/24 > mail_cache_min_mail_count = 5 > mail_gid = vmail > mail_home = /storage1/vmail/%{userdb:path} > mail_location > mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} > mail_plugins = lazy_expunge acl quota mail_log notify > mail_prefetch_count = 100 > mail_server_admin = mailto:postmaster at example.com > mail_server_comment = Mail System > mail_shared_explicit_inbox = yes > mail_uid = vmail > 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 vacation-seconds > mdbox_preallocate_space = yes > namespace { > hidden = yes > list = no > location > mdbox:/storage1/fast/%{userdb:path}:MAILBOXDIR=expunged:LISTINDEX=expunged.list.index:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} > prefix = "#EXPUNGED/" > subscriptions = no > type = private > } > namespace { > list = children > location = mdbox:%%h/mdbox > prefix = "#Users/%%u/" > separator = / > subscriptions = yes > type = shared > } > namespace inbox { > hidden = no > inbox = yes > location > mailbox Archvie { > special_use = \Archive > } > mailbox Drafts { > special_use = \Drafts > } > mailbox Sent { > special_use = \Sent > } > mailbox Spam { > special_use = \Junk > } > mailbox Trash { > special_use = \Trash > } > prefix > separator = / > subscriptions = yes > type = private > } > passdb { > args = /etc/dovecot/master-users > driver = passwd-file > master = yes > result_success = continue-ok > } > passdb { > args = /etc/dovecot/dovecot-sql.conf.ext > driver = sql > } > plugin { > acl = vfile > acl_shared_dict = proxy::sqlacl > last_login_dict = proxy::lastlogin > last_login_key = # hidden, use -P to show it > lazy_expunge = "#EXPUNGED/" > lazy_expunge_only_last_instance = no > mail_log_events = delete undelete expunge copy mailbox_delete > mailbox_rename flag_change save mailbox_create > mail_log_fields = uid box msgid size flags vsize from subject > quota = dict:User quota::proxy::sqlquota > quota_grace = 10%% > quota_rule = *:storage=1024M > quota_rule2 = "#EXPUNGED:storage=+1024M" > quota_warning = storage=100%% quota-warning 100 %u > quota_warning2 = storage=95%% quota-warning 95 %u > quota_warning3 = storage=80%% quota-warning 80 %u > recipient_delimiter = + > sieve = file:~/sieve;active=~/.dovecot.sieve > sieve_before = file:/storage1/vmail/%{userdb:idAccount}/ > sieve_extensions = +vacation-seconds > sieve_global = /etc/dovecot/sieve > sieve_max_actions = 64 > sieve_max_redirects = 8 > sieve_max_script_size = 2M > sieve_quota_max_scripts = 0 > sieve_quota_max_storage = 64M > sieve_vacation_default_period = 1d > sieve_vacation_min_period = 1h > } > pop3_uidl_duplicates = rename > protocols = imap lmtp sieve pop3 > service auth-worker { > user = $default_internal_user > } > service auth { > inet_listener { > port = 4180 > } > unix_listener auth-userdb { > mode = 0666 > } > } > service dict { > unix_listener dict { > group = vmail > mode = 0666 > } > } > service imap-hibernate { > unix_listener imap-hibernate { > group = vmail > mode = 0666 > } > } > service imap-login { > inet_listener imap { > port = 143 > } > inet_listener imaps { > port = 993 > ssl = yes > } > process_min_avail = 1 > service_count = 0 > } > service imap { > process_limit = 1024 > unix_listener imap-master { > user = dovecot > } > unix_listener imap { > group = vmail > mode = 0666 > } > vsz_limit = 512 M > } > service lmtp { > inet_listener lmtp { > address = 172.22.14.136 > port = 24000 > } > unix_listener lmtp { > mode = 0666 > } > } > service managesieve-login { > inet_listener sieve { > port = 4190 > } > process_min_avail = 0 > service_count = 1 > vsz_limit = 64 M > } > service managesieve { > process_limit = 50 > } > service pop3-login { > inet_listener pop3 { > port = 110 > } > inet_listener pop3s { > port = 995 > ssl = yes > } > process_min_avail = 20 > service_count = 1 > vsz_limit = 64 M > } > service pop3 { > process_limit = 1024 > } > service quota-warning { > executable = script /opt/scripts/quota-warning.sh > unix_listener quota-warning { > user = vmail > } > user = dovecot > } > shutdown_clients = no > ssl_cert = </etc/dovecot/private/example.com.pem > ssl_cipher_list > ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA:AES256-SHA:DHE-RSA-CAMELLIA128-SHA:DHE-RSA-CAMELLIA256-SHA:CAMELLIA128-SHA:CAMELLIA256-SHA:ECDHE-RSA-DES-CBC3-SHA:DES-CBC3-SHA > ssl_dh = # hidden, use -P to show it > ssl_key = # hidden, use -P to show it > ssl_options = no_compression > ssl_prefer_server_ciphers = yes > submission_host = 192.168.14.198 > syslog_facility = local0 > userdb { > driver = prefetch > } > userdb { > args = /etc/dovecot/dovecot-sql.conf.ext > driver = sql > } > valid_chroot_dirs = /storage1 > verbose_proctitle = yes > protocol imap { > mail_max_userip_connections = 30 > mail_plugins = imap_zlib lazy_expunge quota imap_quota acl imap_acl > last_login mail_log notify > } > protocol lda { > mail_plugins = lazy_expunge acl sieve quota mail_log notify > } > protocol lmtp { > mail_plugins = lazy_expunge acl sieve quota mail_log notify > } > protocol sieve { > mail_max_userip_connections = 10 > managesieve_max_compile_errors = 5 > managesieve_max_line_length = 65536 > } > protocol pop3 { > mail_max_userip_connections = 10 > mail_plugins = lazy_expunge acl last_login mail_log notify > } > --- >-- Harald Leithner ITronic Wiedner Hauptstra?e 120/5.1, 1050 Wien, Austria Tel: +43-1-545 0 604 Mobil: +43-699-123 78 4 78 Mail: leithner at itronic.at | itronic.at -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 659 bytes Desc: OpenPGP digital signature URL: <https://dovecot.org/pipermail/dovecot/attachments/20181123/9dc9ec74/attachment.sig>
j4i 2.3.4 doesn't fix this problem Am 23.11.2018 um 13:26 schrieb Harald Leithner:> I did a debug output of the dsync-server and found out that it queries > the userdb parameter but doesn't use it. > > --- > Debug: Loading modules from directory: /usr/lib/dovecot/modules > Debug: Module loaded: /usr/lib/dovecot/modules/lib01_acl_plugin.so > Debug: Module loaded: /usr/lib/dovecot/modules/lib02_lazy_expunge_plugin.so > Debug: Module loaded: /usr/lib/dovecot/modules/lib10_quota_plugin.so > Debug: Module loaded: /usr/lib/dovecot/modules/lib15_notify_plugin.so > Debug: Module loaded: /usr/lib/dovecot/modules/lib20_mail_log_plugin.so > Debug: Loading modules from directory: /usr/lib/dovecot/modules/doveadm > Debug: Module loaded: > /usr/lib/dovecot/modules/doveadm/lib10_doveadm_acl_plugin.so > Debug: Skipping module doveadm_expire_plugin, because dlopen() failed: > /usr/lib/dovecot/modules/doveadm/lib10_doveadm_expire_plugin.so: > undefined symbol: expire_set_deinit (this is usually intentional, so > just ignore this message) > Debug: Module loaded: > /usr/lib/dovecot/modules/doveadm/lib10_doveadm_quota_plugin.so > Debug: Module loaded: > /usr/lib/dovecot/modules/doveadm/lib10_doveadm_sieve_plugin.so > Debug: Skipping module doveadm_fts_lucene_plugin, because dlopen() > failed: > /usr/lib/dovecot/modules/doveadm/lib20_doveadm_fts_lucene_plugin.so: > undefined symbol: lucene_index_iter_deinit (this is usually intentional, > so just ignore this message) > Debug: Skipping module doveadm_fts_plugin, because dlopen() failed: > /usr/lib/dovecot/modules/doveadm/lib20_doveadm_fts_plugin.so: undefined > symbol: fts_user_get_language_list (this is usually intentional, so just > ignore this message) > Debug: Skipping module doveadm_mail_crypt_plugin, because dlopen() > failed: > /usr/lib/dovecot/modules/doveadm/libdoveadm_mail_crypt_plugin.so: > undefined symbol: mail_crypt_box_get_pvt_digests (this is usually > intentional, so just ignore this message) > doveadm(user at example.com)<27674><>: Debug: auth USER input: > user at example.com userdb_path=2000/6 quota_rule=*:bytes=0M nice=0 > uid=1001 gid=1001 > doveadm(user at example.com)<27674><>: Debug: Added userdb setting: > plugin/quota_rule=*:bytes=0M > doveadm(user at example.com)<27674><>: Debug: Added userdb setting: > plugin/userdb_path=2000/6 > doveadm(user at example.com): Debug: Effective uid=1001, gid=1001, > home=/storage1/vmail/ > doveadm(user at example.com): Debug: Quota root: name=User quota > backend=dict args=:proxy::sqlquota > doveadm(user at example.com): Debug: Quota rule: root=User quota mailbox=* > bytes=0 messages=0 > doveadm(user at example.com): Debug: Quota rule: root=User quota > mailbox=#EXPUNGED bytes=+1073741824 messages=0 > doveadm(user at example.com): Debug: Quota warning: bytes=0 (100%) > messages=0 reverse=no command=quota-warning 100 user at example.com > doveadm(user at example.com): Debug: Quota warning: bytes=0 (95%) > messages=0 reverse=no command=quota-warning 95 user at example.com > doveadm(user at example.com): Debug: Quota warning: bytes=0 (80%) > messages=0 reverse=no command=quota-warning 80 user at example.com > doveadm(user at example.com): Debug: Quota grace: root=User quota bytes=0 (10%) > doveadm(user at example.com): Debug: dict quota: user=user at example.com, > uri=proxy::sqlquota, noenforcing=0 > doveadm(user at example.com): Debug: Namespace : type=private, > prefix=#EXPUNGED/, sep=, inbox=no, hidden=yes, list=no, subscriptions=no > location=mdbox:/storage1/fast/:MAILBOXDIR=expunged:LISTINDEX=expunged.list.index:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/:ALT=/storage1/slow/:VOLATILEDIR=/tmp/ > doveadm(user at example.com): Debug: fs: root=/storage1/fast, > index=/storage1/indexes/vmail, indexpvt=, control=, inbox=, > alt=/storage1/slow > doveadm(user at example.com): Debug: acl: initializing backend with data: vfile > doveadm(user at example.com): Debug: acl: acl username = user at example.com > doveadm(user at example.com): Debug: acl: owner = 1 > doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled > doveadm(user at example.com): Debug: Namespace : type=shared, > prefix=#Users/%u/, sep=/, inbox=no, hidden=no, list=children, > subscriptions=yes location=mdbox:%h/mdbox > doveadm(user at example.com): Debug: shared: root=/var/run/dovecot, index=, > indexpvt=, control=, inbox=, alt> doveadm(user at example.com): Debug: acl: initializing backend with data: vfile > doveadm(user at example.com): Debug: acl: acl username = user at example.com > doveadm(user at example.com): Debug: acl: owner = 0 > doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled > doveadm(user at example.com): Debug: Namespace inbox: type=private, > prefix=, sep=/, inbox=yes, hidden=no, list=yes, subscriptions=yes > location=mdbox:/storage1/fast/:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/:ALT=/storage1/slow/:VOLATILEDIR=/tmp/ > doveadm(user at example.com): Debug: fs: root=/storage1/fast, > index=/storage1/indexes/vmail, indexpvt=, control=, inbox=, > alt=/storage1/slow > doveadm(user at example.com): Debug: acl: initializing backend with data: vfile > doveadm(user at example.com): Debug: acl: acl username = user at example.com > doveadm(user at example.com): Debug: acl: owner = 1 > doveadm(user at example.com): Debug: acl vfile: Global ACLs disabled > doveadm(user at example.com): Debug: quota: quota_over_flag check: > quota_over_script unset - skipping > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl > vfile: file /storage1/fast/mailboxes/dovecot-acl not found > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl > vfile: file > /storage1/fast/mailboxes/INBOX/iTrNiCs-DBOx-mAiLs/dovecot-acl not found > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl > vfile: file /storage1/fast/mailboxes/INBOX/test > kontakt/iTrNiCs-DBOx-mAiLs/dovecot-acl not found > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl > vfile: file > /storage1/fast/mailboxes/INBOX/test/iTrNiCs-DBOx-mAiLs/dovecot-acl not found > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: acl > vfile: file > /storage1/fast/mailboxes/INBOX/gsdfg/iTrNiCs-DBOx-mAiLs/dovecot-acl not > found > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: Namespace > : Using permissions from /storage1/fast: mode=0755 gid=default > dsync-remote(user at example.com)<CkATLXru91sabAAAUTwJdA>: Debug: Namespace > #EXPUNGED/: Using permissions from /storage1/fast: mode=0755 gid=default > --- > > > Am 23.11.2018 um 12:14 schrieb Harald Leithner: >> Hi, >> >> I tried to migrate my dovecot 2.2 to a new server with a other storage >> configuration and dovecot 2.3. >> >> New (and old) Server uses mysql for user information >> >> I use the following storage settings >> >> mail_home = /storage1/vmail/%{userdb:path} >> mail_location >> mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} >> >> >> userdb:path is generated by the mysql query and ends in something like >> "2000/6" >> >> SQL: CONCAT(u.idAccount, '/', u.idUser) AS userdb_path >> >> If I login with imap dovecot is creating the INBOX on the correct path >> >> /storage1/fast/2000/6/mailboxes/INBOX >> >> btw. it creates a link to dbox-alt-root but without creating the target >> directory is this expected? >> >> Now if I start >> >> doveadm backup -u <username> remote:mailstore2 >> >> it ignores it seams that dsync-server doesn't make a database query and >> doesn't use the userdb_path field. It only uses >> >> /storage1/fast/mailboxes/INBOX >> >> as path. >> >> Is this a problem with my configuration? >> >> >> thx >> >> --- doveconf -n >> # 2.3.3 (dcead646b): /etc/dovecot/dovecot.conf >> # Pigeonhole version 0.5.3 (f018bbab) >> # OS: Linux 4.15.18-7-pve x86_64 Debian 9.6 zfs >> # Hostname: mailstore2 >> auth_cache_negative_ttl = 1 secs >> auth_cache_size = 10 M >> auth_cache_ttl = 1 secs >> auth_master_user_separator = * >> auth_mechanisms = PLAIN LOGIN APOP >> auth_verbose = yes >> default_client_limit = 600 >> default_vsz_limit = 512 M >> dict { >> lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext >> sqlacl = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext >> sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext >> } >> disable_plaintext_auth = no >> first_valid_gid = 1001 >> first_valid_uid = 1001 >> hostname = mailstore2 >> imap_hibernate_timeout = 1 mins >> imap_id_log = * >> imap_id_send = * >> imap_idle_notify_interval = 10 mins >> imap_logout_format = bytes=%i/%o >> instance_name = mailstore2 >> last_valid_gid = 1001 >> last_valid_uid = 1001 >> lda_original_recipient_header = X-LDA-Original-To >> lmtp_rcpt_check_quota = yes >> login_greeting = ITronic Mail Store >> login_trusted_networks = 172.22.14.0/24 >> mail_cache_min_mail_count = 5 >> mail_gid = vmail >> mail_home = /storage1/vmail/%{userdb:path} >> mail_location >> mdbox:/storage1/fast/%{userdb:path}:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} >> mail_plugins = lazy_expunge acl quota mail_log notify >> mail_prefetch_count = 100 >> mail_server_admin = mailto:postmaster at example.com >> mail_server_comment = Mail System >> mail_shared_explicit_inbox = yes >> mail_uid = vmail >> 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 vacation-seconds >> mdbox_preallocate_space = yes >> namespace { >> hidden = yes >> list = no >> location >> mdbox:/storage1/fast/%{userdb:path}:MAILBOXDIR=expunged:LISTINDEX=expunged.list.index:FULLDIRNAME=iTrNiCs-DBOx-mAiLs:INDEX=/storage1/indexes/vmail/%{userdb:path}:ALT=/storage1/slow/%{userdb:path}:VOLATILEDIR=/tmp/%{userdb:path} >> prefix = "#EXPUNGED/" >> subscriptions = no >> type = private >> } >> namespace { >> list = children >> location = mdbox:%%h/mdbox >> prefix = "#Users/%%u/" >> separator = / >> subscriptions = yes >> type = shared >> } >> namespace inbox { >> hidden = no >> inbox = yes >> location >> mailbox Archvie { >> special_use = \Archive >> } >> mailbox Drafts { >> special_use = \Drafts >> } >> mailbox Sent { >> special_use = \Sent >> } >> mailbox Spam { >> special_use = \Junk >> } >> mailbox Trash { >> special_use = \Trash >> } >> prefix >> separator = / >> subscriptions = yes >> type = private >> } >> passdb { >> args = /etc/dovecot/master-users >> driver = passwd-file >> master = yes >> result_success = continue-ok >> } >> passdb { >> args = /etc/dovecot/dovecot-sql.conf.ext >> driver = sql >> } >> plugin { >> acl = vfile >> acl_shared_dict = proxy::sqlacl >> last_login_dict = proxy::lastlogin >> last_login_key = # hidden, use -P to show it >> lazy_expunge = "#EXPUNGED/" >> lazy_expunge_only_last_instance = no >> mail_log_events = delete undelete expunge copy mailbox_delete >> mailbox_rename flag_change save mailbox_create >> mail_log_fields = uid box msgid size flags vsize from subject >> quota = dict:User quota::proxy::sqlquota >> quota_grace = 10%% >> quota_rule = *:storage=1024M >> quota_rule2 = "#EXPUNGED:storage=+1024M" >> quota_warning = storage=100%% quota-warning 100 %u >> quota_warning2 = storage=95%% quota-warning 95 %u >> quota_warning3 = storage=80%% quota-warning 80 %u >> recipient_delimiter = + >> sieve = file:~/sieve;active=~/.dovecot.sieve >> sieve_before = file:/storage1/vmail/%{userdb:idAccount}/ >> sieve_extensions = +vacation-seconds >> sieve_global = /etc/dovecot/sieve >> sieve_max_actions = 64 >> sieve_max_redirects = 8 >> sieve_max_script_size = 2M >> sieve_quota_max_scripts = 0 >> sieve_quota_max_storage = 64M >> sieve_vacation_default_period = 1d >> sieve_vacation_min_period = 1h >> } >> pop3_uidl_duplicates = rename >> protocols = imap lmtp sieve pop3 >> service auth-worker { >> user = $default_internal_user >> } >> service auth { >> inet_listener { >> port = 4180 >> } >> unix_listener auth-userdb { >> mode = 0666 >> } >> } >> service dict { >> unix_listener dict { >> group = vmail >> mode = 0666 >> } >> } >> service imap-hibernate { >> unix_listener imap-hibernate { >> group = vmail >> mode = 0666 >> } >> } >> service imap-login { >> inet_listener imap { >> port = 143 >> } >> inet_listener imaps { >> port = 993 >> ssl = yes >> } >> process_min_avail = 1 >> service_count = 0 >> } >> service imap { >> process_limit = 1024 >> unix_listener imap-master { >> user = dovecot >> } >> unix_listener imap { >> group = vmail >> mode = 0666 >> } >> vsz_limit = 512 M >> } >> service lmtp { >> inet_listener lmtp { >> address = 172.22.14.136 >> port = 24000 >> } >> unix_listener lmtp { >> mode = 0666 >> } >> } >> service managesieve-login { >> inet_listener sieve { >> port = 4190 >> } >> process_min_avail = 0 >> service_count = 1 >> vsz_limit = 64 M >> } >> service managesieve { >> process_limit = 50 >> } >> service pop3-login { >> inet_listener pop3 { >> port = 110 >> } >> inet_listener pop3s { >> port = 995 >> ssl = yes >> } >> process_min_avail = 20 >> service_count = 1 >> vsz_limit = 64 M >> } >> service pop3 { >> process_limit = 1024 >> } >> service quota-warning { >> executable = script /opt/scripts/quota-warning.sh >> unix_listener quota-warning { >> user = vmail >> } >> user = dovecot >> } >> shutdown_clients = no >> ssl_cert = </etc/dovecot/private/example.com.pem >> ssl_cipher_list >> ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA:AES256-SHA:DHE-RSA-CAMELLIA128-SHA:DHE-RSA-CAMELLIA256-SHA:CAMELLIA128-SHA:CAMELLIA256-SHA:ECDHE-RSA-DES-CBC3-SHA:DES-CBC3-SHA >> ssl_dh = # hidden, use -P to show it >> ssl_key = # hidden, use -P to show it >> ssl_options = no_compression >> ssl_prefer_server_ciphers = yes >> submission_host = 192.168.14.198 >> syslog_facility = local0 >> userdb { >> driver = prefetch >> } >> userdb { >> args = /etc/dovecot/dovecot-sql.conf.ext >> driver = sql >> } >> valid_chroot_dirs = /storage1 >> verbose_proctitle = yes >> protocol imap { >> mail_max_userip_connections = 30 >> mail_plugins = imap_zlib lazy_expunge quota imap_quota acl imap_acl >> last_login mail_log notify >> } >> protocol lda { >> mail_plugins = lazy_expunge acl sieve quota mail_log notify >> } >> protocol lmtp { >> mail_plugins = lazy_expunge acl sieve quota mail_log notify >> } >> protocol sieve { >> mail_max_userip_connections = 10 >> managesieve_max_compile_errors = 5 >> managesieve_max_line_length = 65536 >> } >> protocol pop3 { >> mail_max_userip_connections = 10 >> mail_plugins = lazy_expunge acl last_login mail_log notify >> } >> --- >> >-- Harald Leithner ITronic Wiedner Hauptstra?e 120/5.1, 1050 Wien, Austria Tel: +43-1-545 0 604 Mobil: +43-699-123 78 4 78 Mail: leithner at itronic.at | itronic.at -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 659 bytes Desc: OpenPGP digital signature URL: <https://dovecot.org/pipermail/dovecot/attachments/20181123/87c64afc/attachment.sig>