[Dovecot] Problems with Expire Plugin
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+vista&mkt=en-US&form=QBRE
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.
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: tss@iki.fi To: dovecot@dovecot.org CC: jolumape_al@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
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
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: tss@iki.fi To: jolumape_al@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
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).
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 | +---------------------------------------------+--------------+ | jmarin@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: tss@iki.fi To: jolumape_al@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
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.
| jmarin@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).
Dear Timo
I have set up crontab to run the tool expires at midnight
When running with the --test option:
Info: User lookup failed: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
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_al@hotmail.com To: tss@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: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
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_al@hotmail.com To: tss@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: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
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) | +---------------------------------------------+-----------------------------+ | jmarin@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:
[root@mail ~]# dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool --test Info: jmarin@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: tss@iki.fi To: jolumape_al@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_al@hotmail.com To: tss@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: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
Dear Timo,
When running expire-tool --test shows the following message on dovecot.log:
dovecot: Jul 11 02:05:12 Error: auth(default): prefetch(jmarin@sistemasunidos.com): userdb lookup not possible with only userdb prefetch
I need to add some configuration?
Thanks
Jose Luis
From: jolumape_al@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) | +---------------------------------------------+-----------------------------+ | jmarin@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:
[root@mail ~]# dovecot --exec-mail ext /usr/local/libexec/dovecot/expire-tool --test Info: jmarin@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: tss@iki.fi To: jolumape_al@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_al@hotmail.com To: tss@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: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx
Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
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(jmarin@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?
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: tss@iki.fi To: jolumape_al@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(jmarin@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
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 aboveThanks
Jose Luis
CC: dovecot@dovecot.org From: tss@iki.fi To: jolumape_al@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(jmarin@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
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: tss@iki.fi To: jolumape_al@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(jmarin@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
Dear Timo,
Thank you for the patience and support, setting userdb vpopmail expire plugin could operate.
Thanks
Jose Luis
From: tss@iki.fi To: jolumape_al@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 aboveThanks
Jose Luis
CC: dovecot@dovecot.org From: tss@iki.fi To: jolumape_al@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(jmarin@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
Dear Timo,
This recommendation was made in July 2009 when I ask you about the operation of expiration plugin.
I forward email.
It is possible to solve this problem with Dovecot 1.2.6 or use dovecot 1.2.4?
Thanks
Jose Luis
From: tss@iki.fi To: jolumape_al@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 aboveThanks
Jose Luis
CC: dovecot@dovecot.org From: tss@iki.fi To: jolumape_al@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(jmarin@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
Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
On Fri, 2009-10-16 at 14:27 -0500, Jose Luis Marin Perez wrote:
Dear Timo,
This recommendation was made in July 2009 when I ask you about the operation of expiration plugin.
But since then you talked about wanting per-user expire settings and that can't work with userdb vpopmail, so I recommended userdb checkpassword: http://dovecot.org/list/dovecot/2009-October/043745.html
It is possible to solve this problem with Dovecot 1.2.6 or use dovecot 1.2.4?
I don't think userdb vpopmail is going to help you, but you could get 1.2.6 compiled by just deleting the vauth_open() line from code. I'll need to figure out something more permanent for it later.
Hi Timo,
When you compile dovecot with the option --without-vpopmail I get this error:
../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text+0x7a2):/usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:648: undefined reference to SSL_COMP_get_name' ../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text+0x11fe): In function
ssl_proxy_ctx_init':
/usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:818: undefined reference to SSL_CTX_set_info_callback' collect2: ld returned 1 exit status make[3]: *** [imap-login] Error 1 make[3]: Leaving directory
/usr/local/src/dovecot/dovecot-1.2.6/src/imap-login'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory /usr/local/src/dovecot/dovecot-1.2.6/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory
/usr/local/src/dovecot/dovecot-1.2.6'
make: *** [all] Error 2
There is some patch to fix this?
Information: CentOS4.6 openssl-0.9.7a-43.17.el4_7.2
Thanks
Jose Luis
Subject: Re: [Dovecot] Problems compiling dovecot 1.2 with vpopmail From: tss@iki.fi To: jolumape_al@hotmail.com CC: dovecot@dovecot.org Date: Fri, 16 Oct 2009 15:37:38 -0400
On Fri, 2009-10-16 at 14:27 -0500, Jose Luis Marin Perez wrote:
Dear Timo,
This recommendation was made in July 2009 when I ask you about the operation of expiration plugin.
But since then you talked about wanting per-user expire settings and that can't work with userdb vpopmail, so I recommended userdb checkpassword: http://dovecot.org/list/dovecot/2009-October/043745.html
It is possible to solve this problem with Dovecot 1.2.6 or use dovecot 1.2.4?
I don't think userdb vpopmail is going to help you, but you could get 1.2.6 compiled by just deleting the vauth_open() line from code. I'll need to figure out something more permanent for it later.
Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
On Fri, 2009-10-16 at 17:56 -0500, Jose Luis Marin Perez wrote:
Hi Timo,
When you compile dovecot with the option --without-vpopmail I get this error:
../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text +0x7a2):/usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:648: undefined reference to `SSL_COMP_get_name'
This happens with old OpenSSL versions. You can fix it with attached patch.
Hi Timo,
Now get this error:
/bin/sh ../../libtool --tag=CC --mode=link gcc -std=gnu99 -g -O2 -Wall -W -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -o imap-login client.o client-authenticate.o imap-proxy.o ../login-common/liblogin-common.a ../lib-imap/libimap.a ../lib-auth/libauth.a ../lib/liblib.a -lssl -lcrypto -ldl -lrt
libtool: link: gcc -std=gnu99 -g -O2 -Wall -W -Wmissing-prototypes -Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -o imap-login client.o client-authenticate.o imap-proxy.o ../login-common/liblogin-common.a ../lib-imap/libimap.a ../lib-auth/libauth.a ../lib/liblib.a -lssl -lcrypto -ldl -lrt
../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text+0x11ca): In function ssl_proxy_ctx_init': /usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:824: undefined reference to
SSL_CTX_set_info_callback'
collect2: ld returned 1 exit status
make[3]: *** [imap-login] Error 1
make[3]: Leaving directory /usr/local/src/dovecot/dovecot-1.2.6/src/imap-login' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory
/usr/local/src/dovecot/dovecot-1.2.6/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/dovecot/dovecot-1.2.6'
make: *** [all] Error 2
Thanks
Jose Luis
From: jolumape_al@hotmail.com To: tss@iki.fi Date: Fri, 16 Oct 2009 17:56:22 -0500 CC: dovecot@dovecot.org Subject: Re: [Dovecot] Problems compiling dovecot 1.2 with vpopmail
Hi Timo,
When you compile dovecot with the option --without-vpopmail I get this error:
../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text+0x7a2):/usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:648: undefined reference to
SSL_COMP_get_name' ../login-common/liblogin-common.a(ssl-proxy-openssl.o)(.text+0x11fe): In function
ssl_proxy_ctx_init': /usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:818: undefined reference toSSL_CTX_set_info_callback' collect2: ld returned 1 exit status make[3]: *** [imap-login] Error 1 make[3]: Leaving directory
/usr/local/src/dovecot/dovecot-1.2.6/src/imap-login' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory/usr/local/src/dovecot/dovecot-1.2.6/src' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory
/usr/local/src/dovecot/dovecot-1.2.6' make: *** [all] Error 2There is some patch to fix this?
Information: CentOS4.6 openssl-0.9.7a-43.17.el4_7.2
Thanks
Jose Luis
Subject: Re: [Dovecot] Problems compiling dovecot 1.2 with vpopmail From: tss@iki.fi To: jolumape_al@hotmail.com CC: dovecot@dovecot.org Date: Fri, 16 Oct 2009 15:37:38 -0400
On Fri, 2009-10-16 at 14:27 -0500, Jose Luis Marin Perez wrote:
Dear Timo,
This recommendation was made in July 2009 when I ask you about the operation of expiration plugin.
But since then you talked about wanting per-user expire settings and that can't work with userdb vpopmail, so I recommended userdb checkpassword: http://dovecot.org/list/dovecot/2009-October/043745.html
It is possible to solve this problem with Dovecot 1.2.6 or use dovecot 1.2.4?
I don't think userdb vpopmail is going to help you, but you could get 1.2.6 compiled by just deleting the vauth_open() line from code. I'll need to figure out something more permanent for it later.
Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
On Fri, 2009-10-16 at 18:26 -0500, Jose Luis Marin Perez wrote:
/usr/local/src/dovecot/dovecot-1.2.6/src/login-common/ssl-proxy-openssl.c:824: undefined reference to `SSL_CTX_set_info_callback'
Does the attached patch fix it?
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_al@hotmail.com To: tss@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: jmarin@sistemasunidos.com Info: jmarin@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: tss@iki.fi To: jolumape_al@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.
| jmarin@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
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.
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 | robert@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: robert@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
Robert Schetterer schrieb:
Timo Sirainen schrieb:
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
On Fri, 2009-07-17 at 00:07 +0200, Robert Schetterer wrote: 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 | robert@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: robert@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
participants (3)
-
Jose Luis Marin Perez
-
Robert Schetterer
-
Timo Sirainen