Re: Looking to gather statistics on email received and sent

"Rowney, Dion via Exim-users" <[email protected]>
Newsgroups gmane.mail.exim.user
Message-ID <YQXPR01MB40389E81B889A173325BC83E9366A@YQXPR01MB4038.CANPRD01.PROD.OUTLOOK.COM>
Thanks,

Tried configuring a basic event link the documentation "Events" section and it did do anything and didn't appear like it was trying.  Tried both simulation using exim -d+all  -f [email protected] -bt [email protected] and actually sending emaili to it.

I fear it isn't compiled into the RHEL9 exim version by default.  Is there an easy way to query exim to see if it is enabled?  similar to looking for enabled builtin plugins...

It appears I should use the configuration option "event_action" in the transport section but no logging feedback or error was indicated.  (it does error on startup when not in the right section)

I did modify the SQL statement as I thought it may have been wrong and used a select instead of an insert?:

event_action = ${if eq {msg:delivery}{$event_name} \
  {${lookup pgsql {INSERT INTO exim.logtest ( \
    '${quote_pgsql:$sender_address_domain}',\
    '${quote_pgsql:${lc:$sender_address_local_part}}', \
    '${quote_pgsql:$domain}', \
    '${quote_pgsql:${lc:$local_part}}', \
    '${quote_pgsql:$host_address}', \
    '${quote_pgsql:${lc:$host}}', \
    '${quote_pgsql:$message_exim_id}')}} \
} {}}

Am I doing this correctly or misunderstanding how this is to work?

Dion

-----Original Message-----
From: Jeremy Harris via Exim-users <[email protected]>
Sent: Thursday, May 29, 2025 10:27 AM
To: [email protected]
Subject: [exim] Re: Looking to gather statistics on email received and sent

CAUTION: External to USask. Verify sender and use caution with links and attachments. Forward suspicious emails to [email protected]


On 2025/05/29 5:08 PM, Rowney, Dion via Exim-users wrote:
> Ps, you don't need to design, only nudge.

"Events".

--
Cheers,
   Jeremy

--
## subscription configuration (requires account):
##   https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
##   [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

-- 
## subscription configuration (requires account):
##   https://lists.exim.org/mailman3/postorius/lists/exim-users.lists.exim.org/
## unsubscribe (doesn't require an account):
##   [email protected]
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.