[Dovecot] expire_tool trouble + howto part sasl from 1.1.7 -> 2.0.1?

[Igor Kowalski]

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