Re: [exim-dev] [Bug 1031] New: Implement database logging of…

Top Page

Reply to this message
Author: Todd Lyons
To: 1031, Axel Rau
CC: exim-dev
Subject: Re: [exim-dev] [Bug 1031] New: Implement database logging of completed remote delivery
On Thu, Oct 14, 2010 at 6:03 AM, Axel Rau <axel.rau@???> wrote:
> This enhancement request proposes a small addition to the exim code base,
> including one new global option and 4 global variables. The option allows to
> define a query with several variables to be expanded/executed at delivery
> completion time. The 4 variables allow access to delivery details and are used
> in the query.

In the example in the patch, you put a SELECT statement, but it seems
like it would be better illustrated by showing a sample INSERT

+An example might look like:
+dbl_delivery_query = \
+${lookup pgsql {SELECT * FROM record_Delivery( \
+    '${quote_pgsql:$sender_address_domain}',\

Because that record doesn't exist yet, right?

For feedback to you personally, I parse logs with a custom script
every two minutes and insert that extracted data into a database, so
this is a much welcome patch for me! Real time info available for
message log searching, that's invaluable!

Regards...      Todd
I seek the is only persistence in self-delusion and
ignorance that does harm.  -- Marcus Aurealius