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 <exim-users@lists.exim.org>
Sent: Thursday, May 29, 2025 3:17 PM
To: Jeremy Harris <j...@wizmail.org>; exim-users@lists.exim.org
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 some...@test.domain.ca -bt mail-t...@test.domain.ca 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 <exim-users@lists.exim.org>
Sent: Thursday, May 29, 2025 10:27 AM
To: exim-users@lists.exim.org
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 phish...@usask.ca
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):
## exim-users-unsubscr...@lists.exim.org
## 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):
## exim-users-unsubscr...@lists.exim.org
## 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):
## exim-users-unsubscr...@lists.exim.org
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
