For work, I am writing a program to archive iMail log files to a MySQL database. My needs are fairly simple:
- periodically archive / restart the iMail LOGxxxx file. - display some daily activity totals up to the last archive; msgs in, msgs out, POP logins, IMAP logins, msgs dropped via the kill list, etc.
The database contains fields to help me get reports of interest:
TheDate, ' date & time of the entry in the file
TheTime
RawData ' entire original entry
Function ' SMTP, SMTPD, IMAP, POP, etc
ProcID ' process id assigned to the handler for a given task
' makes it easier to see just the entries for a
given event
RDeliver ' Y = was an rdeliver operation
LDeliver ' Y = was an ldeliver operation
FromAddr ' self explainitory
ToAddr
FromDomain ' a setting will control the 'depth' of recorded domain names
ToDomain ' i.e. depth of 2 means 'bulk.mail.yahoo.com '
' is recorded as 'yahoo.com'
TheSize
Login ' POP, IMAP, SMTP (SMTP authorization)
Logout ' POP, IMAP
I've already decided that when it's done, I'll release it for public use as well. I wanted to float this message to see if anyone had any ideas for other things it should do. I'm not promising anything, but I'm still interested to hear. Please don't ask for it to include web mail logs or declude logs. Maybe someday, but not this iteration.
-- ---------------------------------------------------------------- Bud Durland, CNE [EMAIL PROTECTED] fax: 518-561-0017 ---------------------------------------------------------------- For sale: Parachute. Like new, used once. Small stain. ----------------------------------------------------------------
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
