Re: Postfix 2.8.x and how to log "summary" into a mysql

[Josef Karliak]

Great, thanks. I'm logging, its easy. I must find variable for inserting "sender" email address into a mysql, hosts, time and recipient is done by your tip. Or anybody knows ?

  Thanks a lot!
  J.K.

Cituji Robert Schetterer <rob...@schetterer.org>:

Am 05.09.2012 10:57, schrieb Reindl Harald:

Am 05.09.2012 10:50, schrieb Josef Karliak:

  Good morning,

on a one line ?

did anybody solved recording sender,recipient and date into a mysql ? Normally postfix log it into a maillog, I want it into a database record "sender recipient date". Or it is able to change postfix's logging, where is summary

postfix is logging to syslog-daemon

rsyslog supports mysql as target
however "sender recipient date" is impossible

perhaps its possible with prefilter logging rsyslog mysql with template

but it might not be trivial

look ( sorry german )

http://lab4.org/wiki/Mailbounces_monitoren_mit_rsyslog_und_mysql

for ideas

--
Best Regards
MfG Robert Schetterer




The message was checked by ESET Mail Security.
http://www.eset.com

__________ Information from ESET Mail Security, version of virus signature database 7447 (20120905) __________

--
Ma domena pouziva zabezpeceni a kontrolu SPF (www.openspf.org) a
DomainKeys/DKIM (with ADSP) . Pokud mate problemy s dorucenim emailu,
zacnete pouzivat metody overeni puvody emailu zminene vyse. Dekuji.
My domain use SPF (www.openspf.org) and DomainKeys/DKIM (with ADSP)
policy and check. If you've problem with sending emails to me, start
using email origin methods mentioned above. Thank you.

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.




__________ Information from ESET Mail Security, version of virus signature 
database 7447 (20120905) __________

The message was checked by ESET Mail Security.
http://www.eset.com

bin8990B3KFXP.bin
Description: Veřejný PGP klíč