Postfix mail.log to database

[stikekar]

I am wondering if anybody can help me implement my postfix logs in a database. We need to have the ability to run reports on sent, delivered, bounced (soft and hard), deferred and rejects by domain and senders. I have looked all over the web but have not come across something that will work.

[5050]

This is not a support question, but a custom development request.
Unhappily, I cannot help on it... because I have no idea about how to implement it, so i'm at same state than you : require to learn ! And I am not sure that someone in the team already did it.
I'll move it in public forum, it may get more ansvers.

[TGates]

This could be done in 2 ways. Create the report directly from the log file (probably slow and may not be 100% due to log-rotate) or make a script to parse the log (on daemon run?) and dump it into a database which can later be read by another script that will sort the data according to your needs. The difficult part is how to put the data descriptions in the database so they can be sorted. Unfortunately I do not have the time to work on something like this at this time.
I'll try and do a search also to see if anything is out there already.

---

After a quick search There seems to be a few things out there. [google]php script to parse postfix logs[/google]