Hello! I would like to put user login attempts into SQL DB (PostgreSQL). Any idea how to do it (without manual parsing log files)? Kind regards, Krzysztof Kiszewski
This is not particularly dovecot specific or related, but I think the best approach is to redirect syslog messages to a SQL DB. Searching google for "syslog postgresql" returns quite a few results... good luck On Fri, 2006-09-01 at 12:38 +0200, Krzysztof wrote:> Hello! > > I would like to put user login attempts into SQL DB (PostgreSQL). Any > idea how to do it (without manual parsing log files)? > > Kind regards, > Krzysztof Kiszewski
Hi, IIRC, syslog-ng has SQL-insert support. You would need to setup some filters to avoid non-dovecot related stuff. Please note I haven't used this syslog-ng feature. Charles On ven, 2006-09-01 at 12:38 +0200, Krzysztof wrote:> Hello! > > I would like to put user login attempts into SQL DB (PostgreSQL). Any > idea how to do it (without manual parsing log files)? > > Kind regards, > Krzysztof Kiszewski-- Charles Bueche <charles at bueche.ch> sand, snow, wave, wind and net -surfer