Re: [Dovecot] problems with expire plugin

2013-08-05 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

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

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-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-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 
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 = /etc/postfix/ssl/mail.server.pem
ssl_key = /etc/postfix/ssl/mail.server.key
submission_host = 127.0.0.1:587
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
protocol lmtp {
  mail_plugins = quota zlib sieve
}
protocol lda {
  mail_plugins = quota zlib sieve
}
protocol imap {
  mail_max_userip_connections = 10
  mail_plugins = quota zlib expire imap_quota
}
protocol sieve {
  mail_max_userip_connections = 10
  managesieve_implementation_string = Dovecot Pigeonhole
  managesieve_max_compile_errors = 5
  managesieve_max_line_length = 65536
}

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 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 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 numdaysd

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 à 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 numdaysd

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

[Dovecot] problems with expire plugin

2013-08-03 Thread Felix Rubio Dalmau 
Hi all,

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

dict {
  expire = mysql:/etc/dovecot/dovecot-dict-expire.conf.ext
}

plugin {
  expire = Trash 15 Junk 15
  expire_dict = proxy::expire
}

protocol imap {
  mail_plugins = quota zlib expire imap_quota
}

File dovecot-dict-expire.conf.ext looks like:

connect = host=127.0.0.1 dbname=virtual_email user=user 
password=passw
map {
  pattern = shared/expire/$user/$mailbox
  table = virtual_expires
  value_field = expire_stamp

  fields {
username = $user
mailbox = $mailbox
  }
}

and the mysql schema for table virtual_expires is:
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| username | varchar(75)  | NO   | PRI | NULL|   |
| mailbox  | varchar(255) | NO   | PRI | NULL|   |
| expire_stamp | int(11)  | NO   | | NULL|   |
+--+--+--+-+-+---+

However, when I delete any mail from the Inbox, the table is not 
updated, and there are no messages in the log, although mail_debug is set to 
yes

Does anybody has any idea on how to solve this issue?

Regards!
Felix

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 21
 
 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 21

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 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+worldmkt=en-USform=QBRE


-- 
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-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+vistamkt=en-USform=QBRE
 

_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=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-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+vistamkt=en-USform=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+vistamkt=en-USform=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-11 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 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

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+worldmkt=en-USform=QBRE

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+worldmkt=en-USform=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 

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
   
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

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-ussource=wlmailtagline

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

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

[Dovecot] Problems with Expire Plugin

2009-07-07 Thread Jose Luis Marin Perez 

Dear Sirs,

I try to configure expire plugin to delete emails older than 7 days from the 
Papelera
folder, but I do not see any information recorded in the expires table,
although there are emails that were copied before and after configuring
the plugin.

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: root
  group: root
plugin:
  quota: maildir
  quota_rule: ?:storage=0
  quota_rule2: Trash:ignore
  quota_rule3: Papelera:ignore
  expire: Papelera 7 Papelera/* 7
  expire_dict: proxy::expire
  auth_socket_path: /usr/local/var/run/dovecot/auth-master
  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)

May be missing some configuration to work?

Thanks 

Jose Luis



_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=QBRE

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

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 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+vistamkt=en-USform=QBRE

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 

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-ussource=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