A NOTE has been added to this issue.
======================================================================
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: feedback
target:
======================================================================
Date Submitted: 16-Feb-07 16:48 CET
Last Modified: 02-Sep-07 08:46 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.
....
>>>
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
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
