[Dovecot] Expire plugin does not work

[Timo Sirainen]

On Thu, 2010-12-16 at 20:55 +0100, Christoph Pleger wrote:

> dovecot: dict: Error: sqlite: exec(INSERT INTO expires 
> (expire_stamp,username,mailbox) VALUES ('1292525469','christoph','Trash')) 
> failed: unable to open database file (14)

So SQLite can't open its database. I don't know what "14" error would
mean, maybe SQLite docs can tell you.

> connect = /etc/dovecot/dovecot-dict.sqlite

Databases shouldn't really be put under /etc.. Rather
maybe /var/lib/dovecot/

> I have attached a "dovecot -n"-generated dovecot.conf, the configuration file 
> for the expire dict service, and my sqlite3 database file. In my filesystem, 
> dovecot-dict.sqlite currently has permissions 666.

But if it's 0666, I'm not really sure what the problem could be. You
could try if dict can access it as root:

service dict {
  user = root
}