Re: improving logging

2014-05-26 Thread Robert Schetterer
Am 26.05.2014 17:03, schrieb mancyb...@gmail.com: > On Mon, 26 May 2014 16:43:45 +0200 > "li...@rhsoft.net" wrote: > >> >> Am 26.05.2014 16:31, schrieb mancyb...@gmail.com: >>> Hi yes sure but that would result in having 20 database rows for each >>> email, since that is what happens in the sysl

Re: improving logging

2014-05-26 Thread mancyb...@gmail.com
On Mon, 26 May 2014 16:43:45 +0200 "li...@rhsoft.net" wrote: > > Am 26.05.2014 16:31, schrieb mancyb...@gmail.com: > > 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, po

Re: improving logging

2014-05-26 Thread Robert Schetterer
Am 26.05.2014 16:31, schrieb mancyb...@gmail.com: > On Mon, 26 May 2014 16:17:14 +0200 > Ansgar Wiechers 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,

Re: improving logging

2014-05-26 Thread li...@rhsoft.net
Am 26.05.2014 16:31, schrieb mancyb...@gmail.com: > 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 rece

Re: improving logging

2014-05-26 Thread Klaipedaville on Google
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 ? post

Re: improving logging

2014-05-26 Thread mancyb...@gmail.com
On Mon, 26 May 2014 16:17:14 +0200 Ansgar Wiechers 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

Re: improving logging

2014-05-26 Thread Robert Schetterer
Am 26.05.2014 16:14, schrieb Robert Schetterer: > 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/ > >

Re: improving logging

2014-05-26 Thread Ansgar Wiechers
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 dat

Re: improving logging

2014-05-26 Thread Robert Schetterer
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 se

improving logging

2014-05-26 Thread mancyb...@gmail.com
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 an