On Feb 11, 2008, at 9:15 AM, Martin A. Brooks wrote: > Can exim be persuaded to log directly to a SQL database?
The exim-centered email solution we've built logs pretty much everything to a sql database, which is then accessible through the web admin. the biggies in our logging tables: ip_log: ip, cnxn_first, cnxn_last, last_reverse, first_helo, last_helo, last_dnsbl_time, last_dnsbl ip_stats: ip, cnxn_count, reverse_ok_count, helo_ok_count, quit_count, bad_from_count, bad_rcpt_count, unk_rcpt_count, ok_rcpt_count, tls_used_count, dnsbl_block_count, msg_count, malware_count, spamscore_total, msg_bytes block_log: rec_id, when_blocked, ip, helo, sender, recip_id, recipients, site_id, subject, msgsize, reason, block_desc cnxn_log: ip, port, cnxn_when, recv_port, authd_userid, msgs_attempted, msgs_accepted, data_xferd, close_reason, close_when recent_mail: rec_id, recvd, ip, sender, recipients, recip_id, site_id, subject, msgsize, msgid, spamscore sent_mail: rec_id, sent, ip, sender, sender_id, sender_siteid, recipients, subject, msgsize, msgid There are times I do have to ssh into the server and tail the exim log, but it is rare. -- ## 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/
