Re: Realtime log reporting when postfix delivers mails

2013-03-19 Thread Florian Schaal
Am 16.03.2013 22:11, schrieb Reinaldo Gil Lima de Carvalho: > We need a structured log to avoid parsing. I talk with Wietse in the year > 2011 at FISL conference (Porto Alegre/Brasil). > > The second problem is load this data to a database. Rsyslog put the data in a > single column, and use full

Re: Realtime log reporting when postfix delivers mails

2013-03-16 Thread Reinaldo Gil Lima de Carvalho
We need a structured log to avoid parsing. I talk with Wietse in the year 2011 at FISL conference (Porto Alegre/Brasil). The second problem is load this data to a database. Rsyslog put the data in a single column, and use full text search is inevitable. While don't have a better solution, I wro

Re: Realtime log reporting when postfix delivers mails

2013-03-16 Thread Abhijeet Rastogi
Have a look into logstash project. I have just started using it for mail logs and it's awesome. On Fri, Mar 15, 2013 at 12:29 PM, Ram wrote: > I have a postfix server sending out mails and we are creating reports by > parsing the maillogs using a couple of perl cron scripts > (linux machine with

Re: Realtime log reporting when postfix delivers mails

2013-03-15 Thread Robert Schetterer
Am 15.03.2013 07:59, schrieb Ram: > I have a postfix server sending out mails and we are creating reports by > parsing the maillogs using a couple of perl cron scripts > (linux machine with mysql ) > > Now the requirement is of realtime reporting. > I tried using rsyslog with a mysql table. But th

Re: Realtime log reporting when postfix delivers mails

2013-03-15 Thread Stan Hoeppner
On 3/15/2013 1:59 AM, Ram wrote: > I have a postfix server sending out mails and we are creating reports by > parsing the maillogs using a couple of perl cron scripts > (linux machine with mysql ) > > Now the requirement is of realtime reporting. > > I tried using rsyslog with a mysql table. But t

Realtime log reporting when postfix delivers mails

2013-03-15 Thread Ram
I have a postfix server sending out mails and we are creating reports by parsing the maillogs using a couple of perl cron scripts (linux machine with mysql ) Now the requirement is of realtime reporting. I tried using rsyslog with a mysql table. But the performance is far too bad. Rsyslog seems