[Dovecot] Expire plugin does not work
Hello,
I followed the instructions on http://wiki2.dovecot.org/Plugins/Expire to configure the expire plugin, but when I move a message to the Trash folder, I get the following error messages in my logfile:
dovecot: dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES ('1292525469','christoph','Trash')) failed: unable to open database file (14)
dovecot: dict: Error: sql dict: commit failed:
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.
Regards Christoph
Hello,
I forgot to mention the dovecot version number. It is version 2.0.7.
Regards Christoph
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 }
participants (2)
-
Christoph Pleger
-
Timo Sirainen