dovecot - Sep 2010 - expire_tool trouble + howto part sasl from 1.1.7 -> 2.0.1?

Hello!

Let me smuggle 2 questions in 1 email:

1) I upgraded from 1.1.7 to 2.0.1, but couldn't get it to work, because the
'dovecot + postfix sasl howto' doesn't seem to be updated and the
old sasl settings are incompatible with new version. How do I set up sasl with
dovecot2 ? Is there any updated howto available?
2) In dovecot 1.1.7: my expire_plugin seems to work fine,
 new entries are correctly added to the dictionary, but the messages don't
actually get expunged. expire_tool says:
dovecot --exec-mail ext /usr/lib/dovecot/expire-tool --test
Info: maildir: data=~/Maildir
Info: maildir++: root=/home/virtual/<domain>/<user>/Maildir, index=,
control=, inbox=/home/virtual/<domain>/<user>/Maildir
Info: <user>@<domain>/Trash: timestamp 1285005106 (Mon Sep 20
18:51:46 2010
) -> 1290102903 (Mon Sep 20 18:51:46 2010
)
Info: <user2>@<domain>/Trash: stop, expire time in future: Sat Nov?
6 18:33:12 2010

Messages are only updated in the dictionary, but nothing is ever expunged. Any
idea why?

Output of dovecot -n:

# 1.1.7:
 /etc/dovecot/dovecot.conf
# OS: Linux 2.6.27.7-9-pae i686 openSUSE 11.1 (i586) 
protocols: imap imaps pop3 pop3s
listen(default): *:143
listen(imap): *:143
listen(pop3): *:110
ssl_listen(default): *:993
ssl_listen(imap): *:993
ssl_listen(pop3): *:995
ssl_cert_file: /etc/ssl/certs/startssl.pem
ssl_key_file: /etc/ssl/private/startssl.pem
verbose_ssl: yes
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
mail_location: maildir:~/Maildir
mail_debug: yes
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugins(default): quota imap_quota expire autocreate
mail_plugins(imap): quota imap_quota expire autocreate
mail_plugins(pop3): quota
 expire
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
auth default:
? mechanisms: plain login
? debug_passwords: yes
? passdb:
??? driver: pam
??? args: dovecot2
? passdb:
??? driver: sql
??? args: /etc/dovecot/dovecot-sql.conf
? userdb:
??? driver: passwd
? 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
? quota_warning: storage=95%% /usr/local/bin/quota-warning.sh 95
? quota_warning: storage=80%% /usr/local/bin/quota-warning.sh 80
? expire: Trash 60 Trash.* 60 Spam 365
? expire_dict: proxy::expire
? autocreate: Trash
? autocreate2: Spam
? autosubscribe: Trash
? autosubscribe2: Spam
dict:
? expire: mysql:/etc/dovecot/dovecot-dict-expire.conf

Create dict. table query:

?CREATE TABLE `expires` (
? `mailbox` varchar(255) NOT NULL,
? `expire_stamp` int(11) NOT NULL,
? PRIMARY KEY? (`mailbox`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 

expire
 dict. conf:

table = expires
select_field = expire_stamp
where_field = mailbox
username_field = not_used

And is there a point in using expire plugin without autocreate plugin? Because
trash can be called wastebasket for example, and then it doesn't work. Spam
can be called Junk, and again, it doesn't work.

Any response to these queries would be greatly appreciated.

Tadeusz Stelmach

On Tue, 2010-09-21 at 11:26 -0700, Igor Kowalski wrote:
> Hello!
> 
> Let me smuggle 2 questions in 1 email:
> 
> 1) I upgraded from 1.1.7 to 2.0.1, but couldn't get it to work, because
the 'dovecot + postfix sasl howto' doesn't seem to be updated and
the old sasl settings are incompatible with new version. How do I set up sasl
with dovecot2 ? Is there any updated howto available?
What settings exactly are incompatible? v2.0 should have been able to
convert your v1.1 configuration, including the auth socket.
> 2) In dovecot 1.1.7: my expire_plugin seems to work fine,
>  new entries are correctly added to the dictionary, but the messages
don't actually get expunged.
There were tons of fixes to expire-tool and expire plugin since v1.1.7.
It probably was just broken at that time.
> And is there a point in using expire plugin without autocreate plugin?
> Because trash can be called wastebasket for example, and then it
> doesn't work. Spam can be called Junk, and again, it doesn't work.
Yeah, that's something that can't really be helped. Usually those are
created by the email client automatically, so even if you autocreated
some mailboxes yourself it doesn't guarantee that users would actually
use those.

Also if you don't have all that many users, you don't even need to
enable expire plugin anymore with v2.0.
http://wiki2.dovecot.org/Plugins/Expire