Re: [Dovecot] Expire plugin with Mysql

2008-08-05 Thread Eric Toczek
Dino Ming wrote: Here is my dict.conf file connect = host=sql dbname=vmail user=xx password=xx table = dict_expire select_field = timestamp where_field = path username_field = username That looks good How can I debug the imap and check why the table didn't got updated when

Re: [Dovecot] Expire plugin with Mysql

2008-08-04 Thread Dino Ming
Dear Timo, I tried to change back to expire: Trash 1 and it seem still not work whenever I delete email within Mail.app Thunderbird. the dict_expire table not being updated. Here is my dict.conf file connect = host=sql dbname=vmail user=xx password=xx table = dict_expire

Re: [Dovecot] Expire plugin with Mysql

2008-07-20 Thread Timo Sirainen
On Tue, 2008-07-08 at 15:07 +0800, Dino Ming wrote: Hi Timo, I had setup the expire plugin using proxy dict method with mysql table. Whenever I run the command : dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool , I saw dovecot query the table : Query SELECT path,

[Dovecot] Expire plugin with Mysql

2008-07-08 Thread Dino Ming
Hi Timo, I had setup the expire plugin using proxy dict method with mysql table. Whenever I run the command : dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool , I saw dovecot query the table : Query SELECT path, timestamp FROM dict_expire ORDER BY timestamp But then,

Re: [Dovecot] Expire plugin with Mysql

2008-07-05 Thread Dino Ming
Hi Timo, I had setup the expire plugin using proxy dict method with mysql table. Whenever I run the command : dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool , I saw dovecot query the table : Query SELECT path, timestamp FROM dict_expire ORDER BY timestamp But then,

Re: [Dovecot] Expire plugin with Mysql

2008-06-02 Thread Timo Sirainen
On Sun, 2008-06-01 at 20:26 -0400, Eric wrote: On Sun, 04 May 2008 17:50:45 +0300 Timo Sirainen [EMAIL PROTECTED] wrote: A bit late reply, but you should be able to use a table exactly like with quota (http://wiki.dovecot.org/Quota/Dict): Just got around to trying this out, and I

Re: [Dovecot] Expire plugin with Mysql

2008-06-02 Thread Eric T
Seems to work in my tests. Could you do a bit more with gdb: #6 0x0812e512 in client_dict_connect (dict=0x819abc8) at /var/tmp/dovecot-1.1.rc6/src/lib-dict/dict-client.c:268 query = 0x8178664 D\206\027\b\003 fr 6 p *dict Program terminated with signal

Re: [Dovecot] Expire plugin with Mysql

2008-06-02 Thread Timo Sirainen
On Mon, 2008-06-02 at 14:50 -0400, Eric T wrote: Seems to work in my tests. Could you do a bit more with gdb: Wonder why it worked :) Fixed: http://hg.dovecot.org/dovecot-1.1/rev/d73cc550b389 signature.asc Description: This is a digitally signed message part

Re: [Dovecot] Expire plugin with Mysql

2008-06-01 Thread Eric
On Sun, 04 May 2008 17:50:45 +0300 Timo Sirainen [EMAIL PROTECTED] wrote: A bit late reply, but you should be able to use a table exactly like with quota (http://wiki.dovecot.org/Quota/Dict): Just got around to trying this out, and I get a segfault when attempting to move a message into the

Re: [Dovecot] Expire plugin with Mysql

2008-05-04 Thread Timo Sirainen
On Sat, 2008-03-29 at 15:57 -0400, Eric wrote: Hey guys, got a question about the expire plugin. According to the wiki, the expire plugin keeps an internal database (Berkeley DB or SQL). I was wondering what fields in the mysql table are needed for expire to work. I assume it is setup is