The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=508
======================================================================
Reported By: Anne
Assigned To: aaron
======================================================================
Project: DBMail
Issue ID: 508
Category: Sieve (delivery, dbmail-sievecmd, dbmail-timsieved)
Reproducibility: always
Severity: minor
Priority: normal
Status: resolved
target:
Resolution: no change required
Fixed in Version:
======================================================================
Date Submitted: 16-Feb-07 16:48 CET
Last Modified: 27-Sep-07 22:45 CEST
======================================================================
Summary: vacation sieve script always sends reply instead of
just once
Description:
Starting version 2.2.2 the vacation sieve script always sends a reply even
when the recipient has already been cached in dbmail_replycache.
======================================================================
----------------------------------------------------------------------
Tarick - 19-Mar-07 15:44
----------------------------------------------------------------------
I confirm, 2.2.4 still has this problem. From dbmail.err:
Debug:[sql] dbpgsql.c,db_query(+281): [SELECT lastseen FROM
dbmail_replycache WHERE to_addr = '[EMAIL PROTECTED]' AND f
rom_addr = '[EMAIL PROTECTED]' AND handle = '4257e0eca3659acfbf3cf8f3c964289c'
AND lastseen > (NOW() - INTERVAL '1 DAY')]
Debug:[delivery] pipe.c,parse_and_escape(+54): parsing address
[EMAIL PROTECTED]
Debug:[delivery] pipe.c,parse_and_escape(+54): parsing address
[EMAIL PROTECTED]
Info:[delivery] pipe.c,send_mail(+144): opening pipe to
[/usr/sbin/sendmail -f [EMAIL PROTECTED] [EMAIL PROTECTED]
Debug:[delivery] pipe.c,send_mail(+152): pipe opened
Debug:[delivery] pipe.c,send_mail(+173): pipe closed
Info:[delivery] pipe.c,send_mail(+178): sendmail exited normally
Debug:[sql] dbpgsql.c,db_query(+281): [SELECT lastseen FROM
dbmail_replycache WHERE to_addr = '[EMAIL PROTECTED]' AND f
rom_addr = '[EMAIL PROTECTED]' AND handle =
'4257e0eca3659acfbf3cf8f3c964289c' ]
Debug:[sql] dbpgsql.c,db_query(+281): [INSERT INTO dbmail_replycache
(to_addr, from_addr, handle, lastseen) VALUES
('[EMAIL PROTECTED]','[EMAIL PROTECTED]','4257e0eca3659acfbf3cf8f3c964289c',
CURRENT_TIMESTAMP)]
Info:[sort] sortsieve.c,sort_vacation(+145): Sending vacation to
[EMAIL PROTECTED] from [EMAIL PROTECTED] handle [425
7e0eca3659acfbf3cf8f3c964289c] repeat days [1]
----------------------------------------------------------------------
Tarick - 19-Mar-07 17:30
----------------------------------------------------------------------
I switched to 2.2.1, succesfully sent bunch of messages and had one
autoreply. But when I changed subject of message, handle changed also and
I've got another autoreply. I don't think this is intentional behaviour.
----------------------------------------------------------------------
aaron - 21-Mar-07 09:07
----------------------------------------------------------------------
So 2.2.2 has a bug in autoreplies that 2.2.1 did not have? This will narrow
down the set of changes that I have to look back at.
----------------------------------------------------------------------
aaron - 26-Apr-07 01:30
----------------------------------------------------------------------
Fixed in SVN. The bug was that a call to db_result_free() was added above
db_num_rows() in db_replycache_validate(), so we always thought we'd seen
0 rows of recent replies/vacations.
----------------------------------------------------------------------
Anne - 15-Aug-07 09:54
----------------------------------------------------------------------
Still (or again) the same problem with 2.2.6rc1
Note: in dbmail_replycache, a new record is added each time with a
different value for "handle"
----------------------------------------------------------------------
paul - 26-Aug-07 15:51
----------------------------------------------------------------------
Anne, I can't reproduce this. Please provide more details if you don't
mind.
----------------------------------------------------------------------
Anne - 30-Aug-07 16:35
----------------------------------------------------------------------
Meanwhile I discovered that an auto reply is only sent multiple times if
the subject is different than before.
IMHO that's a bug not a feature ;-)
----------------------------------------------------------------------
paul - 31-Aug-07 08:51
----------------------------------------------------------------------
What subject? The subject in the reply message? Or the subject in the
received message?
In the first case: it's a feature
In the latter case: it is a bug: but this condition is what I've checked
for specifically (works for me).
----------------------------------------------------------------------
Anne - 02-Sep-07 07:35
----------------------------------------------------------------------
It's the subject in the received message.
I'm using Avelsieve (Squirrelmail).
----------------------------------------------------------------------
Tarick - 02-Sep-07 08:46
----------------------------------------------------------------------
Anne, I guess this is a feature.
See http://www.dbmail.org/mantis/view.php?id=608 and
http://tools.ietf.org/html/draft-ietf-sieve-vacation-03#section-4 .
>>>
Tracking is not just per address, but must also take the vacation response
itself into account. ...
A particular vacation response can be identified in one of two ways.
The first way is via an explicit :handle argument, which attaches a
name to the response. All vacation statements that use the same
handle will be considered to be the same response for tracking
purposes.
The second way is via a synthesis of the :subject, :from, :mime, and
reason vacation command arguments. All vacation actions that do not
contain an explicit handle and which use an identical combination of
these arguments are considered to be the same for tracking purposes.
....
>>>
----------------------------------------------------------------------
paul - 03-Sep-07 20:44
----------------------------------------------------------------------
Anne, please add the loglines to document the problematic behaviour, just
like Tarick did in the first note. I'm still not convinced this issue is a
bug.
----------------------------------------------------------------------
Anne - 11-Sep-07 16:17
----------------------------------------------------------------------
"Tracking is not just per address, but must also take the vacation response
itself into account. ..."
That's right but it's mainly important if you have a script like below
which has multiple responders inside.
require "vacation";
if header :contains "subject" "cyrus" {
vacation "I'm out -- send mail to cyrus-bugs";
} else {
vacation "I'm out -- call me at 304 555 1212";
}
I have a simple script which contains just one vacation line (at least I
assume it does, it's generated by Avelsieve...)
If I send a message which has a different subject than before, I receive a
new response.
But.....I meanwhile did a test by using a dbmail-sievecmd generated
script. Guess what, then it works just fine. So there's only a problem
when the script is generated by Avelsieve.
----------------------------------------------------------------------
paul - 27-Sep-07 22:45
----------------------------------------------------------------------
I'm closing this since it was not a dbmail bug.
Of course it would be nice if someone fixed avelsieve, but other than that
there's nothing more we can do here.
Issue History
Date Modified Username Field Change
======================================================================
16-Feb-07 16:48 Anne New Issue
19-Mar-07 15:44 Tarick Note Added: 0001925
19-Mar-07 17:30 Tarick Note Added: 0001926
21-Mar-07 09:07 aaron Note Added: 0001932
26-Apr-07 01:28 aaron Status new => assigned
26-Apr-07 01:28 aaron Assigned To => aaron
26-Apr-07 01:30 aaron Status assigned => resolved
26-Apr-07 01:30 aaron Fixed in Version => 2.2.5
26-Apr-07 01:30 aaron Resolution open => fixed
26-Apr-07 01:30 aaron Note Added: 0002098
15-Aug-07 09:53 Anne Status resolved => feedback
15-Aug-07 09:53 Anne Resolution fixed => reopened
15-Aug-07 09:53 Anne Note Added: 0002326
15-Aug-07 09:54 Anne Note Edited: 0002326
26-Aug-07 15:51 paul Note Added: 0002332
26-Aug-07 15:51 paul Resolution reopened => unable to
reproduce
30-Aug-07 16:33 Anne Note Added: 0002340
30-Aug-07 16:35 Anne Note Edited: 0002340
31-Aug-07 08:51 paul Note Added: 0002341
02-Sep-07 07:35 Anne Note Added: 0002349
02-Sep-07 08:46 Tarick Note Added: 0002350
03-Sep-07 20:44 paul Note Added: 0002353
11-Sep-07 16:12 Anne Note Added: 0002363
11-Sep-07 16:17 Anne Note Edited: 0002363
27-Sep-07 22:45 paul Note Added: 0002383
27-Sep-07 22:45 paul Status feedback => resolved
27-Sep-07 22:45 paul Resolution unable to reproduce =>
no change required
27-Sep-07 22:45 paul Fixed in Version 2.2.5 =>
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
