dovecot - Mar 2014 - Tracking logins

Hi,


I'm using dovecot-2.1.17 on fc18 and wondered if there is some
mechanism, perhaps a database,  that can store the logins/logouts for
each user? I realize there's something already logged to syslog, but
I'd like more of a history.

While lastlog is great for users that actually login, my dovecot users
don't login, just check email via pop and imap.

Any ideas greatly appreciated.
Thanks,
Alex

Am 03.03.2014 00:06, schrieb Alex:
> I'm using dovecot-2.1.17 on fc18
FC18 is EOL and it is unacceptable running a operating
system with no security updates as mailserver

 and wondered if there is some
> mechanism, perhaps a database,  that can store the logins/logouts for
> each user? I realize there's something already logged to syslog, but
> I'd like more of a history.
> 
> While lastlog is great for users that actually login, my dovecot users
> don't login, just check email via pop and imap
[root at srv-rhsoft:~]$ yum info rsyslog-mysql
Geladene Plugins: etckeeper, protectbase, tsflags
0 packages excluded due to repository protections
Installierte Pakete
Name       : rsyslog-mysql
Architektur : x86_64
Version    : 7.4.8
Ausgabe    : 1.fc20
Gr??e : 16 k
Quelle      : installed
Zusammenfassung: MySQL support for rsyslog
URL        : http://www.rsyslog.com/
Lizenz      : (GPLv3+ and ASL 2.0)
Beschreibung: The rsyslog-mysql package contains a dynamic shared object that
will add
            : MySQL database support to rsyslog.

[root at srv-rhsoft:~]$ cat /etc/redhat-release
Fedora release 20 (Heisenbug)

[root at srv-rhsoft:~]$ rpm -q dovecot
dovecot-2.2.12-2.fc20.20140214.rh.x86_64

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 246 bytes
Desc: OpenPGP digital signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20140303/220afc45/attachment.sig>

Am 03.03.2014 00:06, schrieb Alex:
> Hi,
> 
> 
> I'm using dovecot-2.1.17 on fc18 and wondered if there is some
> mechanism, perhaps a database,  that can store the logins/logouts for
> each user? I realize there's something already logged to syslog, but
> I'd like more of a history.
> 
> While lastlog is great for users that actually login, my dovecot users
> don't login, just check email via pop and imap.
> 
> Any ideas greatly appreciated.
> Thanks,
> Alex
> 
depending what you results you need, use i.e logwatch or take stuff out
of syslog at logrotate time with a script

like

https://sys4.de/de/blog/2013/02/02/monitoring-dovecot-last-login-rsyslog/

https://sys4.de/en/blog/2013/01/10/xymon-dovecot-count-imap-pop3-logins-graph-central-rsyslog-server-ubuntu-lucid/

using syslog with db, or syslog analyser solutions like graylog2, logtash,

also maybe fine

http://8pussy.org/
http://sareport.darold.net/


also you might give stats plugin a try

http://wiki2.dovecot.org/Statistics

Best Regards
MfG Robert Schetterer

-- 
[*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstra?e 15, 81669 M?nchen

Sitz der Gesellschaft: M?nchen, Amtsgericht M?nchen: HRB 199263
Vorstand: Patrick Ben Koetter, Marc Schiffbauer
Aufsichtsratsvorsitzender: Florian Kirstein