mm:dd
mm:ss
processname-(PID)
rdeliver/ldeliver
destination-MTA
destination-mail-address
(delivery-attempt)
<source-mail-address>
bytes
I've written a bit of PERL but just RegEx for cleaning up OCR texts. I know there is an ODBC module for PERL (but have no idea how solid it is), and you must know about PERL for Windows from www.ActiveState.com.
The core routine would be to race through the log file detecting all lines containing [rdliver|ldeliver] and INSERTing the fields of matching lines into the ODBC table ImailLog. It might be nice to have an option to have different tables for each Imail virtual domain.
Once in there, it's "just" a matter of writing SQL queries to get the reports, which I want to do in CF (rather then Access) so my clients can log on and track on-line their own mail server and mail list activities, esp mail list traffic when renting lists. also, I think there must be way to spit out query results to feed into MRTG for graphic mail traffic display.
I plan to use Lyris for list activities, and I'll have Lyris and DNS setup so that all Lyris traffic gets relayed through Imail, ie, into Imail's logs and the above scheme so as to avoid paying $1000 for Lyris' add-on accounting pkg.
No hurry, I can wait for this until next weekend! LOL
Len
====================
As for the Perl stuff. I've written many perl programs under Linux, but I don't really know perl enough to do a project like this. It sounds interesting though.
