-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 8 Dec 2013, Peter Šori wrote:
Dovecot does not fill expires table when moving messages to Trash or Junk
folder.
I don't use expire, but:
http://wiki2.dovecot.org/Plugins/Expire
disagrees with
# 2.2.6: /etc/dovecot/dovecot.conf
[...]
with combinations. Thanks for help Steffen.
-Original Message-
From: Steffen Kaiser [mailto:skdove...@smail.inf.fh-brs.de]
Sent: Monday, December 9, 2013 9:08 AM
To: Peter Šori
Cc: dovecot@dovecot.org
Subject: Re: [Dovecot] Expire plugin - empty expires table
-BEGIN PGP SIGNED MESSAGE-
Hash
Hello,
Dovecot does not fill expires table when moving messages to Trash or Junk
folder.
I looked all over mailing list and googled around and cannot find what could
be wrong - pleas help :)
Dict works for quota, so I presume connection to mysql is not a problem -
mailuser has
Dumb question: do I need to have a database to run the expire plugin?
You need something, sqlite is perhaps your lightest option.
You need to store the expire data somewhere..
http://wiki2.dovecot.org/Plugins/Expire
On 12/05/2013 04:51 PM, Mauricio Tavares wrote:
Dumb question: do I need to have a database to run the expire plugin?
] expire plugin doesn't work?
On 08/23/2013 09:05 PM, Anton Chigin wrote:
plugin {
expire = Trash 7
expire_dict = proxy::expire
You're using Dovecot 2.1, that configuration syntax is for 1.2.
Please follow documentation at http://wiki2.dovecot.org/Plugins/Expire
21:17:34 -0400
From: geda...@gedalya.net
To: dovecot@dovecot.org; anton.chi...@live.com
Subject: Re: [Dovecot] expire plugin doesn't work?
On 08/23/2013 09:05 PM, Anton Chigin wrote:
plugin {
expire = Trash 7
expire_dict = proxy::expire
You're using Dovecot 2.1, that configuration syntax
...@live.com
CC: dovecot@dovecot.org
Subject: Re: [Dovecot] expire plugin doesn't work?
Yes, you add that cron job, and it
would work with or without the expire plugin.
The thing is that if the expire plugin is enabled, the doveadm
expunge command will look
?
Thanks a lot for your help!
Date: Sat, 24 Aug 2013 06:22:32 -0400
From: geda...@gedalya.net
To: anton.chi...@live.com
CC: dovecot@dovecot.org
Subject: Re: [Dovecot] expire plugin doesn't work?
Yes, you add that cron job
To: anton.chi...@live.com
CC: dovecot@dovecot.org
Subject: Re: [Dovecot] expire plugin doesn't work?
Yes, you add that cron job,
and it would work with or without the expire plugin.
The thing is that if the expire plugin
Subject: Re: [Dovecot] expire plugin doesn't work?
I don't know, why don't you just try?
If you run the exact same command but with search instead of
expunge, it should also use the expire plugin in the same way, so
that should be an easy test.
Are you using sql for passdb? If so I wonder if you
Hello,
I've configured dovecot to use expire plugin:
heres my dovecot -n:
-
# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.2.0-4-amd64 x86_64 Debian 7.1 ext4
auth_mechanisms = plain login
dict {
expire = mysql:/etc/dovecot/dovecot-dict-expire-sql.conf.ext
}
mail_location =
On 08/23/2013 09:05 PM, Anton Chigin wrote:
plugin {
expire = Trash 7
expire_dict = proxy::expire
You're using Dovecot 2.1, that configuration syntax is for 1.2.
Please follow documentation at http://wiki2.dovecot.org/Plugins/Expire
Hello,
I have configured mysql on one server and each mail server use this database
for expire plugin.
I have configured each mail server as explains
on:http://wiki2.dovecot.org/Plugins/Expire
But now I have a question; How i configure director server to use the database?
I need to configure
Hello we are running Dovecot 2.1.9 and I want to configure expire plugin.
We have 2 proxies with director and 4 mail servers.
I have configured expire plugin on a single mail server and it works Ok.
I don't konw how to configure with 4 mail servers and 2 proxies.
My first idea is create on each
Am 11.09.2012 11:41, schrieb Ramón Frontera:
Hello we are running Dovecot 2.1.9 and I want to configure expire plugin.
We have 2 proxies with director and 4 mail servers.
I have configured expire plugin on a single mail server and it works Ok.
I don't konw how to configure with 4 mail
On 11.9.2012, at 12.41, Ramón Frontera wrote:
Hello we are running Dovecot 2.1.9 and I want to configure expire plugin.
We have 2 proxies with director and 4 mail servers.
I have configured expire plugin on a single mail server and it works Ok.
I don't konw how to configure with 4 mail
No ideas? I googled some more and eventually turned up this posting:
http://www.mailinglistarchive.com/html/dovecot@dovecot.org/2011-01/msg00716.html
guy seems to be having the exact problem I am, unfortunately, no-one
replied to his post either :(
On 10/24/2011 7:52 PM, Dan Swartzendruber wrote:
No ideas? I googled some more and eventually turned up this posting:
http://www.mailinglistarchive.com/html/dovecot@dovecot.org/2011-01/msg00716.html
guy seems to be having the exact problem I am, unfortunately, no-one
replied to his post
Running dovecot 1.2.12 on ubuntu 10.10. Here is the problem: I have
mysql backend for expire. I am using the dovecot-postfix package which
creates /etc/dovecot/conf.d/01-mail-stack-delivery.conf which looks like
this:
# Some general options
protocols = imap imaps managesieve
Running dovecot 1.2.12 on ubuntu 10.10. Here is the problem: I have
mysql backend for expire. I am using the dovecot-postfix package which
creates /etc/dovecot/conf.d/01-mail-stack-delivery.conf which looks like
this:
# Some general options
protocols = imap imaps managesieve
On Thu, 10 Feb 2011 02:07:38 +0200, Timo Sirainen t...@iki.fi wrote:
However, the combination of sieve and expire does not seem to be
working: When sieve moves messages into a folder, no entry is
created in
the database. Don't these plugins work together, or did I
misconfigure
something?
On Sat, 2011-01-22 at 08:27 +0100, c...@kruemel.org wrote:
However, the combination of sieve and expire does not seem to be
working: When sieve moves messages into a folder, no entry is created in
the database. Don't these plugins work together, or did I misconfigure
something?
If you
Hi.
I am running dovecot 1.2.9 here, allowing users to filter their mails
with the sieve plugin, and am using sieve to move mail tagged as
probably spam into the spam folder.
I'm now looking to get the expire plugin working as well. It does work
as described in the wiki: Once I manually
On Thu, 2010-12-16 at 20:55 +0100, Christoph Pleger wrote:
dovecot: dict: Error: sqlite: exec(INSERT INTO expires
(expire_stamp,username,mailbox) VALUES ('1292525469','christoph','Trash'))
failed: unable to open database file (14)
So SQLite can't open its database. I don't know what 14
Hello,
But if it's 0666, I'm not really sure what the problem could be. You
could try if dict can access it as root:
service dict {
user = root
}
I have found the solution: The directory where the sqlite3 database resides
must be writable by the dovecot user.
Regards
Christoph
Hello,
I followed the instructions on http://wiki2.dovecot.org/Plugins/Expire to
configure the expire plugin, but when I move a message to the Trash folder, I
get the following error messages in my logfile:
dovecot: dict: Error: sqlite: exec(INSERT INTO expires
(expire_stamp,username,mailbox)
Hello,
I forgot to mention the dovecot version number. It is version 2.0.7.
Regards
Christoph
Timo Sirainen wrote:
On Tue, 2010-08-03 at 10:59 +0200, Arnaud2 bali wrote:
expire: .Trash 1 .Trash/* 1 .Spam 2
Remove '.' before the mailbox names.
That good
Thank you very much
# 1.2.11: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.26-2-amd64 x86_64 Debian 5.0.5
Hi
I try to use expire plugin with mysql
When i use my thunderbird client to delete a message, nothing is write
in the mysql database.
My maildir is look like /home/vmail/homes/arna...@xxx..xxx/
and /etc/dovecot/dovecot-dict-expire.conf :
connect = host=localhost user=xx
On Tue, 2010-08-03 at 10:59 +0200, Arnaud2 bali wrote:
connect = host=localhost user=xx password=x dbname=postfixadmin
map {
pattern = /home/vmail/homes/$user/$mailbox
#shared/expire/$user/$mailbox
..
Is pattern ok ?
No, it always must be shared/expire/$user/$mailbox.
Timo Sirainen wrote:
On Tue, 2010-08-03 at 10:59 +0200, Arnaud2 bali wrote:
connect = host=localhost user=xx password=x dbname=postfixadmin
map {
pattern = /home/vmail/homes/$user/$mailbox
#shared/expire/$user/$mailbox
..
Is pattern ok ?
No, it always must be
On Tue, 2010-08-03 at 10:59 +0200, Arnaud2 bali wrote:
expire: .Trash 1 .Trash/* 1 .Spam 2
Remove '.' before the mailbox names.
2010/6/22 Timo Sirainen t...@iki.fi:
I am testing expire plugin, with quota plugin enabled.
When I execute expire-tool, maildirsize is not updated.
Is there any solution to update maildirsize when executing expire-tool?
# /usr/local/dovecot/sbin/dovecot --version
1.1.18
You could try if
On Mon, 2010-06-21 at 12:25 +0900, suzuki wrote:
Hello,
I am testing expire plugin, with quota plugin enabled.
When I execute expire-tool, maildirsize is not updated.
Is there any solution to update maildirsize when executing expire-tool?
# /usr/local/dovecot/sbin/dovecot --version
Hello,
I am testing expire plugin, with quota plugin enabled.
When I execute expire-tool, maildirsize is not updated.
Is there any solution to update maildirsize when executing expire-tool?
# /usr/local/dovecot/sbin/dovecot --version
1.1.18
# /usr/local/dovecot/sbin/dovecot -n
# 1.1.18:
Hi,
We've resolved the issues that started this thread off. We needed to
recompile our version of Dovecot (1.1.6) with the inclusion of the mySQL
libraries. With this done, we were able to connect Dovecot to the mySQL
db, and got the expire plugin to save times to the db. This works great,
and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 23 Apr 2010, Thomas M Goerger wrote:
How is this socket created? I'd have thought it would be created upon
I would say on the start of Dovecot.
Dovecot starting up, but it is not doing so. Is it something in the
plugin settings that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 22 Apr 2010, Thomas M Goerger wrote:
expires table when I look. Is there anywhere that expire can log to so I
can see what might be happening? It doesn't look like it logs to the
Did you checked that the plugin is loaded at all?
Yes, the plugin is loading. The libraries associated are being touched
upon user login, so it looks like expire is running. Just that nothing is
being added to the database upon a user putting something into the Trash.
We do have our mail not in root of a user folder, but in mail/. So, I
added
I do now see on the console:
Apr 22 16:56:14 mars.tc.umn.edu imap(testg019): :
net_connect_unix(/var/opt/dovecot/run/dovecot/dict-server) failed: Connection
refused
I owned this file to mysql:mysql now, and the error has gone away on
subsequent logins, but I still don't see anything in the db.
Actually, this is where the problem is coming in. We'd switched the
server from using IMAPS to IMAP, and I'd neglected to change the folder
location. So, now using the mail/Trash folder, I'm again seeing the
permission denied. We'd determined that the dict-server socket that was
being used was
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 13 Apr 2010, Timo Sirainen wrote:
The expire plugin keeps track of the oldest message in configured
mailboxes. Its only configuration is the list of tracked mailboxes.
There's no configuration like what the expire timeouts are or anything.
On 14.4.2010, at 11.04, Steffen Kaiser wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 13 Apr 2010, Timo Sirainen wrote:
The expire plugin keeps track of the oldest message in configured
mailboxes. Its only configuration is the list of tracked mailboxes.
There's no
Expire plugin / expire-tool seems annoyingly inflexible currently, so I
was thinking about a more generic redesign:
The expire plugin keeps track of the oldest message in configured
mailboxes. Its only configuration is the list of tracked mailboxes.
There's no configuration like what the expire
On Tue, 2010-01-12 at 17:02 +0100, Roland Rosenfeld wrote:
But the 'mail' attribute from userdb is still ignored by expire.
Well, I'm getting a bit tired of fixing all the issues with expire-tool.
Since you found a working solution for yourself, I won't do anything
about this for now. v2.0 fixes
Hi!
After searching for hours now, I give up and have to ask here. I try
to use the expire plugin but it always tries to expire my mails
instead of the mails of the user.
I read about the Mail location setting problem (v1.1-v1.2) and
configured a mail extra field in the userdb, but that doesn't
On Tue, 12 Jan 2010, I wrote:
After searching for hours now, I give up and have to ask here. I try
to use the expire plugin but it always tries to expire my mails
instead of the mails of the user.
So my main problem seems to be, that the mail attribute from the
userdb is completely ignored
On Mon, 23 Nov 2009 12:01:53 -0500
Timo Sirainen t...@iki.fi wrote:
On Mon, 2009-11-23 at 18:01 +0200, Nikita Koshikov wrote:
On Fri, 06 Nov 2009 18:42:49 -0500
Timo Sirainen t...@iki.fi wrote:
On Fri, 2009-11-06 at 10:27 +0200, Nikita Koshikov wrote:
I don't understand why gdb
On Fri, 06 Nov 2009 18:42:49 -0500
Timo Sirainen t...@iki.fi wrote:
On Fri, 2009-11-06 at 10:27 +0200, Nikita Koshikov wrote:
I don't understand why gdb says no debugging symbols found for some
dovecot's executables, all binaries under /usr/libexec/dovecot have
not stripped
..
(gdb) bt
On Mon, 2009-11-23 at 18:01 +0200, Nikita Koshikov wrote:
On Fri, 06 Nov 2009 18:42:49 -0500
Timo Sirainen t...@iki.fi wrote:
On Fri, 2009-11-06 at 10:27 +0200, Nikita Koshikov wrote:
I don't understand why gdb says no debugging symbols found for some
dovecot's executables, all
On Thu, 05 Nov 2009 12:52:08 -0500
Timo Sirainen t...@iki.fi wrote:
On Sat, 2009-10-31 at 10:42 +0200, Nikita Koshikov wrote:
The patch helped with quotas, but it raises new error - segmentation error
gdb backtrace would be helpful. But how to actually get it could be a
bit difficult,
On Fri, 30 Oct 2009 13:16:47 -0400
Timo Sirainen t...@iki.fi wrote:
On Fri, 2009-10-30 at 14:03 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
See if the attached patch helps? I'm a bit afraid that it could also
break something. If it
On Fri, 30 Oct 2009 13:16:47 -0400
Timo Sirainen t...@iki.fi wrote:
On Fri, 2009-10-30 at 14:03 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
See if the attached patch helps? I'm a bit afraid that it could also
break something. If it
The patch helped with quotas, but it raises new error - segmentation
error
After some more tests, I find out that crash happens, while trying to
proceed the third user, and the user's quota and other settings not
important.
On Thu, 29 Oct 2009 13:10:37 -0400
Timo Sirainen t...@iki.fi wrote:
On Wed, 2009-10-28 at 10:30 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
So the quota_rule should be returned by userdb lookup from ldap, right?
Yes, and it's working
On Thu, 29 Oct 2009 13:10:37 -0400
Timo Sirainen t...@iki.fi wrote:
On Wed, 2009-10-28 at 10:30 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
So the quota_rule should be returned by userdb lookup from ldap, right?
One more clean example.
On Fri, 2009-10-30 at 14:03 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
See if the attached patch helps? I'm a bit afraid that it could also
break something. If it does, there's really no easy way to get this
fixed before v2.0.
diff -r
On Wed, 2009-10-28 at 10:30 +0200, Nikita Koshikov wrote:
The problem that some users have their own quotas stored in ldap.
So the quota_rule should be returned by userdb lookup from ldap, right?
Info: auth input: uid=8
Info: auth input: gid=12
Info: auth input:
Hello list,
After upgrade to dovecot version 1.2.6 I have noticed some quota
malfunctions(users become often overquota). Looking at logs closely I have
found that quota value resets to general dovecot-config(
quota = maildir:Mailbox quota
quota_rule = *:storage=500M
quota_rule2 =
Dear Timo thank you for the help your giving me these.
I want to set expire plugin only for some domains in the same way I set
autocreate plugin.
vchkpw-wrapper.sh
#!/bin/bash
DOMAIN=`echo $VPOPUSER|sed s/^.*@//`
echo $USER /tmp/autocreate
echo $DOMAIN /tmp/autocreate
if [
On Tue, 2009-10-20 at 10:00 -0500, Jose Luis Marin Perez wrote:
My problem is that I have no idea how to create the userdb.sh
From my previous mail:
Then create /usr/local/bin/userdb.sh which does more or less what the
vchkpw-wrapper.sh does, except since it doesn't call vchkpw itself,
/dovecot-dict-expire.conf
Subject: Re: [Dovecot] Expire plugin per domain
From: t...@iki.fi
To: jolumape...@hotmail.com
CC: dovecot@dovecot.org
Date: Tue, 20 Oct 2009 16:25:29 -0400
On Tue, 2009-10-20 at 10:00 -0500, Jose Luis Marin Perez wrote:
My problem is that I have no idea how
On Tue, 2009-10-20 at 15:43 -0500, Jose Luis Marin Perez wrote:
DOMAIN=`echo $VPOPUSER|sed s/^.*@//`
..
vchkpw-wrapper.sh does, except since it doesn't call vchkpw
itself,
it'll need to get the username from $USER instead of $VPOPUSER.
The above explains the first problem...
Sorry,
Thanks Timo
From: t...@iki.fi
To: jolumape...@hotmail.com
Date: Tue, 20 Oct 2009 16:46:52 -0400
CC: dovecot@dovecot.org
Subject: Re: [Dovecot] Expire plugin per domain
On Tue, 2009-10-20 at 15:43 -0500, Jose Luis Marin Perez wrote:
DOMAIN=`echo $VPOPUSER|sed s/^.*@//`
..
vchkpw
Subject: Re: [Dovecot] Expire plugin in chkpw-wrapper.sh script
From: t...@iki.fi
To: jolumape...@hotmail.com
CC: dovecot@dovecot.org
Date: Thu, 15 Oct 2009 21:21:02 -0400
On Thu, 2009-10-15 at 14:32 -0500, Jose Luis Marin Perez wrote:
I'm trying to extend the configuration of vchkpw
for userdb.
Excuse the dumb question, with that option adding to compile dovecot userdb
checkpassword?
No information found about this.
Thanks
Jose Luis
From: t...@iki.fi
To: jolumape...@hotmail.com
Date: Thu, 15 Oct 2009 21:21:02 -0400
CC: dovecot@dovecot.org
Subject: Re: [Dovecot] Expire
On Fri, 2009-10-16 at 10:37 -0500, Jose Luis Marin Perez wrote:
Hi timo,
This is the error that comes when adding userdb checkpassword
dovecot: Oct 16 10:13:53 Fatal: auth(default): Unknown userdb driver
'checkpassword' (typo, or Dovecot was built without support for it? Check
with
Dear Sirs,
I'm trying to extend the configuration of vchkpw-wrapper.sh script by adding
the expire plugin as follows:
#!/bin/bash
DOMAIN=`echo $VPOPUSER|sed s/^.*@//`
if [ $DOMAIN = operaciones.qnet.com.pe ]; then
export USERDB_AUTOCREATE=INBOX.Spam
export
Stop sending the same mail every few hours.
On Thu, 2009-10-15 at 18:14 -0500, Jose Luis Marin Perez wrote:
Dear Timo,
I'm trying to extend the configuration of vchkpw-wrapper.sh script by adding
the expire plugin as follows:
#!/bin/bash
DOMAIN=`echo $VPOPUSER|sed s/^.*@//`
if
http://hg.dovecot.org/dovecot-1.2/rev/00757d350812 probably helps?
signature.asc
Description: This is a digitally signed message part
On Thu, 2009-10-15 at 14:32 -0500, Jose Luis Marin Perez wrote:
I'm trying to extend the configuration of vchkpw-wrapper.sh script by adding
the expire plugin as follows:
..
/usr/local/sbin/dovecot --exec-mail ext
/usr/local/libexec/dovecot/expire-tool --test
The problem is that
On Oct 4, 2009, at 7:50 PM, Roland Roberts wrote:
I am very confused looking at the expires plugin and its
configuration. What is confusing me the most is that it appears
that I have to configure expiration globally, meaning, for example,
that the Trash mailbox expiration interval is the
I am very confused looking at the expires plugin and its configuration.
What is confusing me the most is that it appears that I have to
configure expiration globally, meaning, for example, that the Trash
mailbox expiration interval is the same regardless of the user. What I
really am looking
Charles Marcus wrote:
On 10/4/2009 7:50 PM, Roland Roberts wrote:
I am very confused looking at the expires plugin and its configuration.
What is confusing me the most is that it appears that I have to
configure expiration globally, meaning, for example, that the Trash
mailbox expiration
On 10/4/2009, Roland Roberts (rol...@astrofoto.org) wrote:
I was hoping to be able to configure a uniform expiration policy,
just like I currently use procmail to file my mail without having to
have a separate config for each client.
What I had said was I don't think (maybe you can) that you
Charles Marcus wrote:
On 10/4/2009, Roland Roberts (rol...@astrofoto.org) wrote:
I was hoping to be able to configure a uniform expiration policy,
just like I currently use procmail to file my mail without having to
have a separate config for each client.
What I had said was I don't
Hate to bump this, but is there nobody who uses the expire plugin and
can confirm my observations?
I'd love to use the expire plugin to delete old messages filed in spam
folders but as it is now I can't get it to work with the wrong mailbox
separators in the table entries.
Andreas
--
Andreas Ntaflos wrote:
Hate to bump this, but is there nobody who uses the expire plugin and
can confirm my observations?
I'd love to use the expire plugin to delete old messages filed in spam
folders but as it is now I can't get it to work with the wrong mailbox
separators in the table
Hi all,
I'm experimenting with the expire plugin and seem have run into a small
problem. I am using Dovecot 1.2.4 on a test server. The config is taken
mostly verbatim from the expire plugin wiki page [1], using MySQL as a
database. See below for detailed output.
Namespace private has /
On Mon, 24 Aug 2009 13:33:15 -0400
Timo Sirainen t...@iki.fi wrote:
On Mon, 2009-08-24 at 13:27 -0400, Timo Sirainen wrote:
CREATE TRIGGER mergeexpire BEFORE INSERT ON expires FOR EACH ROW
BEGIN
UPDATE expires SET expire_stamp=NEW.expire_stamp
WHERE username =
On Fri, 2009-08-21 at 17:02 +0300, Nikita Koshikov wrote:
Search the Wiki about Postgres and the requirement of a TRIGGER.
I guess that sqlite requires something like this.
Maybe someone family with sqlite will say how to make this trigger better and
constrain check field existence before
On Mon, 2009-08-24 at 13:27 -0400, Timo Sirainen wrote:
CREATE TRIGGER mergeexpire BEFORE INSERT ON expires FOR EACH ROW
BEGIN
UPDATE expires SET expire_stamp=NEW.expire_stamp
WHERE username = NEW.username AND mailbox = NEW.mailbox;
SELECT raise(ignore)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Aug 2009, Nikita Koshikov wrote:
How can I solve this ? and why expire plugin is trying to use INSERT, instead
of UPDATE ?
Search the Wiki about Postgres and the requirement of a TRIGGER.
I guess that sqlite requires something like
the Wiki about Postgres and the requirement of a TRIGGER.
I guess that sqlite requires something like this.
Thank for your answer.
I'll dig in this direction.
Unfortunately, there is no UPDATE OR INSERT in SQL and it is hard to
simulate.
You mean in dovecot expire plugin or where ?
Bye
Search the Wiki about Postgres and the requirement of a TRIGGER.
I guess that sqlite requires something like this.
Maybe someone family with sqlite will say how to make this trigger better and
constrain check field existence before doing UPDATE
CREATE TRIGGER mergeexpire BEFORE INSERT ON
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Aug 2009, Nikita Koshikov wrote:
You mean in dovecot expire plugin or where ?
No, in general.
If one wants some data in a DB, but update if already present.
If you re-programm the TRIGGER in the client, you need to lock the whole
No, in general.
If one wants some data in a DB, but update if already present.
If you re-programm the TRIGGER in the client, you need to lock the whole
table, if you want to overcome all race conditions and also don't want any
errors logged (at least with postgres).
Thanks for explanation.
Hello list,
My dovecot setup have expire plugin enabled. It is working fine: new records
added to database(sqlite), expire-tool successfully expunges old mail, but when
expire-tool try to update database record for processed user, I get error in
logs:
r...@mail dovecot 0:0 #
Robert Schetterer schrieb:
Timo Sirainen schrieb:
On Mon, 2009-08-10 at 20:04 +0200, Robert Schetterer wrote:
as far i remember there was root ..
yes of course i am having
variables in namespaces i think i need them for my setup
expire-tool is currently incompatible with variables anywhere.
Robert Schetterer schrieb:
Timo Sirainen schrieb:
On Tue, 2009-08-04 at 10:22 +0200, Robert Schetterer wrote:
Info: maildir:
data=/usr/local/virtual//root/:CONTROL=/usr/local/virtual//root/:INDEX=/usr/local/virtual//root/:INBOX=/usr/local/virtual//root/
Oh, right, this is the problem. You
On Aug 10, 2009, at 11:17 AM, Robert Schetterer wrote:
Info: maildir:
data=/usr/local/virtual//root/:CONTROL=/usr/local/virtual//
root/:INDEX=/usr/local/virtual//root/:INBOX=/usr/local/virtual//
root/
..
setting
mail_location = maildir:~/
does not change anything
mail is still not deleted,
Timo Sirainen schrieb:
On Mon, 2009-08-10 at 20:04 +0200, Robert Schetterer wrote:
as far i remember there was root ..
yes of course i am having
variables in namespaces i think i need them for my setup
expire-tool is currently incompatible with variables anywhere. v2.0
fixes this, but with
On Tue, 2009-08-04 at 10:22 +0200, Robert Schetterer wrote:
Info: maildir:
data=/usr/local/virtual//root/:CONTROL=/usr/local/virtual//root/:INDEX=/usr/local/virtual//root/:INBOX=/usr/local/virtual//root/
Oh, right, this is the problem. You can't use %variables in
mail_location setting. They get
Timo Sirainen schrieb:
On Tue, 2009-08-04 at 10:22 +0200, Robert Schetterer wrote:
Info: maildir:
data=/usr/local/virtual//root/:CONTROL=/usr/local/virtual//root/:INDEX=/usr/local/virtual//root/:INBOX=/usr/local/virtual//root/
Oh, right, this is the problem. You can't use %variables in
Robert Schetterer schrieb:
Timo Sirainen schrieb:
On Aug 3, 2009, at 3:52 AM, Robert Schetterer wrote:
/etc/crontab
45 9 * * * root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
--exec-mail ext /usr/lib/dovecot/expire-tool.sh
Disable this for now and tomorrow just run the --test first
Robert Schetterer schrieb:
Timo Sirainen schrieb:
On Fri, 2009-07-31 at 17:21 +0200, Robert Schetterer wrote:
Hi Timo,
so now its clear, the mail
did not got deleted if i now do
Info: rob...@schetterer.com/Trash: no messages left
So, it worked? no messages left means if you didn't give
Timo Sirainen schrieb:
On Aug 3, 2009, at 3:26 AM, Robert Schetterer wrote:
Timo Sirainen schrieb:
On Fri, 2009-07-31 at 17:21 +0200, Robert Schetterer wrote:
Hi Timo,
so now its clear, the mail
did not got deleted if i now do
Info: rob...@schetterer.com/Trash: no messages left
So, it
On Aug 3, 2009, at 3:52 AM, Robert Schetterer wrote:
/etc/crontab
45 9 * * * root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
--exec-mail ext /usr/lib/dovecot/expire-tool.sh
Disable this for now and tomorrow just run the --test first manually,
save its output, then if it seemed ok
Timo Sirainen schrieb:
On Aug 3, 2009, at 3:52 AM, Robert Schetterer wrote:
/etc/crontab
45 9 * * * root /usr/sbin/dovecot -c /etc/dovecot/dovecot.conf
--exec-mail ext /usr/lib/dovecot/expire-tool.sh
Disable this for now and tomorrow just run the --test first manually,
save its
1 - 100 of 189 matches
Mail list logo