Hi Jens,
Ive got the same problem with you. The expire plugin not work. Nothing
happened even I delete email from a mail client.
And the expire table on mysql never updated.
Thanks,
Dino
Jens Meyer wrote:
Hello Eric,
thank you very much for your prompt and helpful reply!
The connect seem to work fine now.
Please allow me two additional questions:
Is it correct that this database-table is only a "caching-table" which
is empty at first and will be filled later? It is not necessary to
adapt the SQL-statement to my user-configuration, is it?!
Is it necessary to reference the foldernames with "INBOX.Trash" or
only "Trash"? For Sieve I have to use "INBOX.Trash".
Actually nothing happens when trying the plugin with "dovecot
--exec-mail ext /usr/libexec/dovecot/expire-tool --test".
Thank you again,
kind regards!
Jens
Eric Toczek schrieb:
Jens Meyer wrote:
Unfortunately I have problems with the dictionary:
-->
dovecot: Aug 05 13:30:25 Error: dict: Unknown dict module: db
dovecot: Aug 05 13:30:25 Error: dict: Failed to initialize dictionary
'expire'
Looking at the rpm it doesn't look like it has bdb support built in. But
it sounds like you want to use Mysql so that's alright.
Are there any further tipps how to use the expire-plugin with
mysql-connection (i.e. database-scheme, SQL-Select)?
You will need to setup your configuration like this:
dovecot.conf:
dict {
...
expiredict = mysql:/opt/dovecot/etc/dovecot-dict-expire.conf
...
}
plugin {
...
expire = Trash 7 Trash/* 7 Spam 3 Junk 3
expire_dict = proxy::expiredict
...
}
dovecot-dict-expire.conf:
connect = host=<host> dbname=<db> user=<username> password=<password>
table = expire
select_field = timestamp
where_field = path
username_field = username
Then you'll want to create the table like so:
create table expire( username varchar(255) not null, path varchar(100)
not null, timestamp integer, primary key (username, path))engine=innodb;
That should work for you. Of course enter in your correct config
location and your specific expire settings.
-Eric
