May 2012 - dovecot - dovecot.org

[Dovecot] Time stamp or expire_stamp not updating to DATABASE table expires in mysql
by Steve Wells 29 May '12

29 May '12

Debian OS Dovecot upgraded from 1.2 to 2.0.18 RoundCubeMail Web Client which uses imap to make connection mysql-server-5.1 version = 5.1.61-0+squeeze1 RoundCubeMail = 0.7.2 As users delete mail in Roundcubemail the database timestamp not entered. The database is blank /var/log/dovecot.log shows no error Do you know where I can look to resolve this problem? If you need any further information/test feel free to ask. Below is dovecot -n, dovecot-dict-expire.conf, and mysql describe of table expire Thanks in advance? Steven Wells Advanced Business Networks wells(a)netabn.com nm2:/var/lib/dovecot# dovecot -n # 2.0.18: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-5-686 i686 Debian 6.0.3 auth_mechanisms = PLAIN LOGIN dict { acl = mysql:/etc/dovecot/dovecot-share-folder.conf expire = mysql:/etc/dovecot/dovecot-dict-expire.conf quotadict = mysql:/etc/dovecot/dovecot-used-quota.conf } disable_plaintext_auth = no first_valid_uid = 1001 last_valid_uid = 1001 listen = * log_path = /var/log/dovecot.log mail_gid = 1001 mail_location = maildir:/%Lh/Maildir/:INDEX=/%Lh/Maildir/ mail_plugins = " expire" mail_uid = 1001 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 namespace { inbox = yes location = prefix = separator = / type = private } namespace { list = children location = maildir:/%%Lh/Maildir/:INDEX=/%%Lh/Maildir/Shared/%%u prefix = Shared/%%u/ separator = / subscriptions = yes type = shared } passdb { args = /etc/dovecot/dovecot-mysql.conf driver = sql } plugin { acl = vfile acl_shared_dict = proxy::acl auth_socket_path = /var/run/dovecot/auth-master autocreate = INBOX autocreate2 = Sent autocreate3 = Trash autocreate4 = Drafts autocreate5 = Junk autosubscribe = INBOX autosubscribe2 = Sent autosubscribe3 = Trash autosubscribe4 = Drafts autosubscribe5 = Junk expire = Trash 7 Trash/* 7 Junk 30 Sent 30 expire_dict = proxy::expire quota = dict:user::proxy::quotadict quota_rule = *:storage=1G quota_warning = storage=85%% quota-warning 85 %u quota_warning2 = storage=90%% quota-warning 90 %u quota_warning3 = storage=95%% quota-warning 95 %u sieve = /%Lh/sieve/dovecot.sieve sieve_dir = /%Lh/sieve sieve_global_dir = /var/vmail/sieve sieve_global_path = /var/vmail/sieve/dovecot.sieve } protocols = pop3 imap sieve service auth { unix_listener /var/spool/postfix/dovecot-auth { group = postfix mode = 0666 user = postfix } unix_listener auth-master { group = vmail mode = 0666 user = vmail } } service dict { unix_listener dict { group = vmail mode = 0660 user = vmail } } service quota-warning { executable = script /usr/local/bin/dovecot-quota-warning.sh unix_listener quota-warning { group = vmail mode = 0660 user = vmail } } ssl_ca = </etc/ssl/certs/gd_bundle.pem ssl_cert = </etc/ssl/certs/nm2.abgnetwork.net.pem ssl_key = </etc/ssl/private/nm2.key userdb { args = /etc/dovecot/dovecot-mysql.conf driver = sql } protocol lda { auth_socket_path = /var/run/dovecot/auth-master lda_mailbox_autocreate = yes log_path = /var/log/sieve.log mail_plugins = quota sieve autocreate expire postmaster_address = root } protocol imap { imap_client_workarounds = tb-extra-mailbox-sep mail_plugins = quota imap_quota autocreate expire } protocol pop3 { mail_plugins = quota expire pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %08Xu%08Xv } cat dovecot-dict-expire.conf connect = host=127.0.0.1 dbname=vmail user=vmail password=********************* map { pattern = shared/expire/$user/$mailbox table = expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } mysql> describe expires; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | username | varchar(75) | NO | PRI | NULL | | | mailbox | varchar(255) | NO | PRI | NULL | | | expire_stamp | int(11) | NO | | NULL | | +--------------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)

2 1

[Dovecot] Active Directory : searches in root tree
by nicolasfo 29 May '12

29 May '12

Hello everyone ! I'm trying to make a mail server with dovecot and postfix. Users will authenticate with Active Directory server. I've got an problem with Dovecot. To make the mail server, I'm using IredMail, and I used this tutorial : http://www.iredmail.org/wiki/index.php?title=Integration/Active.Directory.i… here Here's my dovecot-ldap.conf : hosts = dc.domain.lan:389 ldap_version = 3 auth_bind = yes dn = vmail(a)domain.lan dnpass = vmail_passwd base = ou=some_ou,dc=domain,dc=lan scope = subtree deref = never user_filter = (&(userPrincipalName=%u)(objectClass=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2))) pass_filter = (&(userPrincipalName=%u)(objectClass=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2))) user_attrs = =home=/home/mail/%Ld/%Ln/Maildir/,=mail=maildir:/home/mail/%Ld/%Ln/Maildir/ pass_attrs = userPassword=password default_pass_scheme = CRYPT With this configuration file, it works. BUT : To allow Dovecot to find users in my AD database, I must specify an OU in "base". If I only set "dc=domain,dc=lan" the research doesn't work. It seems that Dovecot is not capable to make a research without an OU specified in base. Am I wrong ? The root research works fine with postfix, samba+winbind, and I've an enterprise sized hardware firewall, and it works fine too. I'll be surprised if you tell me that Dovecot can't make a research without OU... That's why I'm posting here.. I've already post about this problem on the Iredmail forum, http://www.iredmail.org/forum/post15184.html#p15184 here , but no solution were found. You're my last hope :) Thanks a lot for replies Nicolas -- View this message in context: http://old.nabble.com/Active-Directory-%3A-searches-in-root-tree-tp33881379… Sent from the Dovecot mailing list archive at Nabble.com.

2 1

[Dovecot] GETQUOTAROOT under roundcube
by Adam Szpakowski 29 May '12

29 May '12

Hi, I'm struggling with the proper quota displaying under roundcube webmail. I've tracked the problem to the different responses on GETQUOTAROOT command. Roundcube aquire quota usage using IMAP command: GETQUOTAROOT INBOX Example dump of the roundcube <-> dovecot communication: > GETQUOTAROOT inbox < QUOTAROOT "inbox" "User quota" < QUOTA "User quota" (STORAGE 1198415 10485760) < OK Getquotaroot completed. The same communication using python imaplib: > GETQUOTAROOT inbox < QUOTAROOT "inbox" "User quota" < QUOTA "User quota" (STORAGE 1431260 10485760) < OK Getquotaroot completed. Quota reported to python client is the same as the one reported to Thunderbird and seems to be the proper one. Python test was performed from the webmail same server, the same user. Can someone point me in the right direction? If there is no explanation on IMAP level i'll move the question to roundcube list. software used: - dovecot: 2.0.15, quota limit set in LDAP, usage tracked in SQL - roundcube: 0.7 - python: 2.6.7 Relevant parts of the dovecot config (taken selectively from different files): quota = dict:User quota::proxy::quota quota_rule2 = Trash:storage=+10%% quota_rule3 = spam:storage=+10%% user_attrs = mailQuota=quota_rule=*:bytes=%$ mail_plugins = quota imap_quota dict { quota = mysql:/etc/dovecot/dovecot-dict-used-quota.conf.ext } #dovecot-dict-used-quota.conf.ext map { pattern = priv/quota/storage table = used_quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = used_quota username_field = username value_field = messages } -- Adam Szpakowski

2 1

[Dovecot] per-mailbox message limits
by Alan Brown 29 May '12

29 May '12

This is something Timo hacked up for me a few years ago and I realised should be on the list in case anyone else wants them. The following patches will limit maildir folders to 4000 messages on Dovecot 2.0.* and 2.1.* The Specfile patch is against the Cityfan Redhat EL5 SRPM but is likely to work on most build platforms Changing the message limit requires a recompile. It's brutal and ugly but it prevents users overloading FSes that can't cope with huge numbers of files (EG: GFS2)

3 3

[Dovecot] (no subject)
by Phil Petree 29 May '12

29 May '12

Hey All, I'm developing a site on a VPS that comes stock with dovecot 1.2.17 and I'm trying to setup some functionality that is very specific to our business model. My question is this: How do I create (programatically) aliases for a forwarder? I have an address, email(a)domain.com that gets sent to a php script and I want users to be able to send to that script via any number of different names (could ultimately be 1000's). I'm thinking that I append/delete from the etc/aliases file and then run #newaliases So that email(a)domain.com will answer on dummy(a)domain.com or dothis(a)domain.com, once the email comes in, I can check the header, get who it was really sent to, do all my checks, perform the necessary action blah blah blah... and be able to do it all on one piece of code (my fantasy LOL). Am I on the right track here or is this simply not going to work? Thanks, Pete

2 1

[Dovecot] AUTH PLAIN fails while AUTH LOGIN succeeds with Exim -> Dovecot SASL auth
by Sandro Tosi 29 May '12

29 May '12

Hello, we're trying to setup a platform with authenticated SMTP with exim and relying on dovecot as auth agent. We've read http://wiki2.dovecot.org/HowTo/EximAndDovecotSASL and so made the changes mentioned there, also setting auth_mechanisms = plain login in conf.d/10-auth.conf . With this setup, we're able to use AUTH LOGIN method on an SMTP session, but using AUTH PLAIN fails. What we receive in the SMTP session is: auth plain `echo -e -n `\0user\0password' | mimencode` 535 Incorrect authentication data (it's actually the output of that command that we put there), and in the dovecot log we see: 2012-05-24 15:04:20 auth: Debug: client in: AUTH 1 PLAIN service=smtp secured rip=127.0.0.1 lip=127.0.0.1 nologin resp=<hidden> 2012-05-24 15:04:20 auth: Info: plain(?,127.0.0.1): invalid input Do you know where we can look to resolve this problem? If you need any further information/test feel free to ask. Thanks in advance? -- Sandro Tosi Product Engineer Shared Hosting Products R&D | Dada.pro eml sandro.tosi(a)register.it

1 1

[Dovecot] Released Pigeonhole v0.3.1 for Dovecot v2.1.6
by Stephan Bosch 27 May '12

27 May '12

Hello Dovecot users, It's been a few months since the last Pigeonhole release. The main reason is that I've introduced a few big new features. Although the new features themselves probably haven't seen much testing so far, I'm now pretty confident that existing configurations are not broken by these changes. The biggest change is the addition of dict support for Sieve script retrieval. It now possible to fetch Sieve scripts from an SQL database using the Dovecot dict facility. Read the INSTALL file and the referenced additional documentation for more information. Note that this feature currently is not usable with sieve_before/sieve_after and ManageSieve. Additionally, it is now possible to specify multiple sieve_before and sieve_after scripts. This for instance enables administrators to specify both global and user-specific scripts that are to be executed before and after the user's personal script. User-specific scripts configured in sieve_before and sieve_after can not be seen or changed through the ManageSieve protocol. Finally, as promised a while back, I've incorporated the vnd.dovecot.duplicate extension into the main Pigeonhole package. Using this Dovecot-specific extension it is possible to detect duplicate deliveries (such as for example caused by mailing list subscriptions). The detection is based on the message ID and uses the same database file (~/.dovecot.lda-dupes) as the vacation extension. Since the changes introduced in the release are rather large, I strongly advise you to experiment with it a bit before deployment. Changelog v0.3.1: * Added support for retrieving Sieve scripts from dict lookup. This means that Sieve scripts can now be downloaded from a database. Compiled script binaries are still put on disk somewhere if used. The INSTALL documentation is updated with information on this new feature and the (backwards-compatible) changes to the configuration. Note that his feature is currently not supported for sieve_before/sieve_after or script management through ManageSieve. + Incorporated the sieve_duplicate plugin into main Pigeonhole tree as a normal extension (vnd.dovecot.duplicate). This Dovecot-specific extension adds the ability to check for duplicate deliveries based on message ID. Specification can be found in: doc/rfc/spec-bosch-sieve-duplicate.txt + Added support for specifying multiple sieve_before and sieve_after paths. This adds much more flexibility to the multiscript configuration. One application is to have user-specific Sieve scripts outside the user's normal control through ManageSieve. + Added a "session ID" string for managesieve connections, available in %{session} variable (analogous to Dovecot change). - Fixed several small issues, including a few potential segfault bugs, based on static source code analysis. - ManageSieve: changed use of EPROTO error to EIO in ManageSieve string stream implementation because it is apparently not known in BSD. - Gave stamp.h.in (needed for autotools) some content to prevent it from disappearing in patch files. - Fixed bug that caused a SunStudio CC compile failure (reported by Piotr Tarnowski). The release is available as follows: http://www.rename-it.nl/dovecot/2.1/dovecot-2.1-pigeonhole-0.3.1.tar.gz http://www.rename-it.nl/dovecot/2.1/dovecot-2.1-pigeonhole-0.3.1.tar.gz.sig Refer to http://pigeonhole.dovecot.org and the Dovecot v2.x wiki for more information. Have fun testing this new release and don't hesitate to notify me when there are any problems. Regards, -- Stephan Bosch stephan(a)rename-it.nl

3 5

[Dovecot] Checkpassword Perl LDAP Implementation
by Jeff Hardy 27 May '12

27 May '12

A few years back I hacked up a perl chkpassldap.pl script to authenticate against ldap, and optionally authorize against groups and/or ldap attributes. This works with both qmail and Dovecot, and it also supports a somewhat generic method to alter the environment suitable to use for Dovecot as a prefetch userdb. Anyway, I have been running the script on a qmail-ldap and Dovecot 1.2 proxying cluster using the stock qmail-ldap attributes without any troubles, and figured I would finally release it in the thought someone might find it useful. http://fritz.potsdam.edu/projects/chkpassldap I tried to document the ins and outs of userdb configuration. If anyone finds anything that could use correction or clarification, please let me know. It has been awhile since I was in the middle of it all. Cheers, -Jeff -- Jeffrey Hardy Network / Systems Administrator hardyjm(a)potsdam.edu

1 0

[Dovecot] Dovecot usage values differ from actual disk usage
by Daniel Parthey 26 May '12

26 May '12

Hi, in my dovecot setup the accounting database table shows wrong values which do not correspond with the actual disk space used. The disk usage says 2.6 Gigabytes: mail01:~# du -sh /mail/dovecot/example.org/username 2.6G /mail/dovecot/example.org/username While the doveadm quota get says 7 Gigabytes for the same user: mail01:~# doveadm -f tab quota get -u username(a)example.org Quota name Type Value Limit % User quota STORAGE 7065208 - 0 User quota MESSAGE 282024 - 0 mysql> select * from dovecot.dovecot_usage where username="username(a)example.org"; +----------------------+------------+----------+ | username | storage | messages | +----------------------+------------+----------+ | username(a)example.org | 7234773131 | 282024 | +----------------------+------------+----------+ 1 row in set (0.00 sec) What might be the reason for such huge differences (several gigabytes) between storage value in dovecot_usage table and disk usage value? After a quota recalc everything is correct: mail01:~# doveadm quota recalc -u username(a)example.org mail01:~# doveadm -f tab quota get -u username(a)example.org Quota name Type Value Limit % User quota STORAGE 2630434 - 0 User quota MESSAGE 100714 - 0 mysql> select * from dovecot.dovecot_usage where username="username(a)example.org"; +----------------------+------------+----------+ | username | storage | messages | +----------------------+------------+----------+ | username(a)example.org | 2693565239 | 100714 | +----------------------+------------+----------+ 1 row in set (0.00 sec) How can I keep the accounting data consistent with actual disk usage, without running a recalc cronjob every few hours? There's running a dovecot director and mailbox instance on each of our servers with the mails being stored on NFS and received from postfix via LMTP through the director lmtp port 20024. Configuration of director (dovecot-director.conf) and mailbox (dovecot.conf) is attached. Kind regards Daniel

2 5

[Dovecot] Valid config for lda_mailbox_autosubscribe with dovecot 1.2?
by Joan 25 May '12

25 May '12

Hi, Due to some reasons I've to support both dovecot 1.2 and dovecot 2.x, and I just found that the -s parameter I used to autosubscribe to sieve folders doesn't exist anymore in dovecot 2.x The problem arises because (AFAIK) in postfix's master.cf you can only specify one configuration, and I used to have this: dovecot unix - n n - - pipe flags=DRhu user=vmail argv=/usr/lib/dovecot/deliver -f ${sender} -d ${recipient} -s Is there any way to make the config compatible for both versions, achieving the autosubscribe and not crashing dovecot?

2 2