}
}
--
dovecot.conf:
plugin {
...
...
# Track last login time on imap and pop3
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u/%d/%r/%s
}
Result on mysql:
mysql> select * from last_login where username = 'ju...@xxx.com
Cool thanks,
From: dovecot On Behalf Of Júlio Covolato via
dovecot
Sent: 25 de junho de 2019 17:06
To: dovecot@dovecot.org
Subject: Re: LastLogin update
Em 24/06/2019 18:39, Jorge Bastos via dovecot escreveu:
Hi Julio,
Could you share with us your "acl" config for sha
Em 24/06/2019 18:39, Jorge Bastos via dovecot escreveu:
Hi Julio,
Could you share with us your "acl" config for shared folder?
May be interesting for me,
Jorge,
Hi Jorge.
Currently I'm not using the shared folder.
Maybe you could be interested in this tutorial from iRedmail:
Hi Julio,
Could you share with us your "acl" config for shared folder?
May be interesting for me,
Jorge,
-Original Message-
From: dovecot On Behalf Of Júlio Covolato via
dovecot
Sent: Monday, June 24, 2019 16:15
To: dovecot@dovecot.org
Subject: Re: LastLogin update
Em 24/
Em 24/06/2019 11:48, @lbutlr via dovecot escreveu:
On 24 Jun 2019, at 08:25, Júlio Covolato via dovecot
wrote:
#$ cat dovecot-last-login.conf
[ … ]
dovecot.conf:
plugin {
# Track last login time on imap and pop3
last_login_dict = proxy::lastlogin
last_login_key = last
On 24 Jun 2019, at 08:25, Júlio Covolato via dovecot
wrote:
> #$ cat dovecot-last-login.conf
[ … ]
> dovecot.conf:
>
> plugin {
> # Track last login time on imap and pop3
> last_login_dict = proxy::lastlogin
> last_login_key = last-login/%u/%d/%r/%s
> }
{
...
...
# Track last login time on imap and pop3
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u/%d/%r/%s
}
Result on mysql:
mysql> select * from last_login where username = 'ju...@xxx.com.br';
+--+++---+---+
| usern
> On Jun 23, 2019, at 4:43 AM, @lbutlr via dovecot wrote:
>
>> https://docs.iredmail.org/track.user.last.login.html
>
> This is cool, but I have a question:
>
>> For MySQL/MariaDB backends, we create the sql table in database vmail.
>
> Would this interfere with or confuse postfixadmin? I
> On 20 Jun 2019, at 11:36, Adrian Minta via dovecot
> wrote:
>
> this seems to work very well:
>
> https://docs.iredmail.org/track.user.last.login.html
This is cool, but I have a question:
> For MySQL/MariaDB backends, we create the sql table in database vmail.
Would this interfere
Hum,
I can add
Protocol = $protocol ?
The variables below are the valid ones right?
https://wiki.dovecot.org/Variables
From: dovecot On Behalf Of Jorge Bastos via
dovecot
Sent: Thursday, June 20, 2019 21:49
To: dovecot@dovecot.org
Subject: RE: LastLogin update
Hi,
Cool
Hi,
Cool howto, and for protocol would this have that option also?
From: dovecot On Behalf Of Adrian Minta via
dovecot
Sent: Thursday, June 20, 2019 18:37
To: dovecot@dovecot.org
Subject: Re: LastLogin update
Hi,
this seems to work very well:
https://docs.iredmail.org
, and i want to have the lastlogin of them, what is
the native option for this:
* Using last_login plugin which will give me the last login?
* Use postlogin for imap and pop3n which will give me besides
lastlogin the IP and protocol?
Thanks in advanced,
--
Best regards,
Adrian Minta
Bastos via dovecot :
Howdy,
I'd like an adive on what to use.
I have sql users, and i want to have the lastlogin of them, what is the
native option for this:
* Using last_login plugin which will give me the last login?
* Use postlogin for imap and pop3n which will give me besides
Howdy,
I'd like an adive on what to use.
I have sql users, and i want to have the lastlogin of them, what is the
native option for this:
* Using last_login plugin which will give me the last login?
* Use postlogin for imap and pop3n which will give me besides
lastlogin the IP
Reio
>>>
>>> On 11.04.2018 21:39, David Mehler wrote:
>>>> Hi,
>>>>
>>>> Can I get the database display to display those timestamps in a
>>>> particular format?
>>>>
>>>> Thanks.
>>>> Dave.
>>>&g
On 11.04.18 18:23, David Mehler wrote:
Hello Aki,
Thanks for your suggestion. I followed it and the wiki at:
https://wiki.dovecot.org/Plugins/LastLogin
Good news, I get a record in the users table, with the username that
just logged in. This is good. Bad news is I got unexpected output from
* David Mehler, 2018-04-11 17:23
> [...]
> The issue is the 1523459718 I was expecting something like a time
> stamp. Is this fixable? Also, can I use last_login to see on which IP
> the user last logged in from?
> [...]
This is in fact a timestamp:
[zlatko@disclosure:~]$ date -d @1523459718
Hello Aki,
Thanks for your suggestion. I followed it and the wiki at:
https://wiki.dovecot.org/Plugins/LastLogin
Good news, I get a record in the users table, with the username that
just logged in. This is good. Bad news is I got unexpected output from
the last_login time stamp. Here's
ache takes more memory than you have anticipated.
> Any help appreciated on either issue.
> Thanks.
> Dave.
>
> doveconf -n
> # 2.3.1 (8e2f634): /usr/local/etc/dovecot/dovecot.conf
> # Pigeonhole version 0.5.1 (d9bc6dfe)
> # OS: FreeBSD 11.1-RELEASE-p4 amd64
> # Hostname: local
domain.com
auth_mechanisms = plain login
dict {
acl = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
lastlogin = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
quota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext
}
first_valid_gid = 999
first_valid_uid = 999
hostname = xx
dovecot-dict-sql.conf.ext file:
map {
pattern = shared/last-login/$username
table = accounts
username_field = username
value_field = lastlogin
fields {
username = $username
}
}
I've got all users in the accounts table and there is a lastlogin column:
descr
.
According to http://wiki2.dovecot.org/Plugins/LastLogin the plugin uses redis,
but can use other dictionaries
If I have MySQL as userbase backend what field(s) should be created to have
this information recordered in the database?
Ciao,
luigi
- --
/
+--[Luigi Rosa]--
\
Afternoon
Hey guys!
I've been googling without success. Do anyone know if there is a way to
track last login of a smtp authentication?
I've tried without success using:
service auth {
executable = auth lastlogin
unix_listener auth-userdb {
}
unix_listener /var/spool/postfix/private/auth
On 10/29/2014 05:54 PM, Eduardo Ramos wrote:
Hey guys!
I've been googling without success. Do anyone know if there is a way to
track last login of a smtp authentication?
I've tried without success using:
service auth {
executable = auth lastlogin
unix_listener auth-userdb
googling without success. Do anyone know if there is a way
to track last login of a smtp authentication?
I've tried without success using:
service auth {
executable = auth lastlogin
unix_listener auth-userdb {
}
unix_listener /var/spool/postfix/private/auth {
mode = 0660
group
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Timo Sirainen wrote on 14/10/2014 18:53:
+ Added last-login plugin to set user's last-login timestamp on login.
According to http://wiki2.dovecot.org/Plugins/LastLogin the plugin uses redis,
but can use other dictionaries
If I have MySQL
26 matches
Mail list logo
