I used something like that and I can confirm it worked well (lines broken so
don't forget to put \ here and there)
# updating traffic data, condition is always false
warn
# domains = ! +local_domains
authenticated = *
condition =
${lookup mysql {
INSERT INTO traffic (username,domain,day,sent)
values('${quote_mysql:${local_part:$authenticated_id}}','${quote_mysql:
${domain:$authenticated_id}}',date(now()),$message_size)
ON DUPLICATE KEY UPDATE sent=sent+$message_size
}{$value}fail}
log_message = DEBUG traffic registered from
$authenticated_id/$authenticated_sender ($sender_address): $message_size
bytes
accept
--
Marcin Gryszkalis, PGP 0x9F183FA3
jabber jid:m...@fork.pl, gg:2532994
http://the.fork.pl
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
