[Dovecot] Vpopmail + Expire Plugin

[Oliver Lehmann]

Hi,

I've changed my running qmail/vpopmail/procmail/courier-imap/sqwebmail
installation to qmail/vpopmail/siege/dovecot/horde imp.

So far, I've got everything running. Authentification with vpopmail as
passdb is working, Mail delivery with siege into different Mail folders
is working as well.

One of the reasons why I switched to dovecot was the expire plugin and
right now I'm trying to set it up but I don't get it to run.

- I created a MySQL User as advised
- I created a database and a table and granted SELECT, INSERT, DELETE,
   UPDATE privileges for that table to user dovecot

   # mysql -udovecot -p dovecot
   Enter password:
   mysql> desc 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)

   mysql> select * from expires;
   Empty set (0.00 sec)

- I added the following lines to my dovecot.conf:

   dict {
     expire = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
   }

    plugin {
     expire = Test
     expire_dict = proxy::expire
   }

- I created the dovecot-dict-sql.conf.ext

   # cat /usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
   connect = host=localhost dbname=dovecot user=dovecot password=XXXX
   map {
     pattern = shared/expire/$user/$mailbox
     table = expires
     value_field = expire_stamp

     fields {
       username = $user
       mailbox = $mailbox
     }
   }
   #

- When restarting dovecot I had a dict error because the socket
   was owned by root. I changed that so the socket is owned by the
   user vpopmail.
- Then I created a folder "Test" via IMAP for one of my accounts
- Then I copied via Horde IMP (so via IMAP) a message to that new
   folder
- I requeried dovecot.expires in my database and it is still empty
- I enabled logging for my MySQL DB and with that I found out, that
   no connect with the "dovecot" user is made at all so of course
   the table is empty.
- I created a siege rule to move a mail directly to that Test folder
   when a specific Subject is used. lda moves the mail on arrival but
   still no MySQL connection is made.



I've read that doveadm -A must work to get the expire plugin workinj,
but it does not:

   # doveadm search -A mailbox INBOX subject test
   doveadm(olivleh1): Error: User listing returned failure
   doveadm: Error: Failed to iterate through some users
   #

The expire plugin is loaded on startup:

   Jan 04 11:35:50 imap: Debug: Loading modules from directory:
                         /usr/local/lib/dovecot
   Jan 04 11:35:50 imap: Debug: Module loaded:
                         /usr/local/lib/dovecot/lib20_expire_plugin.so

When using doveadm I'm getting a strange error:
   # doveadm -v expire -A mailbox INBOX subject test
   doveadm(olivleh1): Fatal: Unknown command 'expire', but plugin expire
     exists. Try to set mail_plugins=expire
   Exit 89
   #

I've no idea how to get it to work. I guess I need your help guys to
get it working ;)

   # dovecot -n
   # 2.0.7: /usr/local/etc/dovecot/dovecot.conf
   # OS: FreeBSD 7.3-STABLE i386
   auth_debug = yes
   auth_verbose = yes
   debug_log_path = /var/log/dovecot/dovecot-debug.log
   dict {
     expire = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
   }
   disable_plaintext_auth = no
   first_valid_uid = 89
   info_log_path = /var/log/dovecot/dovecot-info.log
   last_valid_uid = 89
   listen = 127.0.0.1
   log_path = /var/log/dovecot/dovecot.log
   mail_debug = yes
   mail_plugins = " expire"
   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
   passdb {
     driver = vpopmail
   }
   plugin {
     expire = Test 1
     expire_dict = proxy::expire
     sieve = ~/.dovecot.sieve
     sieve_dir = ~/sieve
   }
   protocols = imap sieve
   service auth {
     unix_listener auth-userdb {
       group = vchkpw
       mode = 0600
       user = vpopmail
     }
   }
   service dict {
     unix_listener dict {
       group = vchkpw
       mode = 0600
       user = vpopmail
     }
   }
   ssl_cert = </usr/local/etc/dovecot/ssl/certs/dovecot.pem
   ssl_key = </usr/local/etc/dovecot/ssl/private/dovecot.pem
   userdb {
     args = quota_template=quota_rule=*:backend=%q
     driver = vpopmail
   }
   protocol lda {
     debug_log_path = syslog
     info_log_path = syslog
     log_path = syslog
     mail_plugins = " sieve"
   }


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.