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 }