Exim database logging with exim 4.82

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Exim database logging with exim 4.82

Andreas Pflug
The page https://www.baruwa.org/docs/2.0/mta/exim.html explains how to
let exim log deliveries to the database, however the options mentioned
there are outdated.
I recompiled exim 4.82 from source with the EXPERIMENTAL_TPDA=yes and
changed the exim.conf as follows:

hide pgsql_servers = baruwa-db-server/baruwa-db/baruwa-user/baruwa-password

DELIVERY_ACTION = ${lookup pgsql \
        {INSERT INTO messagestatus (messageid, hostname, ipaddress,
port, confirmation) \
    VALUES('${quote_pgsql:$message_exim_id}',
'${quote_pgsql:$tpda_delivery_fqdn}', \
        '${quote_pgsql:$tpda_delivery_ip}', \
    ${quote_pgsql:$tpda_delivery_port},
'${quote_pgsql:$tpda_delivery_confirmation}')}}
DEFER_ACTION = ${lookup pgsql {INSERT INTO messagestatus (messageid,
hostname, ipaddress,\
        port, confirmation, errorno, errorstr) \
        VALUES('${quote_pgsql:$message_exim_id}',
'${quote_pgsql:$tpda_delivery_fqdn}',\
         '${quote_pgsql:$tpda_delivery_ip}',
${quote_pgsql:$tpda_delivery_port},\
         '${quote_pgsql:$tpda_delivery_confirmation}',
${quote_pgsql:$tpda_defer_errno}, \
        '${quote_pgsql:$tpda_defer_errstr}')}}

remote_smtp:
  driver = smtp
  tpda_delivery_action = DELIVERY_ACTION
  tpda_host_defer_action = DEFER_ACTION

Regards
Andreas


_______________________________________________
http://pledgie.com/campaigns/12056
Reply | Threaded
Open this post in threaded view
|

Re: Exim database logging with exim 4.82

Andrew Colin Kissa
Administrator

On 15 Jan 2014, at 1:47 PM, Andreas Pflug <[hidden email]> wrote:

> The page https://www.baruwa.org/docs/2.0/mta/exim.html explains how to
> let exim log deliveries to the database, however the options mentioned
> there are outdated.
> I recompiled exim 4.82 from source with the EXPERIMENTAL_TPDA=yes and
> changed the exim.conf as follows:
>
> hide pgsql_servers = baruwa-db-server/baruwa-db/baruwa-user/baruwa-password
>
> DELIVERY_ACTION = ${lookup pgsql \
>        {INSERT INTO messagestatus (messageid, hostname, ipaddress,
> port, confirmation) \
>    VALUES('${quote_pgsql:$message_exim_id}',
> '${quote_pgsql:$tpda_delivery_fqdn}', \
>        '${quote_pgsql:$tpda_delivery_ip}', \
>    ${quote_pgsql:$tpda_delivery_port},
> '${quote_pgsql:$tpda_delivery_confirmation}')}}
> DEFER_ACTION = ${lookup pgsql {INSERT INTO messagestatus (messageid,
> hostname, ipaddress,\
>        port, confirmation, errorno, errorstr) \
>        VALUES('${quote_pgsql:$message_exim_id}',
> '${quote_pgsql:$tpda_delivery_fqdn}',\
>         '${quote_pgsql:$tpda_delivery_ip}',
> ${quote_pgsql:$tpda_delivery_port},\
>         '${quote_pgsql:$tpda_delivery_confirmation}',
> ${quote_pgsql:$tpda_defer_errno}, \
>        '${quote_pgsql:$tpda_defer_errstr}')}}
>
> remote_smtp:
>  driver = smtp
>  tpda_delivery_action = DELIVERY_ACTION
>  tpda_host_defer_action = DEFER_ACTION
Update the documentation and send a pull request


_______________________________________________
http://pledgie.com/campaigns/12056

signature.asc (858 bytes) Download Attachment
--
Baruwa - www.baruwa.org
Reply | Threaded
Open this post in threaded view
|

Re: Exim database logging with exim 4.82

jvangent
This post has NOT been accepted by the mailing list yet.
In reply to this post by Andreas Pflug
Thanks for this, working perfectly on Exim 4.82.