- dovecot - dovecot.org

[Dovecot] Enable mail logger plugin
by Alexandre Ellert 20 Feb '14

20 Feb '14

Hello, I'm trying to get more info about user activity (especially when they delete some email). So, I follow info from http://wiki2.dovecot.org/Plugins/MailLog to enabled mail logger plugin, but I don't see anything in my logs. Can you tell me what I'm missing ? Thanks. # doveconf -n # 2.2.10.3: /etc/dovecot/dovecot.conf # OS: Linux 3.2.0-4-amd64 x86_64 Debian 7.4 ext4 auth_mechanisms = plain login base_dir = /var/run/dovecot/ hostname = mail.numeezy.com imap_capability = +XLIST lda_mailbox_autocreate = yes listen = 188.165.154.169 login_greeting = Ready. mail_gid = 5000 mail_location = maildir:/var/vmail/%d/%n/Maildir mail_plugins = quota mail_log notify mail_privileged_group = mail mail_uid = 5000 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 "Sent Messages" { special_use = \Sent } mailbox Trash { auto = subscribe special_use = \Trash } mailbox name { special_use = \Drafts \Junk \Sent \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } plugin { antispam_backend = mailtrain antispam_mail_notspam = --ham antispam_mail_sendmail = /usr/local/bin/sa-learn-pipe.sh antispam_mail_spam = --spam antispam_spam = Junk antispam_trash = Trash mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size quota = dict:user::file:/var/vmail/%d/%n/.quotausage quota_grace = 10%% quota_rule = Trash:storage=+200M quota_warning = storage=95%% quota-warning 95 %u quota_warning2 = storage=80%% quota-warning 80 %u sieve = /var/vmail/%d/%n/.sieve sieve_before = /etc/dovecot/sieve_before sieve_vacation_send_from_recipient = yes } postmaster_address = postmaster(a)numeezy.com protocols = imap pop3 service auth-worker { user = vmail } service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = vmail mode = 0600 user = vmail } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 ssl = yes } service_count = 1 } service pop3-login { inet_listener pop3 { port = 110 } inet_listener pop3s { port = 995 ssl = yes } service_count = 1 } service quota-warning { executable = script /usr/local/bin/quota-warning.sh unix_listener quota-warning { mode = 0666 user = vmail } user = vmail } ssl_cert = </etc/postfix/smtpd.cert ssl_key = </etc/postfix/smtpd.key userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } protocol lda { mail_plugins = sieve quota } protocol imap { mail_max_userip_connections = 80 mail_plugins = quota imap_quota antispam } protocol pop3 { mail_max_userip_connections = 30 mail_plugins = quota }

4 6

[Dovecot] dovecot with maildir not using mtime on reindex
by Richard Platel 20 Feb '14

20 Feb '14

Hi. It seems that dovecot is using the current time, not a maildir file's mtime for INTERNALDATE when a message is re-indexed: $ cd Index $ rm -rf .INBOX $ cd ../Maildir/cur $ stat * File: `1392914632.P54451Q0M08633.smtpin01,S=2215,W=2249:2,' Size: 960 Blocks: 8 IO Block: 1048576 regular file Device: 36h/54d Inode: 11132959 Links: 1 Access: (0600/-rw-------) Uid: ( 8/ mail) Gid: ( 8/ mail) Access: 2012-01-01 00:00:00.000000000 +0000 Modify: 2012-01-01 00:00:00.000000000 +0000 Change: 2014-02-20 16:46:20.000000000 +0000 Birth: - $ telnet imap01 143 Trying 10.5.45.1... Connected to imap01.dev.firefly.tucows.com. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE AUTH=PLAIN] Dovecot ready. A LOGIN rplatel(a)ff-dev.com ******** A OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE QUOTA] Logged in A SELECT INBOX * FLAGS (\Answered \Flagged \Deleted \Seen \Draft) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft \*)] Flags permitted. * 1 EXISTS * 0 RECENT * OK [UNSEEN 1] First unseen. * OK [UIDVALIDITY 1265835133] UIDs valid * OK [UIDNEXT 4548] Predicted next UID A OK [READ-WRITE] Select completed (0.035 secs). A FETCH 1:* FULL * 1 FETCH (FLAGS () INTERNALDATE "20-Feb-2014 16:59:51 +0000" RFC822.SIZE 2249 ENVELOPE ("Thu, 20 Feb 2014 11:43:50 -0500" "Test message" (("Richard Platel" NIL "rplatel" "tucows.com")) (("Richard Platel" NIL "rplatel" "tucows.com")) (("Richard Platel" NIL "rplatel" "tucows.com")) ((NIL NIL "rplatel" "ff-dev.com")) NIL NIL NIL "<BED6EB46-CC88-4BDB-AE8B-98C1CDEAD67C(a)tucows.com>") BODY ("text" "plain" ("charset" "us-ascii") NIL NIL "7bit" 23 4)) A OK Fetch completed. A LOGOUT * BYE Logging out A OK Logout completed. Connection closed by foreign host. $ date Thu Feb 20 16:59:58 UTC 2014 Stracing the imap process, it seems dovecot does not stat the message file at all. Performing the above with an old dovecot 1 server yields the expected result, the INTERNALDATE of the message is the file's mtime. $ dovecot -n -c /he/dovecot/conf/dovecot.conf # 2.2.10.3: /he/dovecot/conf/dovecot.conf # OS: Linux 3.4.46-dom0-2.0.0 x86_64 Debian 7.0 debug_log_path = syslog disable_plaintext_auth = no first_valid_uid = 8 info_log_path = syslog lock_method = dotlock log_timestamp = mail_fsync = always mail_gid = mail mail_nfs_index = yes mail_nfs_storage = yes mail_plugins = zlib quota tc_mail_log notify tc_proc mail_temp_dir = /var/run/dovecot_tmp mail_uid = mail maildir_very_dirty_syncs = yes 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 mmap_disable = yes namespace inbox { inbox = yes location = prefix = } passdb { args = host=localhost port=1143 username=%L{user}::%L{service}::%L{rip}::%L{session} driver = imap } plugin { antispam_backend = pipe antispam_debug_target = syslog antispam_pipe_program = /he/dovecot/utils/he_spamtrain.pl antispam_pipe_program_args = --user=%u antispam_pipe_program_notspam_arg = --falsepositive antispam_pipe_program_spam_arg = --missed antispam_pipe_tmpdir = /var/run/dovecot_as_tmp antispam_signature_missing = move antispam_spam = Spam;Inbox.Spam;INBOX.Spam;Junk;INBOX.Junk antispam_trash_pattern_ignorecase = trash mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename flag_change append mail_log_fields = uid box msgid flags hetag memcached_servers = 10.5.47.223,10.5.47.222 zlib_save = gz zlib_save_level = 6 } protocols = imap pop3 service anvil { unix_listener anvil-auth-penalty { mode = 00 } } service imap-login { inet_listener imap { address = 0 } inet_listener imaps { port = 0 } process_limit = 29 process_min_avail = 14 service_count = 0 } service imap-postlogin { executable = script-login -d /he/dovecot/utils/post_login.sh } service imap { executable = imap imap-postlogin process_limit = 1270 vsz_limit = 0 } service pop3-login { inet_listener pop3 { address = 0 } inet_listener pop3s { port = 0 } process_limit = 29 process_min_avail = 14 service_count = 0 } service pop3-postlogin { executable = script-login -d /he/dovecot/utils/post_login.sh } service pop3 { executable = pop3 pop3-postlogin process_limit = 206 vsz_limit = 512 M } ssl = no userdb { args = /he/dovecot/conf/dovecot-tc-dict-auth.conf driver = dict } verbose_proctitle = yes protocol imap { mail_max_userip_connections = 30 mail_plugins = zlib quota tc_mail_log notify tc_proc imap_quota antispam } protocol pop3 { mail_max_userip_connections = 30 pop3_uidl_format = %08Xv%08Xu }

1 1

[Dovecot] Syntax of pattern in map section
by da-dovecotlist-15＠abelonline.de 20 Feb '14

20 Feb '14

I can't seem to find any documentation on the meaning/syntax of the "pattern" variable in map sections that are found in dovecot-dict-sql.conf.ext for example. I am trying to setup shared folders. The only thing[1] I found is: >>First you'll need to know what kind of dict paths the code uses. ACL >>plugin uses these paths: >> >>shared/shared-boxes/anyone/$owner >>shared/shared-boxes/user/$user/$owner >>shared/shared-boxes/group/$group/$owner What is a "dict path"? Is this some kind of hard coded identifier in the Dovecot code? I need to understand how they work because I can't use the example in http://wiki2.dovecot.org/SharedMailboxes/Shared. This is because in my PostreSQL table users are not a single column but two columns with the local and domain part[2]: Table "public.shared_mailboxes" Column | Type -----------------------+------------------------ shared_mailbox_local | character varying(64) shared_mailbox_domain | character varying(253) shared_to_local | character varying(64) shared_to_domain | character varying(253) How should a map section look in this case? [1]http://www.dovecot.org/list/dovecot/2009-April/038922.html [2]I did this in order to use REFERENCES to ensure the user exist. Kind regards

2 1

[Dovecot] v1.x vs v2.x
by Jos Chrispijn 20 Feb '14

20 Feb '14

Should I migrate to v2 or are there no significant pro's on this migration? Thanks! -- Best regards, Jos Chrispijn --- Artificial intelligence is no match for natural stupidity

3 2

[Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'
by Thomas Creutz 20 Feb '14

20 Feb '14

Hi List, I have a problem with dovecot 2.2.12 and sieve-filter call: su -c 'sieve-filter -D -v -W -C -u account(a)domain.tld /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail gives me sieve-filter(vmail): Error: user account(a)domain.tld: Auth USER lookup failed sieve-filter(vmail): Fatal: Internal error occurred. Refer to server log for more information. on log file I see this: Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause' Feb 17 16:21:34 mail1 dovecot: auth-worker(8430): Error: sql(account(a)domain.tld): User query failed: Unknown column 'filter' in 'where clause' but I never used filter in dovecot: grep -iR filter /etc/dovecot/ gives me no result (and yes the dir is right). Any Idea whats wrong? I know it tells me, that the column is missing in the Database - but why I need it? I also never see it documented somewhere: http://wiki2.dovecot.org/AuthDatabase/SQL http://wiki2.dovecot.org/PasswordDatabase/ExtraFields Thomas

2 6

[Dovecot] virtualfolders all mails minus duplicates
by Francesco 19 Feb '14

19 Feb '14

Hello everyone, i'm trying to mess up a bit with virtual folders and i'm trying to perform something like this: i'd like to create an IMAP virtual folder which shows me all the emails in in INBOX and subfolders but by removing "duplicates" what i mean as duplicates? simply i can recognize duplicate emails as the ones with the same message-id in the header (this was just an idea). in that way if i have a message which is present in more then one folder then it's displayed only once. i considered the idea of using message-id in the header as a criteria, but i don't know if this can be done in this way or in any way at all. any suggestion is really welcome. i'm using dovecot 1.2.15. this is a namespace example just for reference: for INBOX: namespace private { separator = . prefix = INBOX. #subscriptions = yes #list = no inbox = yes } for virtuals: namespace private { prefix = v. separator = . location = virtual:/var/utenti/%Ld/%n/VirtualFolders list = yes inbox = no subscriptions = yes hidden = no } as of now i'm running a virtualfolder which shows messages flagged as important which is done like this: INBOX INBOX.* all flagged hope you can provide me with some hints. Thanks very much Francesco

2 1

[Dovecot] Use header from instead envelope sender - quota exceed
by pgala 19 Feb '14

19 Feb '14

Hi, i want use dovecot and plugin quota to inform users about exceeded space. I also configure postfix to rewrite envelope_sender so envelope_sender<>header: from. Dovecot sent mail with information about exceeded space to email in envelope_sender. It is possible to configure that dovecot sent mail to header from address? I need use sender_canonical_maps in postfix because i want also relay mail outgoing. Thanks for helping me, Piotr -- View this message in context: http://dovecot.2317879.n4.nabble.com/Use-header-from-instead-envelope-sende… Sent from the Dovecot mailing list archive at Nabble.com.

3 2

[Dovecot] Filtering spam in an offlineimap + dovecot setup
by Alan Schmitt 19 Feb '14

19 Feb '14

Hello, To easily access my mail both offline on my computer and on my phone, I am synchronizing a local copy on my computer using offlineimap. As the spam filtering options provided on the server are not sufficient, I am now looking into client-side spam filtering. My current setup is as follows. Mail is synchronized using offlineimap, and delivered to a local dovecot server: --8<---------------cut here---------------start------------->8--- [Repository LocalIMAP] type = IMAP preauthtunnel = /usr/local/Cellar/dovecot/2.2.10/libexec/dovecot/imap -c ~/.dovecotzimbra.rc --8<---------------cut here---------------end--------------->8--- The configuration of the local server is simply: --8<---------------cut here---------------start------------->8--- protocols = imap mail_location = maildir:~/.Maildir/zimbra:INBOX=~/.Maildir/zimbra/.INBOX --8<---------------cut here---------------end--------------->8--- I then read my mail using gnus, and index it using notmuch. A suggestion I've been considering is use the pigeonhole sieve extprograms plugin (http://wiki2.dovecot.org/Pigeonhole/Sieve/Plugins/Extprograms) to call the spam filter (I've been looking at dspam at the moment). However, I could not find how to configure the use of sieves in the context of offlineimap. Hence my questions: Is it possible to use dovecot sieves in such a setting? Is there a howto that explains how to do it? Should I try to do things in a different way? (I'm ready to change my setup, as long as I can keep an offline copy of my email in sync with a server copy.) Thanks a lot for any suggestion, Alan PS: I used to use SpamSieve (http://c-command.com/spamsieve/) on a Mac Mini that was running continuously as a spam filter drone. This machine has been retired and I'm basically looking for leaner ways to do a similar thing.

5 9

[Dovecot] dovecot antispam plugin not found
by Alan Schmitt 19 Feb '14

19 Feb '14

Hello, I'm trying to setup dovecot-antispam, and even though the configuration and the installation seem to have gone well, dovecot is telling me it's not finding it. Here is the symptom: schmitta@top-wifi ~> /usr/local/Cellar/dovecot/2.2.10/libexec/dovecot/imap -c ~/.dovecotzimbra.rc Fatal: Plugin 'antispam' not found from directory /usr/local/Cellar/dovecot/2.2.10/lib/dovecot However there seems to be a plugin there: schmitta@top-wifi ~> ls -al /usr/local/Cellar/dovecot/2.2.10/lib/dovecot/ | grep antispam -rwxr-xr-x 1 schmitta admin 38460 18 fév 22:40 lib90_antispam_plugin.bundle I note that it is the only plugin with the ".bundle" extension, if it's important. My configuration file is as follows (I'm not finished with the antispam configuration yet): --8<---------------cut here---------------start------------->8--- protocols = imap mail_location = maildir:~/.Maildir/zimbra:INBOX=~/.Maildir/zimbra/.INBOX default_login_user = _dovenull default_internal_user = _dovecot protocol imap { # mail_plugins = $mail_plugins antispam } protocol lda { log_path = ~/.logs/dovecot-lda-errors.log info_log_path = ~/.logs/dovecot-lda.log mail_plugins = $mail_plugins sieve } plugin { sieve = ~/.dovecot.sieve sieve_plugins = sieve_extprograms sieve_extensions = +vnd.dovecot.filter sieve_filter_bin_dir = /usr/local/lib/dovecot/sieve-filter antispam_backend = DSPAM antispam_signature = X-DSPAM-Signature } --8<---------------cut here---------------end--------------->8--- Should I do something special to be able to load the antispam plugin? Thanks, Alan

2 3

[Dovecot] Virtual folder for selected users only? (1.2.15)
by Sebastian Schäfer 19 Feb '14

19 Feb '14

hi, i want to set up virtual folders just for some users on our mailserver. the server is set up with a virtual system-user for each of our clients having multiple mailboxes/users (provided by dovecot-mysql). mailboxes are located: /var/mails/SYSUSER/MAILBOX f.e. my mailbox-folder is set to /var/mails/bergschaf/sebastian[at]bergschaf.net {homedir} = /var/mails {maildir} = bergschaf/sebastian[at]bergschaf.net user_query = SELECT homedir AS home, concat('maildir:', maildir) AS mail, uid, gid, concat('maildir:storage=', (quota*1024)) as quota FROM mail_users WHERE username = '%u' now i want to add virtual folders to my mailbox without affecting any other client/mailbox on the server. i already tried to add a namespace "virtual" like mentioned in the wiki and in some other hotwo-guides, but this points to the need to create a "virtual"-folder for each mailbox what i would like to avoid. (f.e. location = %h/%u/virtual => /var/mails/sebastian[at]bergschaf.net). is it possible to enable a namespace just for some selected users on the server? if that's not possible - i'm not sure how to set the location-directive correctly, because i can't find a variable pointing to the maildir: %u => sebastian[at]bergschaf.net %h => /var/mails ...but how should i point the location to {homedir}/{maildir}/virtual? thanks! sebastian dovecot --version 1.2.15

4 3