I have a CentOS 5.5 64 bit mail server using Postfix as the MTA.

I want to create a database of content and the time of mails sent and received from this mail server. Can anyone tell me how to do this?

closed as off-topic by womble Aug 21 '16 at 1:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

  • Do you mean the mail logs or the content of the emails? – Ladadadada Mar 14 '12 at 12:03
  • i meant the content of the emails plus the time of mail sent and received. – achal tomar Mar 14 '12 at 17:50

Your question lacks detail, and thus my answer will be vague, too. I hope these hints can nudge you to right direction.

One way would be to use syslog-ng as your syslog-daemon and configure it in a way it pipes the mail logs to your own script, which then parses the results and inserts them to database. I've written couple of scripts like this in Perl.

Another way would be to use one of the log summarizers available:

  • ok i will try this and update you. – achal tomar Mar 14 '12 at 17:45

Not the answer you're looking for? Browse other questions tagged or ask your own question.