[exim-dev] [Bug 1031] Implement database logging of complete…

Top Page
Delete this message
Reply to this message
Author: Todd Lyons
Date:  
To: exim-dev
Subject: [exim-dev] [Bug 1031] Implement database logging of completed remote delivery
------- You are receiving this mail because: -------
You are on the CC list for the bug.

http://bugs.exim.org/show_bug.cgi?id=1031




--- Comment #1 from Todd Lyons <tlyons@???> 2010-10-15 16:41:45 ---
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
instead:

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


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!


--
Configure bugmail: http://bugs.exim.org/userprefs.cgi?tab=email