From: martin f. krafft Date: Tue, 4 Mar 2008 18:32:32 +0000 (+0100) Subject: no longer record delays in sqlite database X-Git-Url: https://git.madduck.net/etc/mailfilter.git/commitdiff_plain/d855421675244ca1154a6d5668bb2e41940cd7b9?ds=inline no longer record delays in sqlite database --- diff --git a/procmail/delay-delivery b/procmail/delay-delivery index 9e8e02a..aef22e1 100644 --- a/procmail/delay-delivery +++ b/procmail/delay-delivery @@ -42,7 +42,6 @@ :0 fw |$FORMAIL -I"X-Postponed: $RELEASE" - INCLUDERC=$PMDIR/record-delayed-mail :0 $DELAYED_QUEUE } diff --git a/procmail/record-delayed-mail b/procmail/record-delayed-mail deleted file mode 100644 index c8256e1..0000000 --- a/procmail/record-delayed-mail +++ /dev/null @@ -1,18 +0,0 @@ -# create table messages (msgid text unique not null, filename text -# primary key not null unique, release_ts integer not null); - -DELAYED_QUEUE_DB=$PMVAR/delayed-queue.sqlite - -DO_QUERY="$SQLITE $DELAYED_QUEUE_DB" - -DATA="$MSGID" -INCLUDERC=$PMDIR/sql-escape - -QUERY="insert into messages values ($DATA, '\$DESTFILE', $RELEASE_TS);" -TRAP="$TRAP; OUT=\"$(echo \"$QUERY\" | $DO_QUERY 2>&1)\"; - [ -n \"\$OUT\" ] && echo \"delay: failed register delayed mail in database: \$OUT\"" - -QUERY -DATA -DO_QUERY -DELAYED_QUEUE_DB