On Mon, 26 May 2014 16:17:14 +0200 Ansgar Wiechers <li...@planetcobalt.net> wrote:
> On 2014-05-26 mancyb...@gmail.com wrote: > > Hi is it possible to log what postfix does to mysql ? > > For example each email sent or received, with sender and receiver, > > date, status, file length. > > And even better, is it possible to integrate that with BL / SA / AV > > in order to have on the same database row also the blacklist check, > > spam score and antivirus info ? > > Postfix logs to syslog and syslog (rsyslog at least) can be configured > to write to MySQL instead of files. See [1] for details. > > [1] http://www.rsyslog.com/doc/rsyslog_mysql.html > > Regards > Ansgar Wiechers > -- > "Abstractions save us time working, but they don't save us time learning." > --Joel Spolsky Hi yes sure but that would result in having 20 database rows for each email, since that is what happens in the syslog, each component (postfix, spamassassin, amavis, policyd, ...) writes few lines in the syslog for each email sent or received. Also, if aggregating, that information must be correlated. Well I guess the answer is no, perhaps qmail does it better ? Thanks for supporting, regards and have a nice day, Mike
