The following issue has been REOPENED.
======================================================================
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: 15-Aug-07 09:53 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:53
----------------------------------------------------------------------
Still (or again) the same problem with 2.2.6rc1
In dbmail_replycache, a new record is added each time with a different
value for "handle"
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
======================================================================
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
