Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Axel Luttgens 
Le 5 août 2013 à 15:10, Felix Rubio Dalmau a écrit :

> [...] Now the question is: How should I configure the expires to be different 
> for different boxes? I see that the expires plugin keeps the track of the 
> oldest message on the boxes tracked, only. Should I configure cronjobs like 
> this, for each mailbox to be expunged?
> 
>   doveadm expunge -A mailbox Trash savedbefore d

Hello Felix,

This might be worth a new thread...

Anyway, I think you are right about the need of having jobs run periodically.

Perhaps could you devise a single job, by ORing your queries as described in 
the man page for doveadm-search-query(7); you may find an example at 
http://www.dovecot.org/list/dovecot/2012-August/067983.html.

But I don't know which approach (multiple jobs vs single job) would be the most 
efficient.

HTH,
Axel

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Felix Rubio Dalmau 
AWESOME!!!

I'm sorry I missed it! Now the table gets correctly updated. Now the question 
is: How should I configure the expires to be different for different boxes? I 
see that the expires plugin keeps the track of the oldest message on the boxes 
tracked, only. Should I configure cronjobs like this, for each mailbox to be 
expunged?

doveadm expunge -A mailbox Trash savedbefore d

Thank you very much to you all!! :-)

Felix

On Monday 05 August 2013 13:45:18 Axel Luttgens wrote:
> Le 5 août 2013 à 13:28, Axel Luttgens a écrit :
> 
> > [...]
> > 
> > The first thing I would try is this one:
> > 
> > mail_plugins = quota zlib expire
> > 
> 
> Moreover, I guess you should also update your lmtp/lda sections:
> 
>   protocol lmtp {
>mail_plugins = quota zlib sieve expire
>   }
>   protocol lda {
>mail_plugins = quota zlib sieve expire
>   }
> 
> Axel
>

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Axel Luttgens 
Le 5 août 2013 à 13:28, Axel Luttgens a écrit :

> [...]
> 
> The first thing I would try is this one:
> 
>   mail_plugins = quota zlib expire
> 

Moreover, I guess you should also update your lmtp/lda sections:

protocol lmtp {
 mail_plugins = quota zlib sieve expire
}
protocol lda {
 mail_plugins = quota zlib sieve expire
}

Axel

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Axel Luttgens 
Le 5 août 2013 à 13:15, Felix Rubio Dalmau a écrit :

> Ooook! Here it goes! :-)
> 
> Thank you!
> 
> Felix
> 
> # 2.1.7: /etc/dovecot/dovecot.conf
> # OS: Linux 3.9.4-15 x86_64 Debian jessie/sid ext4
> [...]
> mail_plugins = quota zlib
> [...]

Thanks too. :-)

The first thing I would try is this one:

mail_plugins = quota zlib expire

Axel

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Felix Rubio Dalmau 
Ooook! Here it goes! :-)

Thank you!

Felix

# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.9.4-15 x86_64 Debian jessie/sid ext4
auth_cache_size = 1 M
auth_failure_delay = 10 secs
auth_mechanisms = plain login
auth_verbose = yes
auth_verbose_passwords = sha1
auth_worker_max_count = 2
base_dir = /var/run/dovecot/
dict {
  expire = mysql:/etc/dovecot/dovecot-dict-expire.conf.ext
}
listen = *
log_timestamp = "%Y-%m-%d %H:%M:%S "
login_greeting = Imap Server ready.
mail_access_groups = vmail
mail_gid = vmail
mail_home = /home/vmail/%d/%n/home
mail_location = maildir:/home/vmail/%d/%n
mail_plugins = quota zlib
mail_privileged_group = vmail
mail_uid = vmail
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character 
vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy 
include variables body enotify environment mailbox date ihave
namespace inbox {
  inbox = yes
  location = 
  mailbox Drafts {
auto = subscribe
special_use = \Drafts
  }
  mailbox Junk {
auto = subscribe
special_use = \Junk
  }
  mailbox Sent {


auto = subscribe
special_use = \Sent
  }
  mailbox "Sent Messages" {
special_use = \Sent
  }
  mailbox Trash {
auto = subscribe
special_use = \Trash
  }
  prefix = 
  type = private
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
plugin {
  expire = Trash
  expire2 = Trash/*
  expire3 = Junk
  expire4 = Junk/*
  expire_dict = proxy::expire
  quota = maildir:User quota
  quota_rule = *:storage=200M
  quota_rule2 = Trash:storage=+10%%
  quota_rule3 = Junk:ignore
  quota_warning = storage=95%% quota-warning 95 %u
  quota_warning2 = storage=80%% quota-warning 80 %u
  sieve = /home/vmail/%d/%n/dovecot.sieve
  sieve_default = /home/vmail/sieve/default.sieve
  sieve_dir = /home/vmail/%d/%n/sieve
  sieve_global_dir = /home/vmail/sieve/global/
  zlib_save = gz
  zlib_save_level = 6
}
postmaster_address = s...@mail.org
protocols = imap sieve lmtp
service auth {
  unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
  }
  unix_listener auth-userdb {
group = vmail
mode = 0660
  }
}
service dict {
  unix_listener dict {
group = vmail
mode = 0660
  }
}
service imap-login {
  inet_listener imaps {
port = 0
  }
  process_min_avail = 3
  service_count = 1
}
service imap {
  process_limit = 30
}
service lmtp {
  unix_listener /var/spool/postfix/private/dovecot-lmtp {
group = postfix
mode = 0600
user = postfix
  }
}
service managesieve-login {
  inet_listener sieve {
port = 4190
  }
  process_min_avail = 0
  service_count = 1
  vsz_limit = 64 M
}
service pop3-login {
  inet_listener pop3 {
port = 0
  }
  inet_listener pop3s {
port = 0
  }
}
ssl_cert =

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Axel Luttgens 
Le 5 août 2013 à 10:34, Felix Rubio Dalmau a écrit :

> Sorry, Steffen. My version of dovecot is 
> 
> # 2.1.7: /etc/dovecot/dovecot.conf
> # OS: Linux 3.9.4-15 x86_64 Debian jessie/sid ext4
> 
> Additionally, I have corrected the plugin parameters as you suggested. Now 
> looks like:
> 
> plugin {
>  expire = Trash
>  expire2 = Trash/*
>  expire3 = Junk
>  expire4 = Junk/*
>  expire_dict = proxy::expire
> }
> 
> However, the table is not updated anyway :S

Hello Felix,

Have you enabled the plugin globally (i.e. mail_plugins = expire ...)?

Otherwise, please help us with the output of doveconf -n. ;-)

Axel

Re: [Dovecot] problems with expire plugin

2013-08-05 Thread Felix Rubio Dalmau 
Sorry, Steffen. My version of dovecot is 

# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.9.4-15 x86_64 Debian jessie/sid ext4

Additionally, I have corrected the plugin parameters as you suggested. Now 
looks like:

plugin {
  expire = Trash
  expire2 = Trash/*
  expire3 = Junk
  expire4 = Junk/*
  expire_dict = proxy::expire
}

However, the table is not updated anyway :S

Sorry for the mistake.

Regards,

Felix


On Monday 05 August 2013 08:20:38 Steffen Kaiser wrote:
> On Sat, 3 Aug 2013, Felix Rubio Dalmau wrote:
> 
> > I'm experiencing problems to set-up the expire plugin in dovecot. This 
> > is the relevant part of my dovecot configuration
> 
> Well, one "relevant" part is missing: your Dovecot version.
> Therefore you should always post the dovecot -n output.
> 
> > plugin {
> >   expire = Trash 15 Junk 15
> 
> This is a setting for Dovecot v1. Are you using Dovecot v2? Then see
> http://wiki2.dovecot.org/Plugins/Expire.
> 
> Regards,
> 
> --
> Steffen Kaiser
>

Re: [Dovecot] problems with expire plugin

2013-08-04 Thread Felix Rubio Dalmau 
Sorry, Steffen. My version of dovecot is 

# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.9.4-15 x86_64 Debian jessie/sid ext4

Sorry for the mistake.

Regards,

Felix


On Monday 05 August 2013 08:20:38 Steffen Kaiser wrote:
> On Sat, 3 Aug 2013, Felix Rubio Dalmau wrote:
> 
> > I'm experiencing problems to set-up the expire plugin in dovecot. This 
> > is the relevant part of my dovecot configuration
> 
> Well, one "relevant" part is missing: your Dovecot version.
> Therefore you should always post the dovecot -n output.
> 
> > plugin {
> >   expire = Trash 15 Junk 15
> 
> This is a setting for Dovecot v1. Are you using Dovecot v2? Then see
> http://wiki2.dovecot.org/Plugins/Expire.
> 
> Regards,
> 
> --
> Steffen Kaiser
>

Re: [Dovecot] problems with expire plugin

2013-08-04 Thread Steffen Kaiser 

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sat, 3 Aug 2013, Felix Rubio Dalmau wrote:


I'm experiencing problems to set-up the expire plugin in dovecot. This 
is the relevant part of my dovecot configuration


Well, one "relevant" part is missing: your Dovecot version.
Therefore you should always post the dovecot -n output.


plugin {
  expire = Trash 15 Junk 15


This is a setting for Dovecot v1. Are you using Dovecot v2? Then see 
http://wiki2.dovecot.org/Plugins/Expire.


Regards,

- -- 
Steffen Kaiser

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iQEVAwUBUf9ENl3r2wJMiz2NAQI/hAf5AQpkY7T/vmHbL/5FN6nyFC7yz8AJk4ta
zxXTKC+GNisuwym9n6PVWXVxuQErQ4616U7xP241tZlbJSs9gJnhV9hvuV1SCKY1
uA2c5+u62H5ejKo3RPsqWeidmjopZ/UyQfO1wvbCl10KhT/UsC78yxInGCwHXnoR
Dihmb3JCMRZbTrCpApLLmG+T2ouyd88YPW5WFdVstVLXvmCnCE3XPXwhZqk9QebV
oEFPNeMgjmEA9ya8PhCB1EVtDtdz1BTpk1MOJlQwlv4vc1C0dNNKPA384Tjen8d7
bEywZfIPsyLa9lEB5CQl2Z0EFuXrLraC6VlMvdYbCbnolsfFNp0miA==
=TA9E
-END PGP SIGNATURE-

Re: [Dovecot] Problems with Expire Plugin

2009-07-18 Thread Robert Schetterer 
Robert Schetterer schrieb:
> Timo Sirainen schrieb:
>> On Fri, 2009-07-17 at 00:07 +0200, Robert Schetterer wrote:
>>> Timo Sirainen schrieb:
 I'm getting tired of explaining again and again how expire plugin is
 supposed to work, so I added now Example #1 timeline and Example #2
 timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
 what is supposed to happen with a couple of examples. Do they finally
 help understanding how exactly things are supposed to work?
>>> Hi Timo, your examples are well to understand,
>>> i ve tested the mysql setup also using ... --test
>>> everything looks fine and works as it should but
>>> mails dont get deleted, 
>> Then everything doesn't look fine and work.. What exactly do you have in
>> the database and what exactly does --test say?
>>
>>> Anyway the time should be set more shortly for testing
>>> waiting 1 day minimum isnt really fun
>> You could try it in a test machine and just use "date --set". That's how
>> I made the wiki examples.
> 
> ok, lets see
> delete a mail to Trash
> ask in sql
> mysql> select mailbox, from_unixtime(expire_stamp), username from
> expireplugin;
> +-+-+---+
> | mailbox | from_unixtime(expire_stamp) | username  |
> +-+-+---+
> | Trash   | 2009-07-18 09:10:57 | rob...@schetterer.com |
> +-+-+---+
> 1 row in set (0.00 sec)
> 
> looks fine
> 
> /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext
> /usr/lib/dovecot/expire-tool.sh --test
> Info: Loading modules from directory: /usr/lib/dovecot/modules/imap
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib01_acl_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
> Info: Module loaded:
> /usr/lib/dovecot/modules/imap/lib20_autocreate_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_expire_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_fts_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_virtual_plugin.so
> Info: Module loaded: /usr/lib/dovecot/modules/imap/lib21_fts_squat_plugin.so
> Info: Quota root: name= backend=dict args=:proxy::quotadict
> Info: Quota warning: bytes=0 (95%) messages=0
> command=/usr/local/bin/quota-warning.sh 95
> Info: Quota warning: bytes=0 (80%) messages=0
> command=/usr/local/bin/quota-warning.sh 80
> Info: expire: pattern=Trash type=expunge secs=86400
> Info: expire: pattern=Trash/* type=expunge secs=86400
> Info: rob...@schetterer.com/Trash: stop, expire time in future: Sat Jul
> 18 09:10:57 2009
> 
> looks fine too
> 
> running cron
> */10   * * * *   root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
> --exec-mail ext /usr/lib/dovecot/expire-tool.sh >/dev/null 2>&1
> 
> so lets see if mail gets deleted on 2009-07-18 09:10:57
> 
> in my former tests it wasnt
> 
Hi Timo,
the mail did not got deleted
 so whats now ?
any hint where in the log i might find the problem ?
running now

/usr/sbin/dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext
/usr/lib/dovecot/expire-tool.sh --test
Info: Loading modules from directory: /usr/lib/dovecot/modules/imap
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib01_acl_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Info: Module loaded:
/usr/lib/dovecot/modules/imap/lib20_autocreate_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_expire_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_fts_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_virtual_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib21_fts_squat_plugin.so
Info: Quota root: name= backend=dict args=:proxy::quotadict
Info: Quota warning: bytes=0 (95%) messages=0
command=/usr/local/bin/quota-warning.sh 95
Info: Quota warning: bytes=0 (80%) messages=0
command=/usr/local/bin/quota-warning.sh 80
Info: expire: pattern=Trash type=expunge secs=86400
Info: expire: pattern=Trash/* type=expunge secs=8640

shows nothing
-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria

Re: [Dovecot] Problems with Expire Plugin

2009-07-17 Thread Robert Schetterer 
Timo Sirainen schrieb:
> On Fri, 2009-07-17 at 00:07 +0200, Robert Schetterer wrote:
>> Timo Sirainen schrieb:
>>> I'm getting tired of explaining again and again how expire plugin is
>>> supposed to work, so I added now Example #1 timeline and Example #2
>>> timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
>>> what is supposed to happen with a couple of examples. Do they finally
>>> help understanding how exactly things are supposed to work?
>> Hi Timo, your examples are well to understand,
>> i ve tested the mysql setup also using ... --test
>> everything looks fine and works as it should but
>> mails dont get deleted, 
> 
> Then everything doesn't look fine and work.. What exactly do you have in
> the database and what exactly does --test say?
> 
>> Anyway the time should be set more shortly for testing
>> waiting 1 day minimum isnt really fun
> 
> You could try it in a test machine and just use "date --set". That's how
> I made the wiki examples.

ok, lets see
delete a mail to Trash
ask in sql
mysql> select mailbox, from_unixtime(expire_stamp), username from
expireplugin;
+-+-+---+
| mailbox | from_unixtime(expire_stamp) | username  |
+-+-+---+
| Trash   | 2009-07-18 09:10:57 | rob...@schetterer.com |
+-+-+---+
1 row in set (0.00 sec)

looks fine

/usr/sbin/dovecot -c /etc/dovecot/dovecot.conf --exec-mail ext
/usr/lib/dovecot/expire-tool.sh --test
Info: Loading modules from directory: /usr/lib/dovecot/modules/imap
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib01_acl_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
Info: Module loaded:
/usr/lib/dovecot/modules/imap/lib20_autocreate_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_expire_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_fts_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib20_virtual_plugin.so
Info: Module loaded: /usr/lib/dovecot/modules/imap/lib21_fts_squat_plugin.so
Info: Quota root: name= backend=dict args=:proxy::quotadict
Info: Quota warning: bytes=0 (95%) messages=0
command=/usr/local/bin/quota-warning.sh 95
Info: Quota warning: bytes=0 (80%) messages=0
command=/usr/local/bin/quota-warning.sh 80
Info: expire: pattern=Trash type=expunge secs=86400
Info: expire: pattern=Trash/* type=expunge secs=86400
Info: rob...@schetterer.com/Trash: stop, expire time in future: Sat Jul
18 09:10:57 2009

looks fine too

running cron
*/10   * * * *   root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
--exec-mail ext /usr/lib/dovecot/expire-tool.sh >/dev/null 2>&1

so lets see if mail gets deleted on 2009-07-18 09:10:57

in my former tests it wasnt

-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria

Re: [Dovecot] Problems with Expire Plugin

2009-07-16 Thread Timo Sirainen 
On Fri, 2009-07-17 at 00:07 +0200, Robert Schetterer wrote:
> Timo Sirainen schrieb:
> > I'm getting tired of explaining again and again how expire plugin is
> > supposed to work, so I added now Example #1 timeline and Example #2
> > timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
> > what is supposed to happen with a couple of examples. Do they finally
> > help understanding how exactly things are supposed to work?
> 
> Hi Timo, your examples are well to understand,
> i ve tested the mysql setup also using ... --test
> everything looks fine and works as it should but
> mails dont get deleted, 

Then everything doesn't look fine and work.. What exactly do you have in
the database and what exactly does --test say?

> Anyway the time should be set more shortly for testing
> waiting 1 day minimum isnt really fun

You could try it in a test machine and just use "date --set". That's how
I made the wiki examples.


signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-16 Thread Robert Schetterer 
Timo Sirainen schrieb:
> I'm getting tired of explaining again and again how expire plugin is
> supposed to work, so I added now Example #1 timeline and Example #2
> timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
> what is supposed to happen with a couple of examples. Do they finally
> help understanding how exactly things are supposed to work?

Hi Timo, your examples are well to understand,
i ve tested the mysql setup also using ... --test
everything looks fine and works as it should but
mails dont get deleted, i am testing this with 1.2.1 since
a few days, any hint what to search for in the logs to find out whats
going wrong ?
Anyway the time should be set more shortly for testing
waiting 1 day minimum isnt really fun

> 
> Unfortunately X-SAVEDATE doesn't work with current 1.2 versions, because
> of a bug. If you want to look at them, you can apply this patch to
> v1.2.1: http://hg.dovecot.org/dovecot-1.2/rev/f353c5b71097
> 
> On Fri, 2009-07-10 at 10:58 -0500, Jose Luis Marin Perez wrote:
>> Dear Timo,
>>
>> As I understand with regard to Expire plugin is marking the folder will
>> be deleted in a certain amount of days and that the deletion is
>> performed by expire-tool 
>>
>>  Expire plugin works correctly, and
>> I can check on the database folder has been marked, the problem is with
>> expire-tool as it does the deletion. 
>>
>>  This is intended to expire Expire Plugin-tool?
>>
>> Please require your help to solve this problem. 
>>
>>  I apologize for my low level of knowledge about these issues, but what 
>> interests me is to learn.
>>
>> Thanks
>>
>> Jose Luis
>>
>>> From: jolumape...@hotmail.com
>>> To: t...@iki.fi
>>> Date: Thu, 9 Jul 2009 14:18:28 -0500
>>> CC: dovecot@dovecot.org
>>> Subject: Re: [Dovecot] Problems with Expire Plugin
>>>
>>>
>>> Dear Timo
>>>
>>> I have set up crontab to run the tool expires at midnight 
>>>
>>>  When running with the --test option: 
>>>
>>> Info: User lookup failed: jma...@sistemasunidos.com
>>> Info: jma...@sistemasunidos.com/INBOX.Papelera: no messages left
>>>
>>> When running without the --test option: 
>>>
>>> Does not leave any message and there are no data in the table expires of 
>>> Mysql
>>>
>>>  I reviewed the Trash folder and still holds the emails. 
>>>
>>>
>>> It should be noted that for purposes of the test today I sent two
>>> emails and copied to the Papelera folder so that after executing the
>>> end-tool should be removed
>>>
>>> Thanks
>>>
>>> Jose Luis
>>>
>>>> Subject: Re: [Dovecot] Problems with Expire Plugin
>>>> From: t...@iki.fi
>>>> To: jolumape...@hotmail.com
>>>> CC: dovecot@dovecot.org
>>>> Date: Thu, 9 Jul 2009 14:57:19 -0400
>>>>
>>>> On Thu, 2009-07-09 at 12:12 -0500, Jose Luis Marin Perez wrote:
>>>>>  Now my problem is with expire-tool because it is not deleting the
>>>>> emails in the folder that has been marked by Expire Plugin. 
>>>> Did you read how exactly it works?
>>>> http://wiki.dovecot.org/Plugins/Expire
>>>>
>>>>>  This is the command that I run through crontab:
>>>>>
>>>>> /usr/local/sbin/dovecot --exec-mail ext 
>>>>> /usr/local/libexec/dovecot/expire-tool
>>>> Giving --test parameter shows what it's really doing.
>>>>
>>>>> | jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |
>>>> 1247162400 = Thu Jul  9 18:00:00 UTC 2009
>>>>
>>>> So it should have started checking and expunging oldest message(s) from
>>>> this mailbox about an hour ago (as of when I'm writing this mail).
>>>>
>>> _
>>> News, entertainment and everything you care about at Live.com. Get it now!
>>> http://www.live.com/getstarted.aspx
>> _
>> Explore the seven wonders of the world
>> http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE


-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria

Re: [Dovecot] Problems with Expire Plugin

2009-07-13 Thread Jose Luis Marin Perez 

Dear Timo, 

 Thank you for the patience and support, setting userdb vpopmail expire plugin 
could operate.

Thanks

Jose Luis

> From: t...@iki.fi
> To: jolumape...@hotmail.com
> Date: Sun, 12 Jul 2009 15:52:50 -0400
> CC: dovecot@dovecot.org
> Subject: Re: [Dovecot] Problems with Expire Plugin
> 
> Then you'll need to figure out some other userdb that lets Doveot get  
> those directories with a userdb lookup. Have you tried userdb  
> vpopmail? You can still keep using userdb prefetch for imap/pop3, just  
> add the userdb vpopmail after the prefetch.
> 
> On Jul 12, 2009, at 3:20 PM, Jose Luis Marin Perez wrote:
> 
> >
> > Dear Timo,
> >
> > Thankas for your reply.
> >
> > Initially I configure static userdb static and worked for all accounts
> > except for those with the directory with the following format
> >
> > /usr/vpopmail/domain/sistemasunidos/0/jmarin
> > /usr/vpopmail/domain/sistemasunidos/1/lcampo
> >
> > So I had to configure userdb prefetch
> >
> > How could solve this problem because I have many accounts that have  
> > the format described above
> >
> > Thanks
> >
> > Jose Luis
> >
> >> CC: dovecot@dovecot.org
> >> From: t...@iki.fi
> >> To: jolumape...@hotmail.com
> >> Subject: Re: [Dovecot] Problems with Expire Plugin
> >> Date: Sun, 12 Jul 2009 14:20:19 -0400
> >>
> >> On Jul 11, 2009, at 2:36 AM, Jose Luis Marin Perez wrote:
> >>
> >>> When running expire-tool --test shows the following message on
> >>> dovecot.log:
> >>>
> >>> dovecot: Jul 11 02:05:12 Error: auth(default): 
> >>> prefetch(jma...@sistemasunidos.com
> >>> ): userdb lookup not possible with only userdb prefetch
> >>
> >> Yeah, that's probably the reason it's not working. Dovecot needs to
> >> figure out user's userdb configuration but you've only configured
> >> userdb prefetch. You'd need to configure another userdb after the
> >> prefetch that allows Dovecot to do userdb lookups (without first
> >> authenticating, it doesn't know the users' passwords).
> >>
> >>>> passdb:
> >>>>   driver: checkpassword
> >>>>   args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
> >>>> userdb:
> >>>>   driver: prefetch
> >>>>   args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
> >>
> >> Looks like you're trying to use userdb prefetch as if it were userdb
> >> static. Those "args" in prefetch are ignored completely. If all your
> >> users use those uid/gid/home, perhaps you should be using userdb
> >> static instead of prefetch?
> >>
> >
> > _
> > Discover the new Windows Vista
> > http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
> 

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

Re: [Dovecot] Problems with Expire Plugin

2009-07-12 Thread Robert Schetterer 
Timo Sirainen schrieb:
> Then you'll need to figure out some other userdb that lets Doveot get
> those directories with a userdb lookup. Have you tried userdb vpopmail?
> You can still keep using userdb prefetch for imap/pop3, just add the
> userdb vpopmail after the prefetch.
> 
> On Jul 12, 2009, at 3:20 PM, Jose Luis Marin Perez wrote:
> 
>>
>> Dear Timo,
>>
>> Thankas for your reply.
>>
>> Initially I configure static userdb static and worked for all accounts
>> except for those with the directory with the following format
>>
>> /usr/vpopmail/domain/sistemasunidos/0/jmarin
>> /usr/vpopmail/domain/sistemasunidos/1/lcampo
>>
>> So I had to configure userdb prefetch
>>
>> How could solve this problem because I have many accounts that have
>> the format described above
>>
>> Thanks
>>
>> Jose Luis
>>
>>> CC: dovecot@dovecot.org
>>> From: t...@iki.fi
>>> To: jolumape...@hotmail.com
>>> Subject: Re: [Dovecot] Problems with Expire Plugin
>>> Date: Sun, 12 Jul 2009 14:20:19 -0400
>>>
>>> On Jul 11, 2009, at 2:36 AM, Jose Luis Marin Perez wrote:
>>>
>>>> When running expire-tool --test shows the following message on
>>>> dovecot.log:
>>>>
>>>> dovecot: Jul 11 02:05:12 Error: auth(default):
>>>> prefetch(jma...@sistemasunidos.com
>>>> ): userdb lookup not possible with only userdb prefetch
>>>
>>> Yeah, that's probably the reason it's not working. Dovecot needs to
>>> figure out user's userdb configuration but you've only configured
>>> userdb prefetch. You'd need to configure another userdb after the
>>> prefetch that allows Dovecot to do userdb lookups (without first
>>> authenticating, it doesn't know the users' passwords).
>>>
>>>>> passdb:
>>>>>   driver: checkpassword
>>>>>   args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
>>>>> userdb:
>>>>>   driver: prefetch
>>>>>   args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
>>>
>>> Looks like you're trying to use userdb prefetch as if it were userdb
>>> static. Those "args" in prefetch are ignored completely. If all your
>>> users use those uid/gid/home, perhaps you should be using userdb
>>> static instead of prefetch?
>>>
>>
>> _
>> Discover the new Windows Vista
>> http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
> 

Hi Timo,

i am still in testing expire plugin too,
perhaps i would be usefull to have smaller time condition settings
i think the smallest setting recent is 1 which means 1 day
for testing it would be nice too have hours and minutes too,
dont know if this would be a big problem to code

-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria

Re: [Dovecot] Problems with Expire Plugin

2009-07-12 Thread Timo Sirainen 
Then you'll need to figure out some other userdb that lets Doveot get  
those directories with a userdb lookup. Have you tried userdb  
vpopmail? You can still keep using userdb prefetch for imap/pop3, just  
add the userdb vpopmail after the prefetch.


On Jul 12, 2009, at 3:20 PM, Jose Luis Marin Perez wrote:



Dear Timo,

Thankas for your reply.

Initially I configure static userdb static and worked for all accounts
except for those with the directory with the following format

/usr/vpopmail/domain/sistemasunidos/0/jmarin
/usr/vpopmail/domain/sistemasunidos/1/lcampo

So I had to configure userdb prefetch

How could solve this problem because I have many accounts that have  
the format described above


Thanks

Jose Luis


CC: dovecot@dovecot.org
From: t...@iki.fi
To: jolumape...@hotmail.com
Subject: Re: [Dovecot] Problems with Expire Plugin
Date: Sun, 12 Jul 2009 14:20:19 -0400

On Jul 11, 2009, at 2:36 AM, Jose Luis Marin Perez wrote:


When running expire-tool --test shows the following message on
dovecot.log:

dovecot: Jul 11 02:05:12 Error: auth(default): 
prefetch(jma...@sistemasunidos.com
): userdb lookup not possible with only userdb prefetch


Yeah, that's probably the reason it's not working. Dovecot needs to
figure out user's userdb configuration but you've only configured
userdb prefetch. You'd need to configure another userdb after the
prefetch that allows Dovecot to do userdb lookups (without first
authenticating, it doesn't know the users' passwords).


passdb:
  driver: checkpassword
  args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
userdb:
  driver: prefetch
  args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u


Looks like you're trying to use userdb prefetch as if it were userdb
static. Those "args" in prefetch are ignored completely. If all your
users use those uid/gid/home, perhaps you should be using userdb
static instead of prefetch?



_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

Re: [Dovecot] Problems with Expire Plugin

2009-07-12 Thread Jose Luis Marin Perez 

Dear Timo,

Thankas for your reply.

Initially I configure static userdb static and worked for all accounts
except for those with the directory with the following format 

 /usr/vpopmail/domain/sistemasunidos/0/jmarin 
 /usr/vpopmail/domain/sistemasunidos/1/lcampo 

 So I had to configure userdb prefetch 

 How could solve this problem because I have many accounts that have the format 
described above

Thanks

Jose Luis

> CC: dovecot@dovecot.org
> From: t...@iki.fi
> To: jolumape...@hotmail.com
> Subject: Re: [Dovecot] Problems with Expire Plugin
> Date: Sun, 12 Jul 2009 14:20:19 -0400
> 
> On Jul 11, 2009, at 2:36 AM, Jose Luis Marin Perez wrote:
> 
> > When running expire-tool --test shows the following message on  
> > dovecot.log:
> >
> > dovecot: Jul 11 02:05:12 Error: auth(default): 
> > prefetch(jma...@sistemasunidos.com 
> > ): userdb lookup not possible with only userdb prefetch
> 
> Yeah, that's probably the reason it's not working. Dovecot needs to  
> figure out user's userdb configuration but you've only configured  
> userdb prefetch. You'd need to configure another userdb after the  
> prefetch that allows Dovecot to do userdb lookups (without first  
> authenticating, it doesn't know the users' passwords).
> 
> >>  passdb:
> >>driver: checkpassword
> >>args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
> >>  userdb:
> >>driver: prefetch
> >>args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
> 
> Looks like you're trying to use userdb prefetch as if it were userdb  
> static. Those "args" in prefetch are ignored completely. If all your  
> users use those uid/gid/home, perhaps you should be using userdb  
> static instead of prefetch?
> 

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

Re: [Dovecot] Problems with Expire Plugin

2009-07-12 Thread Timo Sirainen 

On Jul 11, 2009, at 2:36 AM, Jose Luis Marin Perez wrote:

When running expire-tool --test shows the following message on  
dovecot.log:


dovecot: Jul 11 02:05:12 Error: auth(default): prefetch(jma...@sistemasunidos.com 
): userdb lookup not possible with only userdb prefetch


Yeah, that's probably the reason it's not working. Dovecot needs to  
figure out user's userdb configuration but you've only configured  
userdb prefetch. You'd need to configure another userdb after the  
prefetch that allows Dovecot to do userdb lookups (without first  
authenticating, it doesn't know the users' passwords).



 passdb:
   driver: checkpassword
   args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
 userdb:
   driver: prefetch
   args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u


Looks like you're trying to use userdb prefetch as if it were userdb  
static. Those "args" in prefetch are ignored completely. If all your  
users use those uid/gid/home, perhaps you should be using userdb  
static instead of prefetch?

Re: [Dovecot] Problems with Expire Plugin

2009-07-10 Thread Jose Luis Marin Perez 

Dear Timo,

When running expire-tool --test shows the following message on dovecot.log: 

dovecot: Jul 11 02:05:12 Error: auth(default): 
prefetch(jma...@sistemasunidos.com): userdb lookup not possible with only 
userdb prefetch

I need to add some configuration? 

 Thanks

Jose Luis


> From: jolumape...@hotmail.com
> To: dovecot@dovecot.org
> Date: Fri, 10 Jul 2009 17:41:48 -0500
> Subject: Re: [Dovecot] Problems with Expire Plugin
> 
> 
> I appreciate the explanation. 
> 
> The Papelera folder is set to expire in 1 day
>  
> The Trash folder is empty, Yesterda when
> I copy the first mail a the folder Papelera, the table expires is updated.
> 
> +-+-+
> | mailbox | from_unixtime(expire_stamp) |
> +-+-+
> | jma...@sistemasunidos.com/INBOX.Papelera | 2009-07-10 17:20:30 |
> +-+-+
> 
> Before of 2009-07-10 17:20:30, when run expire-tool --test showed this 
> message:
> 
> [r...@mail ~]# dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool 
> --test
> Info: jma...@enlaceaduanero.com.pe/INBOX.Papelera: stop, expire time in 
> future: Fri Jul 10 17:20:30 2009
> 
> After of 2009-07-10 17:20:30, when run expire-tool did not show any message 
> and delete data from table expires.
> 
> In reviewing the Trash folder, the mail that was copied was maintained. 
> 
>  This problem may be with the version of dovecot 1.1.6 or settings of Maildir 
> or namespace? 
> 
> Thanks for your help!!
> 
> dovecot -n
> 
> # 1.1.16: /usr/local/etc/dovecot.conf
> Warning: There is no way to login to this server: disable_plaintext_auth=yes, 
> ssl-disable=yes, no non-plaintext auth mechanisms.
> # OS: Linux 2.6.9-67.0.7.EL i686 CentOS release 4.6 (Final)
> log_path: /var/log/dovecot.log
> protocols: imap
> listen: *:10143
> ssl_disable: yes
> login_dir: /usr/local/var/run/dovecot/login
> login_executable: /usr/local/libexec/dovecot/imap-login
> first_valid_uid: 89
> last_valid_uid: 89
> first_valid_gid: 89
> last_valid_gid: 89
> mail_uid: 89
> mail_gid: 89
> mail_location: maildir:~/Maildir
> mail_debug: yes
> mail_plugins: quota imap_quota autocreate expire
> namespace:
>   type: private
>   separator: .
>   prefix: INBOX.
>   inbox: yes
>   list: yes
>   subscriptions: yes
> auth default:
>   passdb:
> driver: checkpassword
> args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
>   userdb:
> driver: prefetch
> args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
>   socket:
> type: listen
> master:
>   path: /usr/local/var/run/dovecot/auth-master
>   mode: 384
>   user: vpopmail
>   group: vchkpw
> plugin:
>   quota: maildir
>   quota_rule: ?:storage=0
>   quota_rule2: Trash:ignore
>   quota_rule3: Papelera:ignore
>   expire: INBOX.Papelera 1 INBOX.Papelera.* 1
>   expire_dict: proxy::expire
>   autocreate: INBOX.Papelera
>   autosubscribe: INBOX.Papelera
> dict:
>   expire: mysql:/usr/local/etc/dovecot-dict-expire.conf
> 
> 
> 
> 
> > From: t...@iki.fi
> > To: jolumape...@hotmail.com
> > Date: Mon, 27 Jul 2009 16:45:56 -0400
> > CC: dovecot@dovecot.org
> > Subject: Re: [Dovecot] Problems with Expire Plugin
> > 
> > I'm getting tired of explaining again and again how expire plugin is
> > supposed to work, so I added now Example #1 timeline and Example #2
> > timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
> > what is supposed to happen with a couple of examples. Do they finally
> > help understanding how exactly things are supposed to work?
> > 
> > Unfortunately X-SAVEDATE doesn't work with current 1.2 versions, because
> > of a bug. If you want to look at them, you can apply this patch to
> > v1.2.1: http://hg.dovecot.org/dovecot-1.2/rev/f353c5b71097
> > 
> > On Fri, 2009-07-10 at 10:58 -0500, Jose Luis Marin Perez wrote:
> > > Dear Timo,
> > > 
> > > As I understand with regard to Expire plugin is marking the folder will
> > > be deleted in a certain amount of days and that the deletion is
> > > performed by expire-tool 
> > > 
> > >  Expire plugin works correctly, and
> > > I can check on the database folder has been marked, the problem is with
> > > expire-tool as it does the deletion. 
> > > 
> > >  This is intended to expire Expire Plugin-tool?
> > > 
> > > Please require

Re: [Dovecot] Problems with Expire Plugin

2009-07-10 Thread Jose Luis Marin Perez 

I appreciate the explanation. 

The Papelera folder is set to expire in 1 day
 
The Trash folder is empty, Yesterda when
I copy the first mail a the folder Papelera, the table expires is updated.

+-+-+
| mailbox | from_unixtime(expire_stamp) |
+-+-+
| jma...@sistemasunidos.com/INBOX.Papelera | 2009-07-10 17:20:30 |
+-+-+

Before of 2009-07-10 17:20:30, when run expire-tool --test showed this message:

[r...@mail ~]# dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool 
--test
Info: jma...@enlaceaduanero.com.pe/INBOX.Papelera: stop, expire time in future: 
Fri Jul 10 17:20:30 2009

After of 2009-07-10 17:20:30, when run expire-tool did not show any message and 
delete data from table expires.

In reviewing the Trash folder, the mail that was copied was maintained. 

 This problem may be with the version of dovecot 1.1.6 or settings of Maildir 
or namespace? 

Thanks for your help!!

dovecot -n

# 1.1.16: /usr/local/etc/dovecot.conf
Warning: There is no way to login to this server: disable_plaintext_auth=yes, 
ssl-disable=yes, no non-plaintext auth mechanisms.
# OS: Linux 2.6.9-67.0.7.EL i686 CentOS release 4.6 (Final)
log_path: /var/log/dovecot.log
protocols: imap
listen: *:10143
ssl_disable: yes
login_dir: /usr/local/var/run/dovecot/login
login_executable: /usr/local/libexec/dovecot/imap-login
first_valid_uid: 89
last_valid_uid: 89
first_valid_gid: 89
last_valid_gid: 89
mail_uid: 89
mail_gid: 89
mail_location: maildir:~/Maildir
mail_debug: yes
mail_plugins: quota imap_quota autocreate expire
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
  list: yes
  subscriptions: yes
auth default:
  passdb:
driver: checkpassword
args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
  userdb:
driver: prefetch
args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
  socket:
type: listen
master:
  path: /usr/local/var/run/dovecot/auth-master
  mode: 384
  user: vpopmail
  group: vchkpw
plugin:
  quota: maildir
  quota_rule: ?:storage=0
  quota_rule2: Trash:ignore
  quota_rule3: Papelera:ignore
  expire: INBOX.Papelera 1 INBOX.Papelera.* 1
  expire_dict: proxy::expire
  autocreate: INBOX.Papelera
  autosubscribe: INBOX.Papelera
dict:
  expire: mysql:/usr/local/etc/dovecot-dict-expire.conf




> From: t...@iki.fi
> To: jolumape...@hotmail.com
> Date: Mon, 27 Jul 2009 16:45:56 -0400
> CC: dovecot@dovecot.org
> Subject: Re: [Dovecot] Problems with Expire Plugin
> 
> I'm getting tired of explaining again and again how expire plugin is
> supposed to work, so I added now Example #1 timeline and Example #2
> timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
> what is supposed to happen with a couple of examples. Do they finally
> help understanding how exactly things are supposed to work?
> 
> Unfortunately X-SAVEDATE doesn't work with current 1.2 versions, because
> of a bug. If you want to look at them, you can apply this patch to
> v1.2.1: http://hg.dovecot.org/dovecot-1.2/rev/f353c5b71097
> 
> On Fri, 2009-07-10 at 10:58 -0500, Jose Luis Marin Perez wrote:
> > Dear Timo,
> > 
> > As I understand with regard to Expire plugin is marking the folder will
> > be deleted in a certain amount of days and that the deletion is
> > performed by expire-tool 
> > 
> >  Expire plugin works correctly, and
> > I can check on the database folder has been marked, the problem is with
> > expire-tool as it does the deletion. 
> > 
> >  This is intended to expire Expire Plugin-tool?
> > 
> > Please require your help to solve this problem. 
> > 
> >  I apologize for my low level of knowledge about these issues, but what 
> > interests me is to learn.
> > 
> > Thanks
> > 
> > Jose Luis
> > 
> > > From: jolumape...@hotmail.com
> > > To: t...@iki.fi
> > > Date: Thu, 9 Jul 2009 14:18:28 -0500
> > > CC: dovecot@dovecot.org
> > > Subject: Re: [Dovecot] Problems with Expire Plugin
> > > 
> > > 
> > > Dear Timo
> > > 
> > > I have set up crontab to run the tool expires at midnight 
> > > 
> > >  When running with the --test option: 
> > > 
> > > Info: User lookup failed: jma...@sistemasunidos.com
> > > Info: jma...@sistemasunidos.com/INBOX.Papelera: no messages left
> > > 
> > > When running without the --test option: 
> > > 
> > > Does not leave any message and there are no data in the table expires of 
> > > Mysql
> > > 
>

Re: [Dovecot] Problems with Expire Plugin

2009-07-10 Thread Timo Sirainen 
I'm getting tired of explaining again and again how expire plugin is
supposed to work, so I added now Example #1 timeline and Example #2
timeline to http://wiki.dovecot.org/Plugins/Expire which tell exactly
what is supposed to happen with a couple of examples. Do they finally
help understanding how exactly things are supposed to work?

Unfortunately X-SAVEDATE doesn't work with current 1.2 versions, because
of a bug. If you want to look at them, you can apply this patch to
v1.2.1: http://hg.dovecot.org/dovecot-1.2/rev/f353c5b71097

On Fri, 2009-07-10 at 10:58 -0500, Jose Luis Marin Perez wrote:
> Dear Timo,
> 
> As I understand with regard to Expire plugin is marking the folder will
> be deleted in a certain amount of days and that the deletion is
> performed by expire-tool 
> 
>  Expire plugin works correctly, and
> I can check on the database folder has been marked, the problem is with
> expire-tool as it does the deletion. 
> 
>  This is intended to expire Expire Plugin-tool?
> 
> Please require your help to solve this problem. 
> 
>  I apologize for my low level of knowledge about these issues, but what 
> interests me is to learn.
> 
> Thanks
> 
> Jose Luis
> 
> > From: jolumape...@hotmail.com
> > To: t...@iki.fi
> > Date: Thu, 9 Jul 2009 14:18:28 -0500
> > CC: dovecot@dovecot.org
> > Subject: Re: [Dovecot] Problems with Expire Plugin
> > 
> > 
> > Dear Timo
> > 
> > I have set up crontab to run the tool expires at midnight 
> > 
> >  When running with the --test option: 
> > 
> > Info: User lookup failed: jma...@sistemasunidos.com
> > Info: jma...@sistemasunidos.com/INBOX.Papelera: no messages left
> > 
> > When running without the --test option: 
> > 
> > Does not leave any message and there are no data in the table expires of 
> > Mysql
> > 
> >  I reviewed the Trash folder and still holds the emails. 
> > 
> > 
> > It should be noted that for purposes of the test today I sent two
> > emails and copied to the Papelera folder so that after executing the
> > end-tool should be removed
> > 
> > Thanks
> > 
> > Jose Luis
> > 
> > > Subject: Re: [Dovecot] Problems with Expire Plugin
> > > From: t...@iki.fi
> > > To: jolumape...@hotmail.com
> > > CC: dovecot@dovecot.org
> > > Date: Thu, 9 Jul 2009 14:57:19 -0400
> > > 
> > > On Thu, 2009-07-09 at 12:12 -0500, Jose Luis Marin Perez wrote:
> > > >  Now my problem is with expire-tool because it is not deleting the
> > > > emails in the folder that has been marked by Expire Plugin. 
> > > 
> > > Did you read how exactly it works?
> > > http://wiki.dovecot.org/Plugins/Expire
> > > 
> > > >  This is the command that I run through crontab:
> > > > 
> > > > /usr/local/sbin/dovecot --exec-mail ext 
> > > > /usr/local/libexec/dovecot/expire-tool
> > > 
> > > Giving --test parameter shows what it's really doing.
> > > 
> > > > | jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |
> > > 
> > > 1247162400 = Thu Jul  9 18:00:00 UTC 2009
> > > 
> > > So it should have started checking and expunging oldest message(s) from
> > > this mailbox about an hour ago (as of when I'm writing this mail).
> > > 
> > 
> > _
> > News, entertainment and everything you care about at Live.com. Get it now!
> > http://www.live.com/getstarted.aspx
> 
> _
> Explore the seven wonders of the world
> http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE


signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-10 Thread Jose Luis Marin Perez 

Dear Timo,

As I understand with regard to Expire plugin is marking the folder will
be deleted in a certain amount of days and that the deletion is
performed by expire-tool 

 Expire plugin works correctly, and
I can check on the database folder has been marked, the problem is with
expire-tool as it does the deletion. 

 This is intended to expire Expire Plugin-tool?

Please require your help to solve this problem. 

 I apologize for my low level of knowledge about these issues, but what 
interests me is to learn.

Thanks

Jose Luis

> From: jolumape...@hotmail.com
> To: t...@iki.fi
> Date: Thu, 9 Jul 2009 14:18:28 -0500
> CC: dovecot@dovecot.org
> Subject: Re: [Dovecot] Problems with Expire Plugin
> 
> 
> Dear Timo
> 
> I have set up crontab to run the tool expires at midnight 
> 
>  When running with the --test option: 
> 
> Info: User lookup failed: jma...@sistemasunidos.com
> Info: jma...@sistemasunidos.com/INBOX.Papelera: no messages left
> 
> When running without the --test option: 
> 
> Does not leave any message and there are no data in the table expires of Mysql
> 
>  I reviewed the Trash folder and still holds the emails. 
> 
> 
> It should be noted that for purposes of the test today I sent two
> emails and copied to the Papelera folder so that after executing the
> end-tool should be removed
> 
> Thanks
> 
> Jose Luis
> 
> > Subject: Re: [Dovecot] Problems with Expire Plugin
> > From: t...@iki.fi
> > To: jolumape...@hotmail.com
> > CC: dovecot@dovecot.org
> > Date: Thu, 9 Jul 2009 14:57:19 -0400
> > 
> > On Thu, 2009-07-09 at 12:12 -0500, Jose Luis Marin Perez wrote:
> > >  Now my problem is with expire-tool because it is not deleting the
> > > emails in the folder that has been marked by Expire Plugin. 
> > 
> > Did you read how exactly it works?
> > http://wiki.dovecot.org/Plugins/Expire
> > 
> > >  This is the command that I run through crontab:
> > > 
> > > /usr/local/sbin/dovecot --exec-mail ext 
> > > /usr/local/libexec/dovecot/expire-tool
> > 
> > Giving --test parameter shows what it's really doing.
> > 
> > > | jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |
> > 
> > 1247162400 = Thu Jul  9 18:00:00 UTC 2009
> > 
> > So it should have started checking and expunging oldest message(s) from
> > this mailbox about an hour ago (as of when I'm writing this mail).
> > 
> 
> _
> News, entertainment and everything you care about at Live.com. Get it now!
> http://www.live.com/getstarted.aspx

_
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

Re: [Dovecot] Problems with Expire Plugin

2009-07-09 Thread Jose Luis Marin Perez 

Dear Timo

I have set up crontab to run the tool expires at midnight 

 When running with the --test option: 

Info: User lookup failed: jma...@sistemasunidos.com
Info: jma...@sistemasunidos.com/INBOX.Papelera: no messages left

When running without the --test option: 

Does not leave any message and there are no data in the table expires of Mysql

 I reviewed the Trash folder and still holds the emails. 


It should be noted that for purposes of the test today I sent two
emails and copied to the Papelera folder so that after executing the
end-tool should be removed

Thanks

Jose Luis

> Subject: Re: [Dovecot] Problems with Expire Plugin
> From: t...@iki.fi
> To: jolumape...@hotmail.com
> CC: dovecot@dovecot.org
> Date: Thu, 9 Jul 2009 14:57:19 -0400
> 
> On Thu, 2009-07-09 at 12:12 -0500, Jose Luis Marin Perez wrote:
> >  Now my problem is with expire-tool because it is not deleting the
> > emails in the folder that has been marked by Expire Plugin. 
> 
> Did you read how exactly it works?
> http://wiki.dovecot.org/Plugins/Expire
> 
> >  This is the command that I run through crontab:
> > 
> > /usr/local/sbin/dovecot --exec-mail ext 
> > /usr/local/libexec/dovecot/expire-tool
> 
> Giving --test parameter shows what it's really doing.
> 
> > | jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |
> 
> 1247162400 = Thu Jul  9 18:00:00 UTC 2009
> 
> So it should have started checking and expunging oldest message(s) from
> this mailbox about an hour ago (as of when I'm writing this mail).
> 

_
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

Re: [Dovecot] Problems with Expire Plugin

2009-07-09 Thread Timo Sirainen 
On Thu, 2009-07-09 at 12:12 -0500, Jose Luis Marin Perez wrote:
>  Now my problem is with expire-tool because it is not deleting the
> emails in the folder that has been marked by Expire Plugin. 

Did you read how exactly it works?
http://wiki.dovecot.org/Plugins/Expire

>  This is the command that I run through crontab:
> 
> /usr/local/sbin/dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool

Giving --test parameter shows what it's really doing.

> | jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |

1247162400 = Thu Jul  9 18:00:00 UTC 2009

So it should have started checking and expunging oldest message(s) from
this mailbox about an hour ago (as of when I'm writing this mail).



signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-09 Thread Jose Luis Marin Perez 

Dear Timo,

Thanks for your reply. 

 The Expire plugin is working correctly, since it is recording the correct 
information in the table expires. 

 I had a stupid mistake, because they had not compiled MySQL support for 
Dovecot, a thousand apologies. 

 Now my problem is with expire-tool because it is not deleting the emails in 
the folder that has been marked by Expire Plugin. 

 This is the command that I run through crontab:

/usr/local/sbin/dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool

mysql

mysql> select * from expires;
+-+--+
| mailbox | expire_stamp |
+-+--+
| jma...@sistemasunidos.com/INBOX.Papelera |   1247162400 |
+-+--+


dovecot -n

# 1.1.16: /usr/local/etc/dovecot.conf
Warning: There is no way to login to this server: disable_plaintext_auth=yes, 
ssl-disable=yes, no non-plaintext auth mechanisms.
# OS: Linux 2.6.9-67.0.7.EL i686 CentOS release 4.6 (Final)
log_path: /var/log/dovecot.log
protocols: imap
listen: *:10143
ssl_disable: yes
login_dir: /usr/local/var/run/dovecot/login
login_executable: /usr/local/libexec/dovecot/imap-login
first_valid_uid: 89
last_valid_uid: 89
first_valid_gid: 89
last_valid_gid: 89
mail_uid: 89
mail_gid: 89
mail_location: maildir:~/Maildir
mail_debug: yes
mail_plugins: quota imap_quota autocreate expire
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
  list: yes
  subscriptions: yes
auth default:
  passdb:
driver: checkpassword
args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
  userdb:
driver: prefetch
args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
  socket:
type: listen
master:
  path: /usr/local/var/run/dovecot/auth-master
  mode: 384
  user: vpopmail
  group: vchkpw
plugin:
  quota: maildir
  quota_rule: ?:storage=0
  quota_rule2: Trash:ignore
  quota_rule3: Papelera:ignore
  expire: INBOX.Papelera 1 INBOX.Papelera.* 1
  expire_dict: proxy::expire
  autocreate: INBOX.Papelera
  autosubscribe: INBOX.Papelera
dict:
  expire: mysql:/usr/local/etc/dovecot-dict-expire.conf

Thanks for you help

Jose Luis


> Subject: Re: [Dovecot] Problems with Expire Plugin
> From: t...@iki.fi
> To: jolumape...@hotmail.com
> CC: dovecot@dovecot.org
> Date: Tue, 7 Jul 2009 23:44:43 -0400
> 
> On Tue, 2009-07-07 at 14:42 -0500, Jose Luis Marin Perez wrote:
> > I made the change but still tells me that does not register any information 
> > in the table expires. 
> 
> I don't really know. Try if you can get it to work with v1.2 +
> http://hg.dovecot.org/dovecot-1.2/rev/df2d4e398c06 patch? Then it should
> log some more information and maybe that's enough to get it to work
> (with v1.1 too if you want to keep using it).
> 

_
Connect to the next generation of MSN Messenger 
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Timo Sirainen 
On Tue, 2009-07-07 at 14:42 -0500, Jose Luis Marin Perez wrote:
> I made the change but still tells me that does not register any information 
> in the table expires. 

I don't really know. Try if you can get it to work with v1.2 +
http://hg.dovecot.org/dovecot-1.2/rev/df2d4e398c06 patch? Then it should
log some more information and maybe that's enough to get it to work
(with v1.1 too if you want to keep using it).



signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Jose Luis Marin Perez 

Dear Timo,

I made the change but still tells me that does not register any information in 
the table expires. 



 Here's my settings again:

dovecot -n

# 1.1.16: /usr/local/etc/dovecot.conf
Warning: There is no way to login to this server: disable_plaintext_auth=yes, 
ssl-disable=yes, no non-plaintext auth mechanisms.
# OS: Linux 2.6.9-67.0.7.EL i686 CentOS release 4.6 (Final)
log_path: /var/log/dovecot.log
protocols: imap
listen: *:10143
ssl_disable: yes
login_dir: /usr/local/var/run/dovecot/login
login_executable: /usr/local/libexec/dovecot/imap-login
first_valid_uid: 89
last_valid_uid: 89
first_valid_gid: 89
last_valid_gid: 89
mail_uid: 89
mail_gid: 89
mail_location: maildir:~/Maildir
mail_debug: yes
mail_plugins: quota imap_quota autocreate expire
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
  list: yes
  subscriptions: yes
auth default:
  passdb:
driver: checkpassword
args: /usr/vpopmail/bin/vchkpw /usr/local/bin/vchkpw-wrapper.sh
  userdb:
driver: prefetch
args: uid=89 gid=89 home=/usr/vpopmail/domains/%d/%u
plugin:
  quota: maildir
  quota_rule: ?:storage=0
  quota_rule2: Trash:ignore
  quota_rule3: Papelera:ignore
  expire: INBOX.Papelera 7 INBOX.Papelera.* 7
  expire_dict: proxy::expire
  autocreate: INBOX.Papelera
  autosubscribe: INBOX.Papelera
dict:
  expire: mysql:/usr/local/etc/dovecot-dict-expire.conf

/usr/local/etc/dovecot-dict-expire.conf

connect = host=localhost dbname=expunge user=expireuser password=expirepass

# v1.1 only:
table = expires
select_field = expire_stamp
where_field = mailbox
username_field = not_used

mysql> describe expires;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| mailbox  | varchar(255) |  | PRI | |   |
| expire_stamp | int(11)  |  | | 0   |   |
+--+--+--+-+-+---+

mysql> select * from expires;
Empty set (0.00 sec)


I need some extra configuration?

Thanks

Jose Luis

> Subject: Re: [Dovecot] Problems with Expire Plugin
> From: t...@iki.fi
> To: jolumape...@hotmail.com
> CC: dovecot@dovecot.org
> Date: Tue, 7 Jul 2009 15:04:23 -0400
> 
> On Tue, 2009-07-07 at 14:01 -0500, Jose Luis Marin Perez wrote:
> > Hi Timo,
> > 
> > But the Quota plugin if it works what is not working on the Expire plugin.
> 
> Just ignore the quota parts of my previous mails, but don't ignore what
> I said about expire:
> 
> > >   expire: Papelera 7 Papelera/* 7
> 
> This needs to be instead:
> 
> expire = INBOX.Papelera 7 INBOX.Papelera.* 7
> 

_
Connect to the next generation of MSN Messenger 
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Timo Sirainen 
On Tue, 2009-07-07 at 14:01 -0500, Jose Luis Marin Perez wrote:
> Hi Timo,
> 
> But the Quota plugin if it works what is not working on the Expire plugin.

Just ignore the quota parts of my previous mails, but don't ignore what
I said about expire:

> >   expire: Papelera 7 Papelera/* 7

This needs to be instead:

expire = INBOX.Papelera 7 INBOX.Papelera.* 7



signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Jose Luis Marin Perez 

Hi Timo,

But the Quota plugin if it works what is not working on the Expire plugin.

I have to add some additional configuration to send to my email earlier?

Thanks

Jose Luis

> Subject: Re: [Dovecot] Problems with Expire Plugin
> From: t...@iki.fi
> To: dovecot@dovecot.org
> CC: jolumape...@hotmail.com
> Date: Tue, 7 Jul 2009 14:24:15 -0400
> 
> On Tue, 2009-07-07 at 13:50 -0400, Timo Sirainen wrote:
> > quota_rule2 = INBOX.Trash:ignore
> > 
> > >   quota_rule3: Papelera:ignore
> > 
> > quota_rule3 = INBOX.Papelera:ignore
> 
> Hmm. Actually I was wrong here. I intended them to be configured like
> that though. I guess I'll fix them in v2.0..
> 

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Timo Sirainen 
On Tue, 2009-07-07 at 13:50 -0400, Timo Sirainen wrote:
> quota_rule2 = INBOX.Trash:ignore
> 
> >   quota_rule3: Papelera:ignore
> 
> quota_rule3 = INBOX.Papelera:ignore

Hmm. Actually I was wrong here. I intended them to be configured like
that though. I guess I'll fix them in v2.0..



signature.asc
Description: This is a digitally signed message part

Re: [Dovecot] Problems with Expire Plugin

2009-07-07 Thread Timo Sirainen 
On Tue, 2009-07-07 at 12:05 -0500, Jose Luis Marin Perez wrote:
> namespace:
>   type: private
>   separator: .
>   prefix: INBOX.
>   inbox: yes
>   list: yes
>   subscriptions: yes
..
>   quota: maildir
>   quota_rule: ?:storage=0
>   quota_rule2: Trash:ignore

quota_rule2 = INBOX.Trash:ignore

>   quota_rule3: Papelera:ignore

quota_rule3 = INBOX.Papelera:ignore

>   expire: Papelera 7 Papelera/* 7

expire = INBOX.Papelera 7 Papelera.* 7

>   autocreate: INBOX.Papelera
>   autosubscribe: INBOX.Papelera

Just like here.


signature.asc
Description: This is a digitally signed message part