Re: [exim] Log parsing to relational database

Top Page
Delete this message
Reply to this message
Author: Todd Lyons
Date:  
To: exim-users
Subject: Re: [exim] Log parsing to relational database
On Thu, Sep 6, 2012 at 11:54 PM, Ted Cooper <eximX0902w@???> wrote:
>>> Has anyone written anything to convert exim logs into a series of
>>> related SQL tables? I am doing an inordinate amount of searching through
>>> log files to find it A emailed B on a certain day and having spent so
>>> much time with databases over the last few years I can't help but want
>>> to make an interface for people to search for this information themselves ;)
>> The only one I ran across at one time. It doesn't look like it has had
>> much activity in recent years. It probably wouldn't take much to bring
>> up to date.
>> http://oss.netshadow.at/projects/show/exilog
> The log file format hasn't changed in a long time so I wouldn't take the
> lack of changes as a bad sign. It looks a little more complete than I
> was thinking, as I want to add this functionality to an existing
> website. Certainly a good looking implementation!


Here is what I wrote and have been using:

https://github.com/mrballcb/exisqlog

I spent the morning sanitizing our company specific things out of it
and pushed it up to github. Let me know if it does not work properly
for you.

...Todd
--
The total budget at all receivers for solving senders' problems is $0.
If you want them to accept your mail and manage it the way you want,
send it the way the spec says to. --John Levine