From d855421675244ca1154a6d5668bb2e41940cd7b9 Mon Sep 17 00:00:00 2001 From: "martin f. krafft" Date: Tue, 4 Mar 2008 19:32:32 +0100 Subject: [PATCH] no longer record delays in sqlite database --- procmail/delay-delivery | 1 - procmail/record-delayed-mail | 18 ------------------ 2 files changed, 19 deletions(-) delete mode 100644 procmail/record-delayed-mail 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 -- 2.39.5