Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I was wondering if there is any way to present all Postfix log in comfortable format for BI (Business Intelligence) team.

BI team works with MySQL, I tried to found how exactly can I push all logs to DB in readable format.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

If you just want readable reports about postfix logs, you can use pflogsum.

If you need to use mysql, you can store a copy of postfix logs in mysql, for example using rsyslog, then set up a web interface to look at them.

share|improve this answer

You might be interested in mysqmail-postfix-logger. From the description this may exactly do as a BI-unit may like to see.

MySQMail is a set of tiny daemon loggers for mail and FTP servers that save traffic information in a MySQL database. The information is split by domain and by user so that it's easy to measure all the traffic for a given domain name in real time.

This package provides a logger for SMTP traffic handled by Postfix.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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