Create custom logs, instruct postfix to log to your custom logs by giving it the correct new path (instead of the default syslog), then copy-paste the original mysql tables into your custom created logs then add as many custom rows, sql commands as you please or just create totally brand-new databases and tables and there you go, you may log absolutely anything you please, even the current temperature on Mars if that’s your preference. Syslog can also just write to mysql directly, simply add / extend the original with your custom rows. I do custom logging for Dovecot but just in plain text files (not in mysql) for simplicity.
Regards, Dennis. From: Robert Schetterer Sent: Monday, May 26, 2014 17:14 To: postfix-users@postfix.org Subject: Re: improving logging Am 26.05.2014 15:53, schrieb mancyb...@gmail.com: > Hi is it possible to log what postfix does to mysql ? postfix logs to syslog , syslog may log to sql http://www.rsyslog.com/doc/rsyslog_mysql.html http://loganalyzer.adiscon.com/ more advanced http://graylog2.org/ > 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 ? > > Thanks for your attention, > 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
