dovecot - Dec 2008 - Possible to log IMAP connections to MySQL Table?

Is it currently possible to log all IMAP connection attempts to a MySQL table?
?Thanks.



_____________________ 
Corey

Corey Shaw wrote:
> Is it currently possible to log all IMAP connection attempts to a MySQL
table?  Thanks.
> 
Sure. You could use syslog-ng to log directly to a database or syslog 
plus SEC (http://kodu.neti.ee/~risto/sec/) to trigger insert rules.

~Seth

On Tue, Dec 23, 2008 at 1:30 PM, Seth Mattinen <sethm at rollernet.us>
wrote:
> Corey Shaw wrote:
>>
>> Is it currently possible to log all IMAP connection attempts to a MySQL
>> table?  Thanks.
>
> Sure. You could use syslog-ng to log directly to a database or syslog plus
> SEC (http://kodu.neti.ee/~risto/sec/) to trigger insert rules.
>
> ~Seth
If someone ever decides to make a log-login-tomysql plugin i would
love to use it. I currently have a php script that runs during
logrotate that parses the info.log for all pop3/imap logins and logs
them to mysql, i only keep per minute and then i have a history table
of peruser-perday for 90 days.

It would be way cool to have dovecot throw that to mysql
automagically. If i were a c programmer i would do it myself =S

If you use MySQL for auth you could include some logging bits as part of
your SQL query.

-----Original Message-----
From: dovecot-bounces+jkrejci=usinternet.com at dovecot.org
[mailto:dovecot-bounces+jkrejci=usinternet.com at dovecot.org] On Behalf Of
Corey Shaw
Sent: Tuesday, December 23, 2008 2:50 PM
To: dovecot at dovecot.org
Subject: [Dovecot] Possible to log IMAP connections to MySQL Table?

Is it currently possible to log all IMAP connection attempts to a MySQL
table? ?Thanks. 



_____________________ 
Corey

Am 23.12.2008 21:50 schrieb Corey Shaw:
> Is it currently possible to log all IMAP connection attempts to a MySQL
table?  Thanks.
If you really want to log _all_ IMAP connections you could create a
MySQL procedure that will log all interesting data you provide and
finally returns the data for Dovecots password query.
If you want to log only successful IMAP logins you should have a look at
http://wiki.dovecot.org/PostLoginScripting


Regards,
Pascal
-- 
Ubuntu is an ancient African word meaning ?I can?t install debian.?
                                                         -- unknown