- dovecot - dovecot.org

doveadm dsync-server doesn't use user parameter?
by Harald Leithner 23 Nov '18

23 Nov '18

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@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(a)itronic.at | itronic.at

1 2

Re: LDAP stored quota
by Aki Tuomi 23 Nov '18

23 Nov '18

I noticed that you sent replies to me directly... Anyways, seems the problem was that the LDAP user_attrs is missing commas, and the mailRoutingAddress is used wrong, so the correct syntax would be: user_attrs = \ mailRoutingAddress=user, \ =uid=vmail, \ =gid=mail, \ =home=/var/mail/%d/%n, \ =quota_rule=*:bytes=%{ldap:departmentNumber} Aki > On 22 November 2018 at 15:29 Vincent Seynhaeve <vlamsdoem(a)gmail.com> wrote: > > > doveadm quota recalc -u test doesn't give anything. > Bellow the ouput of the `doveconf -n` and `doveadm user test` > > doveconf -n > # 2.2.10: /etc/dovecot/dovecot.conf > # OS: Linux 3.10.0-862.11.6.el7.x86_64 x86_64 CentOS Linux release 7.5.1804 > (Core) xfs > auth_debug = yes > auth_mechanisms = plain login > auth_verbose = yes > mail_debug = yes > mail_gid = mail > mail_home = /var/mail/%d/%n > mail_location = maildir:/var/mail/%d/%n/Maildir > mail_plugins = " quota" > 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 ihave > mbox_write_locks = fcntl > namespace inbox { > inbox = yes > location = > mailbox Drafts { > special_use = \Drafts > } > mailbox Junk { > special_use = \Junk > } > mailbox Sent { > special_use = \Sent > } > mailbox "Sent Messages" { > special_use = \Sent > } > mailbox Trash { > special_use = \Trash > } > prefix = > } > passdb { > args = /etc/dovecot/dovecot-ldap.conf.ext > driver = ldap > } > plugin { > quota = maildir:User quota > quota_grace = 10%% > quota_rule2 = Trash:storage=+100M > quota_status_nouser = DUNNO > quota_status_overquota = 552 5.2.2 Mailbox is full > quota_status_success = DUNNO > sieve = ~/.dovecot.sieve > sieve_dir = ~/sieve > } > protocols = imap pop3 lmtp sieve > service auth { > unix_listener /var/spool/postfix/private/auth { > group = postfix > mode = 0666 > user = postfix > } > unix_listener auth-userdb { > group = mail > mode = 0600 > user = vmail > } > } > service imap-login { > inet_listener imap { > port = 0 > } > } > service managesieve-login { > inet_listener sieve { > port = 4190 > } > } > service pop3-login { > inet_listener pop3 { > port = 0 > } > inet_listener pop3s { > port = 0 > } > } > ssl = required > ssl_cert = </etc/pki/tls/certs/imap.example.com.crt > ssl_key = </etc/pki/tls/private/imap.example.com.key > userdb { > args = /etc/dovecot/dovecot-ldap.conf.ext > driver = ldap > } > protocol lda { > mail_plugins = " quota sieve" > } > protocol imap { > mail_plugins = " quota imap_quota" > } > > > > > doveadm user test > field value > uid vmail > gid mail > home /var/mail//test > mail maildir:/var/mail//test/Maildir > mailRoutingAddress user =uid=vmail =gid=mail =home=/var/mail//test > =quota_rule=*:bytes=1M > > > Le jeu. 22 nov. 2018 à 14:18, Aki Tuomi <aki.tuomi(a)open-xchange.com> a > écrit : > > > Can you provide output of `doveconf -n` and `doveadm user test`? > > > > Aki > > > > > On 22 November 2018 at 10:44 Maciej Milaszewski IQ PL < > > maciej.milaszewski(a)iq.pl> wrote: > > > > > > > > > Hi > > > Do you try recalc and get ? > > > > > > On 22.11.2018 08:56, Vincent Seynhaeve wrote: > > > > > > > > Hello, > > > > > > > > I'm trying to set up LDAP stored quota on Dovecot but it doesn't work > > > > and doesn't get reported by the command doveadm quota get. > > > > > > > > I'm using the field departmentNumber in my LDAP server to store the > > quota. > > > > > > > > > > > > doveadm quota get -u test > > > > > > > > Quota name Type Value > > > > > > Limit > > > > % > > > > User quota STORAGE 0 > > > > > > - > > > > 0 > > > > User quota MESSAGE 0 > > > > > > - > > > > 0 > > > > > > > > > > > > log file associated with doveadm quota get command: > > > > > > > > Nov 21 11:38:47 imap dovecot: auth: Debug: master in: > > > > USER#0111#011test#011service=doveadm > > > > Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): user search: > > > > base=ou=People,dc=example,dc=com scope=subtree > > > > filter=(&(objectClass=posixAccount)(uid=test)) fields=departmentNumber > > > > Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): result: > > > > departmentNumber=1M; departmentNumber unused > > > > Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): result: > > > > departmentNumber=1M > > > > Nov 21 11:38:47 imap dovecot: auth: Debug: userdb out: > > > > USER#0111#011test#011mailRoutingAddress=user =uid=vmail =gid=mail > > > > =home=/var/mail//test =quota_rule=*:bytes=1M > > > > > > > > > > > > Bellow my configuration files: > > > > > > > > conf.d/10-mail.conf > > > > > > > > mail_plugins = $mail_plugins quota > > > > > > > > > > > > conf.d/20-imap.conf > > > > > > > > > > > > protocol imap { > > > > mail_plugins = $mail_plugins imap_quota > > > > } > > > > > > > > > > > > conf.d/90-quota.conf > > > > > > > > plugin { > > > > > > > > quota = maildir:User quota > > > > quota_rule2 = Trash:storage=+100M > > > > quota_grace = 10%% > > > > quota_status_success = DUNNO > > > > quota_status_nouser = DUNNO > > > > quota_status_overquota = "552 5.2.2 Mailbox is full" > > > > > > > > } > > > > > > > > > > > > dovecot-ldap.conf.ext > > > > > > > > user_attrs= \ > > > > =mailRoutingAddress=user \ > > > > =uid=vmail \ > > > > =gid=mail \ > > > > =home=/var/mail/%d/%n \ > > > > =quota_rule=*:bytes=%{ldap:departmentNumber} > > > > > > > > > > > > Can somebody help me with this or give me some advice for debugging? > > > > > > > > > > > > > -- > > > Maciej Miłaszewski > > > IQ PL Sp. z o.o. > > > Administrator Systemowy > > > > > > Biuro Obsługi Klienta: > > > e-mail: bok(a)iq.pl > > > tel.: +48 58 326 09 90 - 94 > > > fax: +48 58 326 09 99 > > > > > > Dział pomocy: https://www.iq.pl/pomoc > > > Informacja dotycząca przetwarzania danych osobowych: > > https://www.iq.pl/kontakt > > > Jakość gwarantuje: ISO 9001:2000 > > > > > > IQ PL Sp. z o.o. z siedzibą w Gdańsku (80-298), ul. Geodetów 16, KRS > > 0000007725, Sąd rejestrowy: Sąd Rejonowy w Gdańsku VII Wydział KRS, > > > kapitał zakładowy: 140.000 PLN, NIP 5832736211, REGON 192478853 > > > > >

2 1

Core dump during UID Search
by Bert JW Regeer 22 Nov '18

22 Nov '18

Hey all, I keep finding core dumps of the IMAP process on my FreeBSD 11.2, however the backtrace is not very useful: Core was generated by `imap: [xistence(a)0x58.com 2601:282:4301:befc:1cfb:807f:e527:5a3b UID SEARCH]'. Program terminated with signal 6, Aborted. #0 0x0000000011c0c47a in ?? () (gdb) bt #0 0x0000000011c0c47a in ?? () #1 0x0000000011c0c444 in ?? () #2 0x00000000000188b0 in cmd_store () #3 0x0000000011c0c3b9 in ?? () #4 0x0000000012216810 in ?? () #5 0x0000000000000005 in ?? () #6 0xffffffdf00000000 in ?? () #7 0xffffffffffffffff in ?? () #8 0x00007fffffffffff in ?? () #9 0x0000000000000005 in ?? () #10 0x00007fffffffe240 in ?? () #11 0x000000001189c6f6 in ?? () #12 0x0000000012355e28 in ?? () #13 0x00000000122de048 in ?? () #14 0x0000000000000000 in ?? () (gdb) I am sorry that I haven't been able to find any more information or figure out what is going on :-( doveconf -n output follows: doveconf -n # 2.3.2.1 (0719df592): /usr/local/etc/dovecot/dovecot.conf # Pigeonhole version 0.5.2 (7704de5e) # OS: FreeBSD 11.2-RELEASE-p4 amd64 # Hostname: juxi.0x58.com auth_mechanisms = plain login first_valid_gid = 127 first_valid_uid = 127 hostname = butler.0x58.com last_valid_gid = 127 last_valid_uid = 127 lmtp_save_to_detail_mailbox = yes login_greeting = Assume the position. mail_gid = 127 mail_home = /usr/local/vmail/domains/%d/%n mail_location = maildir:~/Maildir/ mail_plugins = " quota trash zlib virtual " mail_uid = 127 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 ihave duplicate namespace butler { hidden = no list = yes location = virtual:/usr/local/vmail/virtual:LAYOUT=maildir++:INDEX=~/virtual mailbox All { auto = subscribe special_use = \All } mailbox Flagged { auto = subscribe special_use = \Flagged } prefix = [Butler]/ separator = / subscriptions = yes type = private } namespace inbox { inbox = yes location = mailbox Drafts { special_use = \Drafts } mailbox Junk { auto = subscribe special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = separator = / subscriptions = yes } passdb { args = scheme=CRYPT username_format=%u /usr/local/vmail/domains/%d/passwd driver = passwd-file } plugin { fts = squat quota = maildir:User quota quota_rule = *:storage=5G quota_rule2 = Trash:storage=+100M quota_rule3 = Deleted Messages:storage=+100M recipient_delimiter = + sieve = ~/.dovecot.sieve sieve_dir = ~/sieve stats_refresh = 30 secs } postmaster_address = postmaster(a)butler.0x58.com protocols = imap lmtp sieve service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } unix_listener auth-userdb { group = vmail mode = 0666 user = vmail } } service imap { drop_priv_before_exec = yes } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0666 user = postfix } } service managesieve-login { inet_listener sieve { port = 4190 } } service stats { fifo_listener stats-mail { mode = 0600 user = vmail } } ssl_cert = </usr/home/letsencrypt/letsencrypt.sh/certs/butler.0x58.com/fullchain.pem ssl_cipher_list = HIGH:!SSLv2:!RC4:!3DES:!aNULL:@STRENGTH ssl_dh = # hidden, use -P to show it ssl_key = # hidden, use -P to show it ssl_prefer_server_ciphers = yes userdb { args = username_format=%u /usr/local/vmail/domains/%d/passwd default_fields = quota_rule=*:storage=3G driver = passwd-file } verbose_proctitle = yes verbose_ssl = yes protocol lmtp { mail_plugins = " quota trash zlib virtual sieve" } protocol lda { mail_plugins = " quota trash zlib virtual sieve" } protocol imap { mail_plugins = " quota trash zlib virtual fts fts_squat imap_quota imap_zlib" }

3 5

Same emails appearing multiple time after upgrade to version 2.33
by Thomas Durand 22 Nov '18

22 Nov '18

Hi, I have update today dovecot and dovecot pigeonhole to the latest version available on my centos 7. It’s a small email servers with postfix/amavisd/clamav/spamasssin. I had dovecot for IMAP/POP3 with spam plugins to store spam message automatically into the spam folder. After the upgrade, I was noticed by some of my users that they have in their message the same message appearing 2,3 even 10 times. I had the same behavior when using roundecube I was able to stop this after removing pigeonhole rpm (removing/disabling the config was not enough). Would appreciate your help to understand what is wrong with my config. Thanks dovecot conf : [root@justyna conf.d]# dovecot -n # 2.3.3 (dcead646b): /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-042stab127.2 x86_64 CentOS Linux release 7.5.1804 (Core) # Hostname: x auth_mechanisms = plain login auth_verbose = yes disable_plaintext_auth = no doveadm_password = # hidden, use -P to show it doveadm_port = 2727 imap_client_workarounds = delay-newmail mail_location = maildir:~/Maildir mail_plugins = " zlib notify replication" mbox_write_locks = fcntl namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Junk { auto = subscribe special_use = \Junk } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Trash { auto = subscribe special_use = \Trash } prefix = } passdb { driver = pam } passdb { args = scheme=CRYPT username_format=%u /etc/dovecot/users driver = passwd-file } plugin { mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size mail_replica = tcp:62.210.220.186:2727 sieve = ~/.dovecot.sieve sieve_dir = ~/sieve sieve_duplicate_default_period = 1h sieve_duplicate_max_period = 1d sieve_extensions = +vnd.dovecot.duplicate sieve_global_dir = /var/lib/dovecot/sieve/ sieve_global_path = /var/lib/dovecot/sieve/default.sieve zlib_save = gz zlib_save_level = 6 } protocols = imap pop3 service aggregator { fifo_listener replication-notify-fifo { mode = 0666 user = vmail } unix_listener replication-notify { mode = 0666 user = vmail } } service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } } service doveadm { inet_listener { port = 2727 } } service imap-login { process_min_avail = 2 service_count = 0 } ssl_ca = /etc/letsencrypt/live/www.cr-avocats.com/lets-encrypt-x3-cross-signed.pem ssl_cert = </etc/letsencrypt/live/mail.cr-avocats.com/cert.pem ssl_client_ca_dir = /etc/ssl/certs/ ssl_client_ca_file = /etc/pki/tls/certs/ca-bundle.trust.crt ssl_dh = # hidden, use -P to show it ssl_key = # hidden, use -P to show it ssl_key_password = # hidden, use -P to show it userdb { driver = passwd } userdb { args = username_format=%u /etc/dovecot/users driver = passwd-file } protocol lmtp { mail_plugins = " zlib notify replication" } protocol lda { mail_plugins = " zlib notify replication zlib sieve" } protocol imap { mail_max_userip_connections = 20 mail_plugins = " zlib notify replication" } Thomas Durand

1 0

LDAP stored quota
by Vincent Seynhaeve 22 Nov '18

22 Nov '18

Hello, I'm trying to set up LDAP stored quota on Dovecot but it doesn't work and doesn't get reported by the command doveadm quota get. I'm using the field departmentNumber in my LDAP server to store the quota. doveadm quota get -u test Quota name Type Value Limit % User quota STORAGE 0 - 0 User quota MESSAGE 0 - 0 log file associated with doveadm quota get command: Nov 21 11:38:47 imap dovecot: auth: Debug: master in: USER#0111#011test#011service=doveadm Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): user search: base=ou=People,dc=example,dc=com scope=subtree filter=(&(objectClass=posixAccount)(uid=test)) fields=departmentNumber Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): result: departmentNumber=1M; departmentNumber unused Nov 21 11:38:47 imap dovecot: auth: Debug: ldap(test): result: departmentNumber=1M Nov 21 11:38:47 imap dovecot: auth: Debug: userdb out: USER#0111#011test#011mailRoutingAddress=user =uid=vmail =gid=mail =home=/var/mail//test =quota_rule=*:bytes=1M Bellow my configuration files: conf.d/10-mail.conf mail_plugins = $mail_plugins quota conf.d/20-imap.conf protocol imap { mail_plugins = $mail_plugins imap_quota } conf.d/90-quota.conf plugin { quota = maildir:User quota quota_rule2 = Trash:storage=+100M quota_grace = 10%% quota_status_success = DUNNO quota_status_nouser = DUNNO quota_status_overquota = "552 5.2.2 Mailbox is full" } dovecot-ldap.conf.ext user_attrs= \ =mailRoutingAddress=user \ =uid=vmail \ =gid=mail \ =home=/var/mail/%d/%n \ =quota_rule=*:bytes=%{ldap:departmentNumber} Can somebody help me with this or give me some advice for debugging?

3 2

unable to configure the ssl certificate in email client
by ChandranManikandan 22 Nov '18

22 Nov '18

Hi Friends, I have installed ssl certificate on my centos 7 server and website is working fine with https. But email client outlook and thunderbird unable to configure it. The certificate unable installed and import these above email clients when tried to configure the email account. Anyone help me. -- *Thanks & Best Regards,Mani*

2 1

Set only, not exclude
by lty＠cndns.com 22 Nov '18

22 Nov '18

SET ONLY, NOT EXCLUDE I WANT TO INDEX ONLY INBOX MESSAGES, NOT OTHER MAILBOXES HTTPS://WIKI.DOVECOT.ORG/PLUGINS/FTS OTHER SETTINGS plugin { fts_autoindex_exclude = \Junk fts_autoindex_exclude2 = \Trash fts_autoindex_exclude3 = DUMPSTER }

1 0

Multi-server but small scale
by Daniel Miller 21 Nov '18

21 Nov '18

I have a small but critical server that supports our group. As a single server - it's obviously a single-point-of-failure for lots of things. As I just experienced...again. It was a lot more fun building systems from components when I was younger... Previously 3rd-party hosted solutions didn't look attractive for several reasons...but I'm seeing prices now for cloud virtual machines that are stupid cheap. Even if they wind up being limited speed & availability - it would seem they'd be a lot better than nothing! So I'm considering having at least one backup server for various services - obviously that includes mail. So now I have to wonder about the backend. And while I think I'm reasonably current with networked file systems (not distributed or cluster) I haven't played with replication for a quite a while. For this particular usage (I'm envisioning two servers total) - is there a need/reason to use any form of networked/distributed/cluster file storage? Or would this be accomplished via "pure" Dovecot - dsync replication would keep things updated between the servers and director would handle the connections? So with identically configured SMTP servers, passing to the local LMTP agents, the file system would be "purely local" with no NFS or other interconnection? -- Daniel

2 1

analysing of dmarc report
by Poliman - Serwis 21 Nov '18

21 Nov '18

I have a problem with understanding dmarc reports and some features. I attach two reports. First one come from google.com, second one from tumieszkamy.pl. On my server is dns zone of domain kamir-transport.pl but whole mail service is deployed on Google - in dns zone MX points to Google and there are all mailboxes, aliases etc. Last time I have configured dkim and dmarc policies and I got two reports. Honestly I don't know why two, from two different providers - google.com and tumieszkamy.pl. Moreover in report originating from google I see IP of my server [which fails spf and dkim policies] and I don't understand why this IP is evaluated? Second thing which I don't understand is second report which I got from tumieszkamy.pl. SPF record in dns zone of domain kamir-transport.pl was looking like below (now I changed it to slightly different): *v=spf1 mx include:_spf.google.com <http://spf.google.com> -all* Does anybody could help uderstand these things? -- *Pozdrawiam / Best Regards* *Piotr Bracha*

1 0

Quota in MySql Dict not recalculate automatic
by SUnsin＠gv-bayern.de 20 Nov '18

20 Nov '18

Hi, I have a working Installation with: Ubuntu 16.04 LTS Dovecot 2.2.22 MySql 5.7.24 Postfixadmin 3.2 Apache 2.4.18 Rainloop 1.12.1 I manage the E-Mail Accounts with postfixadmin in a MySql-DB. Also I use quotas with Quota Backend postfixadmin-DB (dict). Everything works fine. Now I installed a new Server with the following Versions and migrate the Configs to the new System. Ubuntu 18.04 LTS Doveot 2.2.33 MySQL 5.7.24 Postfixadmin 3.2 Apache 2.4.18 Rainloop 1.12.1 The Problem is now: When I receive a E-Mail, the quota will not Update (recalculate) automatical in the MySql-DB from Dovecot. In the old System there execute the SQL Statement after receiving a E-Mail, for example: UPDATE quota2 SET bytes=bytes+3076,messages=messages+1 WHERE username = <E-Mail Address> On the new System with the newer Dovecot Version, the Statement never comes after receive an E-Mail. With Dovecot Version 2.3 on the old System with Ubuntu 16.04, everything works fine with the same config. Is a BUG in the Dovecot Version 2.2.33 possible? Can everbody help me? Kind regards Stephan dovecot -n # 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf # Pigeonhole version 0.4.21 (92477967) # OS: Linux 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS auth_debug = yes auth_debug_passwords = yes auth_master_user_separator = * auth_mechanisms = plain login auth_verbose_passwords = yes dict { sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext } disable_plaintext_auth = no login_greeting = Dovecot ready. mail_debug = yes mail_location = maildir:~/Maildir mail_plugins = " quota" 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 "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = separator = / } passdb { args = /etc/dovecot/master-users driver = passwd-file master = yes pass = yes } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { quota = dict:User Quota::noenforcing:proxy::sqluserquota quota_grace = 10%% quota_status_nouser = DUNNO quota_status_overquota = 552 5.2.2 Mailbox is over quota / Mailbox ist voll quota_status_success = DUNNO quota_warning = storage=95%% quota-warning 95 %u quota_warning2 = storage=80%% quota-warning 80 %u } postmaster_address = postmaster@xxx protocols = " imap lmtp sieve pop3 sieve" service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0666 user = postfix } } service dict { unix_listener dict { group = vmail mode = 0660 user = vmail } } service lmtp { inet_listener lmtp { address = localhost port = 24 } } service managesieve-login { inet_listener sieve { port = 4190 } } service quota-status { client_limit = 1 executable = quota-status -p postfix inet_listener { port = 12340 } } service quota-warning { executable = script /usr/local/bin/quota-warning.sh unix_listener quota-warning { group = vmail mode = 0660 user = vmail } user = vmail } ssl_cert = xxx ssl_key = # hidden, use -P to show it userdb { driver = prefetch } userdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocol lmtp { mail_plugins = " quota" } protocol imap { mail_max_userip_connections = 10 mail_plugins = " quota imap_quota" } grep -v '^ *$#.*$\?$' dovecot-sql.conf : driver = mysql connect = host=localhost dbname=postfixadmin user=pfadmin password=UCLGXEb9rEEOTAO default_pass_scheme = SHA512-CRYPT password_query = \ SELECT username as user, password, '/var/vmail/%Ld/%Ln' as userdb_home, \ 'maildir:/var/vmail/%Ld/%Ln' as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid \ FROM mailbox WHERE username = '%Lu' AND active = '1' user_query = \ SELECT '/var/vmail/%Ld/%Ln' as home, \ 'maildir:/var/vmail/%Ld/%Ln' as mail, \ 5000 AS uid, \ 5000 AS gid, \ concat('*:bytes=', \ if(mailbox.quota = 0, domain.maxquota*1024000, mailbox.quota)) \ as quota_rule \ FROM mailbox, domain \ WHERE username = '%Lu' AND mailbox.active = '1' AND \ domain.domain = '%d' AND domain.active = '1' iterate_query = SELECT username as user FROM mailbox WHERE active = '1' Ref. Systeme / Bereich Digitalisierung und Informationstechnik (IT) Telefon: 089 2868-3280 Telefax: 089 2868-3275 Internet-E-Mail: SUnsin(a)gv-bayern.de Notes-E-Mail: Stephan Unsin@GVB http://www.gv-bayern.de Genossenschaftsverband Bayern e.V. Türkenstrasse 22-24, 80333 München Es gelten die jeweils aktuellen Allgemeinen Auftragsbedingungen des Genossenschaftsverbands Bayern e.V.

2 5