August 2010 - dovecot

[Dovecot] expire plugin
by Arnaud2 bali 04 Aug '10

04 Aug '10

Hi I try to use expire plugin with mysql When i use my thunderbird client to delete a message, nothing is write in the mysql database. My maildir is look like /home/vmail/homes/arnaud2(a)xxx.xxxx.xxx/ and /etc/dovecot/dovecot-dict-expire.conf : connect = host=localhost user=xxxxxx password=xxxxxxxxx dbname=postfixadmin map { pattern = /home/vmail/homes/$user/$mailbox #shared/expire/$user/$mailbox table = dovecot_expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } Is pattern ok ? My detail configuration : # dovecot --version 1.2.11 # dovecot -n # 1.2.11: /etc/dovecot/dovecot.conf # OS: Linux 2.6.26-2-amd64 x86_64 Debian 5.0.5 log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap imaps pop3s managesieve disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login login_executable(managesieve): /usr/lib/dovecot/managesieve-login mail_privileged_group: mail mail_location: maildir:/%h mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugins(default): quota expire imap_quota autocreate mail_plugins(imap): quota expire imap_quota autocreate mail_plugins(pop3): quota expire autocreate mail_plugins(managesieve): mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve lda: postmaster_address: xxx(a)xxxxxxxx.xx mail_plugins: quota expire sieve autocreate auth_socket_path: /var/run/dovecot/auth-master auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 384 user: vmail plugin: quota: maildir expire: .Trash 1 .Trash/* 1 .Spam 2 expire_dict: proxy::expire sieve: ~/.dovecot.sieve sieve_after: /home/vmail/sieve/default.sieve autocreate: Trash autocreate2: Spam autocreate3: Sent autocreate4: Inbox autocreate5: Drafts autocreate6: Templates autosubscribe: Trash autosubscribe2: Spam autosubscribe3: Sent autosubscribe4: Inbox autosubscribe5: Drafts autosubscribe6: Templates dict: expire: mysql:/etc/dovecot/dovecot-dict-expire.conf # cat /etc/dovecot/dovecot-dict-expire.conf connect = host=localhost user=xxxxxx password=xxxxxxxxx dbname=postfixadmin map { pattern = /home/vmail/homes/$user/$mailbox #shared/expire/$user/$mailbox table = dovecot_expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } mysql> desc dovecot_expires; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | username | varchar(255) | NO | PRI | NULL | | | mailbox | varchar(255) | NO | PRI | NULL | | | expire_stamp | int(11) | NO | | NULL | | +--------------+--------------+------+-----+---------+-------+ # cat /etc/dovecot/dovecot-sql.conf driver = mysql connect = host=localhost user=xxxxxxx password=xxxxxxx dbname=postfixadmin user_query = SELECT CONCAT('/home/vmail/homes/',maildir) AS home, 65500 AS uid, 65500 AS gid, \ CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule \ FROM mailbox WHERE username = "%u" AND active=1 password_query = SELECT username as user, password, maildir as userdb_home, 65500 as userdb_uid, 65500 as userdb_gid FROM mailbox WHERE username = '%u' AND active=1 Thank you

2 4

[Dovecot] Dovecot 2.0.rc3 Capability response
by Christian Affolter 04 Aug '10

04 Aug '10

Hi I have a question regarding the IMAP CAPABILITY command behavior of Dovecot 2.0.rc3. While connecting to a Dovecot 1.2.4 server and requesting the supported capabilities, Dovecot returns all capabilities: * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN] Dovecot ready. a1 CAPABILITY * CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH ACL RIGHTS=texk QUOTA AUTH=PLAIN AUTH=CRAM-MD5 a1 OK Capability completed. Doing the same on 2.0.rc3, will return only a limited set of supported capabilities: * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN] Dovecot ready. a1 CAPABILITY * CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN a1 OK Capability completed. However after a user has logged in, Dovecot 2.0.rc3 returns all supported capabilities: * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN] Dovecot ready. a1 login user(a)example.com pass a1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA ACL RIGHTS=texk] Logged in a2 CAPABILITY * CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA ACL RIGHTS=texk a2 OK Capability completed So what's the idea behind the change of this behavior? Is it planned to support different capabilities per user in the future? The reason behind my question is, that the Open-Xchange IMAP client implementation relies on the presence of the ACL capability presented before the actual login took place. Thanks for any clarifications. Regards Christian

6 8

[Dovecot] doveadm director remove error
by Xavier Pons 04 Aug '10

04 Aug '10

Hi, with the version 2.0.rc3, when I try to remove a mail server from director list, get this error: doveadm director remove 10.180.188.21 (null): doesn't exist but the other commands are working without problem ... doveadm director status mail server ip vhosts users 10.180.188.21 100 2 10.180.188.22 100 3 thanks Xavier

2 1

[Dovecot] OT dovecot w/postfix, mysql , postfix does unnecessary lookups
by Noel Butler 04 Aug '10

04 Aug '10

I know this unnecessary lookups question is really a postfix one, but I'm curious if anyone else sees the behaviour of postfix continuing looking up users after it clearly have got its answer that it is "not a local domain" response. (this msg is an extract from what I sent to WV some time ago, with him showing absolutely no interest, I got bored tonight so thought I'd throw it on this list since the question remains valid today) 30 Query SELECT 1 FROM virtual_domains WHERE name='example.net' AND active ='1' 31 Query SELECT destination FROM view_aliases WHERE email='someuser(a)example.net' Should that not have ended its lookups at Q30 and not gone on to ask Q31 which it now knows is not local? Secondly, it seems to do "double lookups" of destination and email before it gets to dovecots deliver, has anyone else ran a log on mysql and seen same? I'm trying to work out why, since it already has its answer by Q54 and Q55, it is doing Q56 and Q57, which seem pointless... 54 Connect 54 Query SELECT destination FROM view_aliases WHERE email='laura(a)example.com' 55 Connect 55 Query SELECT email FROM view_users WHERE email='laura(a)example.com' 56 Connect 56 Query SELECT destination FROM view_aliases WHERE email='laura(a)example.com' 57 Connect 57 Query SELECT email FROM view_users WHERE email='laura(a)example.com' So, it to me appears postifx does more work then it needs too since it already knows the answer, I consider this a flaw in postfix, yet perhaps I am the only one seeing it hence why WV couldnt give a shit. just curious if anyone has noted same or not....

3 4

[Dovecot] Dsync fatal error.
by Henrique Fernandes 04 Aug '10

04 Aug '10

#dsync -D -vv -u stak(a)nti.uff.br mirror maildir:/CX4/vdomains/ nti.uff.br/stak/mail dsync(root): Fatal: Mail locations must use the same virtual mailbox hierarchy separator (specify separator for the default namespace) My mail.conf *mail_location = mbox:/CX4/vdomains/%d/home/%n/mail:INBOX=/CX4/vdomains/%d/var/spool/mail/%n:INDEX=/tmp/imap-index/%d/%n *What that error means ? Before when i used convert before, it worked as expected. I want to convert my mboxs to maildir. Prefered withoud down time. To do without down time i will do like this. First i convert like i am trying it above, and after i do this, i run once again to see if got any new mail after this, i change in my mysql setting of mail location to /CX4/vdomains/%d/%u/mail/ My mysql settins override the conf file. But firts i have to make the first command work, anyone has any ideias ? []'sf.rique

2 11

[Dovecot] AntiSpam Plugin
by Leander S. 04 Aug '10

04 Aug '10

P.S. I just tried it with 1.2.13 as well - still the same issue. Am I doing something wrong, or is this really a bug now!? Best Regards Leander S. Hi, Has anyone got the chance to get this running? I'm permanently getting this Serverbug error ... ;( *"[SERVERBUG] failed to send email"* ... This happens when I try to drag&drop mails from one to the other folder within a IMAP-session. What version of Dovecot must I have to get this plugin working? Or will it generally be broken in upcoming new releases of Dovecot? Best Regards Leander S.

8 16

[Dovecot] problem with mail_full_filesystem_access = yes
by Ladislav Pašek 04 Aug '10

04 Aug '10

Hello, I have configured Dovecot 1.2.12 with Postfix 2.6.5 and everything is working fine. But tomorrow I wanted to run IMAP ALCs and from log I found that this plugin is conflicting with parameter mail_full_filesystem_access = yes in my config. But when I set mail_full_filesystem_access = no it stops authorization for postfix with this message: <pasek(a)valbek.cz>: Command died with signal 11: "/usr/libexec/dovecot/deliver" Does anybody know what could be wrong in my config? I've spend a night with it but without success. You can see my Dovecot here: http://www.volny.cz/vykupitel/Pictures/mail/dovecot.conf http://www.volny.cz/vykupitel/Pictures/mail/dovecot-ldap.conf and Postfix here: http://www.volny.cz/vykupitel/Pictures/mail/main.cf http://www.volny.cz/vykupitel/Pictures/mail/master.cf http://www.volny.cz/vykupitel/Pictures/mail/ldap-users.cf http://www.volny.cz/vykupitel/Pictures/mail/ldap-groups.cf Thanks in Advance Ladislav

4 7

[Dovecot] Convert plugin
by Egbert 03 Aug '10

03 Aug '10

Hi, I'm trying to convert users from a sendmail server to a postfix/dovecot server. All works fine but one of the last things is to rescue the messages in /var/mail/<user> on the old server. This seems very straitforward using the convert plugin but with the settings from the wiki, nothing happens when the user logs in. Do I need a private namespace for this as suggested elsewhere in the wiki? I experimented with mb2md.pl and that seems to do what we need but having the old mail converted upon login is much more attractive. In that way we hope that we can also find some 'dead' users. TIA Egbert Jan

3 12

[Dovecot] Plugin Handle input messages
by Alex Baule 03 Aug '10

03 Aug '10

Hi Timo.... I try to change my plugin to read the input email to increase a header line and one \r\n. But i need help to get this input.... My plugin is based in zlib plugin. In "static int zlib_permail_get_stream" function, have it. if (imail->data.stream != NULL || (_mail->uid == 0 && zuser->save_handler == NULL)) { return zmail->super.get_stream(_mail, hdr_size, body_size, stream_r); } I think this is the line that return the stream that is the stream sent by client. I try to change this line and put inside this IF , a call to my function to handle with the input email from client. But i got some errors about the input part. In other email, Timo said, to get the S and W flags in the email name, i need to intercept the email input from client to dovecot, in this part is done the W and S calculation. Timo, where is the part that i can get the input from client ?

2 4

[Dovecot] quota not updated
by Martin Ott 03 Aug '10

03 Aug '10

Hi, we're using quota with the maildir backend. When new mail arrives, the quota gets updated. But when mail is expunged, quota stays the same (see imap dialog below). We're using the latest version from hg ( 1.2.13 ). Any ideas? ###quota part from dovecot -n plugin: quota: maildir:User quota quota_rule: *:storage=2000M quota_warning: storage=95%% /usr/local/bin/quota-warning.sh 95 quota_warning2: storage=80%% /usr/local/bin/quota-warning.sh 80 quota2: maildir:Shared quota:ns=shared/ quota2_rule: *:storage=10000M ###imap dialog: * PREAUTH [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS ACL RIGHTS=texk QUOTA] Logged in as user a01 select INBOX * FLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk $MDNSent $Forwarded) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk $MDNSent $Forwarded \*)] Flags permitted. * 15 EXISTS * 0 RECENT * OK [UIDVALIDITY 1264203739] UIDs valid * OK [UIDNEXT 1133] Predicted next UID * OK [HIGHESTMODSEQ 3543] Highest a01 OK [READ-WRITE] Select completed. a02 getquotaroot INBOX * QUOTAROOT "INBOX" "User quota" * QUOTA "User quota" (STORAGE 302485 2048000) a02 OK Getquotaroot completed. a03 store 15 +Flags \Deleted * 15 FETCH (FLAGS (\Deleted \Seen NonJunk)) a03 OK Store completed. a04 expunge * 15 EXPUNGE a04 OK Expunge completed. a05 select INBOX * OK [CLOSED] Previous mailbox closed. * FLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk $MDNSent $Forwarded) * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft NonJunk $MDNSent $Forwarded \*)] Flags permitted. * 14 EXISTS * 0 RECENT * OK [UIDVALIDITY 1264203739] UIDs valid * OK [UIDNEXT 1133] Predicted next UID * OK [HIGHESTMODSEQ 3545] Highest a05 OK [READ-WRITE] Select completed. a06 getquotaroot INBOX * QUOTAROOT "INBOX" "User quota" * QUOTA "User quota" (STORAGE 302485 2048000) a06 OK Getquotaroot completed. Regards, Martin

2 7