Nvrmnd. Dba problem and a me problem.
Btw, insert into tablename VALUES (...) is the correct SQL statement for the docs. Many regards, Dion -----Original Message----- From: Rowney, Dion via Exim-users <[email protected]> Sent: Thursday, May 29, 2025 3:17 PM To: Jeremy Harris <[email protected]>; [email protected] Subject: [exim] Re: Looking to gather statistics on email received and sent 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/ -- ## 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/
