[Dovecot] 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@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@srv-rhsoft:~]$ cat /etc/redhat-release Fedora release 20 (Heisenbug)
[root@srv-rhsoft:~]$ rpm -q dovecot dovecot-2.2.12-2.fc20.20140214.rh.x86_64
Hi,
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
Yes, thanks, I know I have to update. The next update will probably be RHEL.
While lastlog is great for users that actually login, my dovecot users don't login, just check email via pop and imap
[root@srv-rhsoft:~]$ yum info rsyslog-mysql
Is there a specific hook from dovecot to mysql that you can point me to?
Thanks, Alex
Am 03.03.2014 01:38, schrieb 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
Yes, thanks, I know I have to update. The next update will probably be RHEL.
your decision i went from F9 to F20 with every dist-upgrade between including the siwtch to systemd, UsrMove and grub2
While lastlog is great for users that actually login, my dovecot users don't login, just check email via pop and imap
[root@srv-rhsoft:~]$ yum info rsyslog-mysql
Is there a specific hook from dovecot to mysql that you can point me to?
dovecot does not need to know about that dovecot -> syslog -> rsyslog -> mysql https://www.google.com/search?q=rsysog+mysql
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-grap...
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
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-grap...
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
Awesome, thanks guys. This is much more helpful than just telling me to google it - I was looking for something that was designed to actually do this before developing something that queries mysql from scratch, and this is a good start.
Thanks, Alex
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
participants (3)
-
Alex
-
Reindl Harald
-
Robert Schetterer