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
-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
[...]
p
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 Select,Inser
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?
Dumb question: do I need to have a database to run the expire plugin?
t.org
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
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,
and it would work with or wit
n is enabled?
Or should I still fix it to get it works properly?
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]
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, and it
would work with or without the expire plugin.
The thing is that if the expire plugin is enabled, the "doveadm
; ?
Thanks a lot!
> Date: Fri, 23 Aug 2013 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 =
> 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 is for 1.2.
> Please follow documentation at http://wiki2.dovecot.org/Plugins/Expire
>
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'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 = m
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 exp
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
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 se
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 m
On Tue, 2011-10-25 at 00:25 +0200, Stephan Bosch wrote:
> 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 see
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 e
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 :(
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
disable_plaint
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
disable_plaint
On Thu, 10 Feb 2011 02:07:38 +0200, Timo Sirainen 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 didn
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 y
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 move
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
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,
I forgot to mention the dovecot version number. It is version 2.0.7.
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)
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
log_timestamp
On Tue, 2010-08-03 at 10:59 +0200, Arnaud2 bali wrote:
> expire: .Trash 1 .Trash/* 1 .Spam 2
Remove '.' before the mailbox names.
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 "s
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".
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 password=
2010/6/22 Timo Sirainen :
>> 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
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 --versi
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: /usr/lo
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 ca
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 a
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.
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 m
-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?
Regards
Hi,
I'm testing out the dovecot expire plugin, and not seeing anything go into
the database I've got set up. It's a mysql db. I've gone in and verified
that the db is set up correctly. The socket is set up so that deliver
should be able to talk to the db, but I'm n
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 n
-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.
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 ti
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
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 ign
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
On Mon, 23 Nov 2009 12:01:53 -0500
Timo Sirainen wrote:
> On Mon, 2009-11-23 at 18:01 +0200, Nikita Koshikov wrote:
> > On Fri, 06 Nov 2009 18:42:49 -0500
> > Timo Sirainen wrote:
> >
> > > On Fri, 2009-11-06 at 10:27 +0200, Nikita Koshikov wrote:
> > > > I don't understand why gdb says "no deb
On Mon, 2009-11-23 at 18:01 +0200, Nikita Koshikov wrote:
> On Fri, 06 Nov 2009 18:42:49 -0500
> Timo Sirainen 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 binari
On Fri, 06 Nov 2009 18:42:49 -0500
Timo Sirainen 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) b
On Thu, 05 Nov 2009 12:52:08 -0500
Timo Sirainen 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, since I
>
> 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 Fri, 30 Oct 2009 13:16:47 -0400
Timo Sirainen 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 does,
On Fri, 30 Oct 2009 13:16:47 -0400
Timo Sirainen 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 does,
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 a
On Thu, 29 Oct 2009 13:10:37 -0400
Timo Sirainen 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.
For u
On Thu, 29 Oct 2009 13:10:37 -0400
Timo Sirainen 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 fine with
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: home=/data/mail/domain.c
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 = Trash:storage=1
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:
> > D
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...
ds: uid box msgid size
dict:
expire: mysql:/usr/local/etc/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
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,
>
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 [ "$DO
> 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 tryin
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
> wi
gt; Subject: Re: [Dovecot] Expire plugin in chkpw-wrapper.sh script
>
> 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/l
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 vchkpw-
http://hg.dovecot.org/dovecot-1.2/rev/00757d350812 probably helps?
signature.asc
Description: This is a digitally signed message part
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/^.*@//`
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 [ "$DOMAIN" = "operaciones.qnet.com.pe" ]; then
export USERDB_AUTOCREATE=INBOX.Spam
export USERDB_AUTOSUBSCRIBE=IN
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 USERDB_AUTOSUBSCRIBE=IN
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 s
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 th
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 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 int
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 interval is the same re
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
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 entri
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
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 "/" c
On Mon, 24 Aug 2009 13:33:15 -0400
Timo Sirainen 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 = NEW.user
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)
>
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
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 explana
-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
> 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 exp
>
> Search 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
-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 thi
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 # /usr/sbin/dovecot
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 variabl
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,
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 v1.x you can't use them.
Timo Sirainen schrieb:
> On Mon, 2009-08-10 at 19:49 +0200, Robert Schetterer wrote:
>> Timo Sirainen schrieb:
>>> 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//roo
On Mon, 2009-08-10 at 19:49 +0200, Robert Schetterer wrote:
> Timo Sirainen schrieb:
> > 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/virtu
Timo Sirainen schrieb:
> 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
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, l
1 - 100 of 211 matches
Mail list logo
