Am 26.05.2014 16:31, schrieb mancyb...@gmail.com: > 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.
i followed some presentation for graylog2 a few weeks ago with big logs prefilter ist your friend, after all it depends in how deep you want to go in logging and analyse with smaller setups logcheck, pflogsumm and manual grep log files etc is mostly enough > > Well I guess the answer is no, perhaps qmail does it better ? no idea, i quit with qmail years ago > > > Thanks for supporting, > regards and have a nice day, > Mike > Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein
