Displaying 20 results from an estimated 59 matches for "last_login_key".
2019 Jun 22
1
last login user tracking
...lue in a readable format with the
> FROM_UNIXTIME mysql funciton
>
> https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime
>
> To get remote ip
>
> define the rip field in your table and add it to the primary key
>
> add %r to the last_login_key
>
> last_login_key = last-login/%u/%d/%r
>
> add $rip to the pattern and fields section in your
> /etc/dovecot/dovecot-last-login.conf
>
> map {
> ??? pattern = shared/last-login/$user/$domain/$rip
> ??? table = last_login
> ??? value_field = last_login
> ??? val...
2019 Jun 21
3
last login user tracking
Hello,
I'm trying to get last login user tracking going, using Dovecot and
mysql. I'm using:
https://docs.iredmail.org/track.user.last.login.html
and it is working, I am seeing an entry and it is updated, the problem
is the last login value does not mean anything to me. I was wondering
if it's possible to have the value be of a last login date and time,
and also a remote ip would be
2019 Jun 24
3
LastLogin update
...fields {
??????? username = $user
??????? domain = $domain
??????? rip = $rip
??????? proto = $service
??? }
}
------------------------------------------------------
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 = 'julio at xxx.com.br';
+------------------+------------+------------+---------------+-------+
| username???????? | domain???? | last_login | rip?????????? | proto |
+------------------+--------...
2019 Jun 06
3
Last Login Plugin Help
...g Last_Login plugin whith Mysql back end and all works fine.
I just wonder to track besides time_stamp, user and domain, the remote
IP and proto (imap or pop3)
I tried in dovecot.conf:
plugin {
...
...
??? # Track last login time on imap and pop3
??? last_login_dict = proxy::lastlogin
??? last_login_key = last-login/%u/%d/%r
}
dict {
...
??? lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf
...
}
protocol imap {
??? mail_plugins = $mail_plugins ... last_login
...
}
protocol pop3 {
??? mail_plugins = $mail_plugins last_login
...
}
And dovecot-last-login.conf:
connect = host=127.0...
2019 Jun 22
0
last login user tracking
...hanks.
> Dave.
You can easily view the value in a readable format with the
FROM_UNIXTIME mysql funciton
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime
To get remote ip
define the rip field in your table and add it to the primary key
add %r to the last_login_key
last_login_key = last-login/%u/%d/%r
add $rip to the pattern and fields section in your
/etc/dovecot/dovecot-last-login.conf
map {
??? pattern = shared/last-login/$user/$domain/$rip
??? table = last_login
??? value_field = last_login
??? value_type = uint
??? fields {
??????? username = $user
?...
2019 Jun 24
2
LastLogin update
...at 08:25, J?lio Covolato via dovecot <dovecot at dovecot.org> 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
>> }
> Thank you, that is very clear.
>
> Where is the file dovecot-last-login.conf referenced in the dovecot.conf? Or it is enabled by virtue of being in conf.d/?
Sory, forgot this:
dovecot.conf:
dict {
??? #expire = db:/var/lib/dovecot/expire/expire.db...
2020 Nov 16
1
last-login Plugin
...',x.x.x.x','imap','jLFs5A609cdSN4Wh') ON DUPLICATE KEY
UPDATE last_login=1605350938
How can I modify the configuration?
conf.d/95-last_login.conf:
dict {
??? lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf.ext
}
plugin {
??? last_login_dict = proxy::lastlogin
??? last_login_key = last-login/%u/%r/%s/%{session}
}
protocol imap {
??? mail_plugins = $mail_plugins last_login
}
protocol pop3 {
??? mail_plugins = $mail_plugins last_login
}
dovecot-last-login.conf.ext:
connect = host=/var/lib/mysql/mysql.sock dbname=dovecot user=xxx
password=xxx
map {
??? pattern = shared/las...
2018 Oct 15
2
Problems with qouta_clone plugin
...\Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
prefix =
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u
mail_replica = tcp:imapb01.litmail.dk:12345
quota = maildir:User quota
quota_clone_dict = proxy::quotaclone
quota_grace = 10%%
quota_status_nouser = DUNNO
quota_status_overquota = 552 5.2.2 Mailbox is full
quota_status_success = DUNNO
}
protocols = imap
replication_max...
2018 Oct 15
2
Problems with qouta_clone plugin
...}
> > mailbox Trash {
> > special_use = \Trash
> > }
> > prefix =
> > }
> > passdb {
> > args = /etc/dovecot/dovecot-sql.conf.ext
> > driver = sql
> > }
> > plugin {
> > last_login_dict = proxy::lastlogin
> > last_login_key = last-login/%u
> > mail_replica = tcp:imapb01.litmail.dk:12345
> > quota = maildir:User quota
> > quota_clone_dict = proxy::quotaclone
> > quota_grace = 10%%
> > quota_status_nouser = DUNNO
> > quota_status_overquota = 552 5.2.2 Mailbox is full
>...
2018 Oct 15
1
Problems with qouta_clone plugin
...\Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
prefix =
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u
mail_replica = tcp:imapb01.litmail.dk:12345
quota = maildir:User quota
quota_clone_dict = proxy::quotaclone
quota_grace = 10%%
quota_status_nouser = DUNNO
quota_status_overquota = 552 5.2.2 Mailbox is full
quota_status_success = DUNNO
}
protocols = imap
replication_max...
2018 Nov 14
2
huge increase in storage activity afther dovecot upgrade
...auto = subscribe
special_use = \Junk
}
mailbox Trash {
auto = subscribe
special_use = \Trash
}
mailbox virtual/All {
special_use = \All
}
prefix =
}
passdb {
args = /etc/dovecot/mysql/dovecot-sql.conf
driver = sql
}
plugin {
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u
mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename
mail_log_fields = uid box msgid size
quota = dict:user::proxy::quotadict
quota_rule2 = Trash:ignore
quota_rule3 = Spam:ignore
quota_status_nouser = DUNNO
quota_status_overquota = 552 5.2.2 The...
2018 Nov 14
2
huge increase in storage activity afther dovecot upgrade
...auto = subscribe
> special_use = \Trash
> }
> mailbox virtual/All {
> special_use = \All
> }
> prefix =
> }
> passdb {
> args = /etc/dovecot/mysql/dovecot-sql.conf
> driver = sql
> }
> plugin {
> last_login_dict = proxy::lastlogin
> last_login_key = last-login/%u
> mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename
> mail_log_fields = uid box msgid size
> quota = dict:user::proxy::quotadict
> quota_rule2 = Trash:ignore
> quota_rule3 = Spam:ignore
> quota_status_nouser = DUNNO
> quo...
2019 Jun 07
0
Last Login Plugin Help
...iv>
<br>
</div>
<div>
...
</div>
<div>
<br>
</div>
<div>
# Track last login time on imap and pop3
</div>
<div>
last_login_dict = proxy::lastlogin
</div>
<div>
last_login_key = last-login/%u/%d/%r
</div>
<div>
<br>
</div>
<div>
}
</div>
<div>
<br>
</div>
<div>
dict {
</div>
<div>
...
</div>
<div>
<br>
</div>
&l...
2019 Jun 24
0
LastLogin update
On 24 Jun 2019, at 08:25, J?lio Covolato via dovecot <dovecot at dovecot.org> 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
> }
Thank you, that is very clear.
Where is the file dovecot-last-login.conf referenced in the dovecot.conf? Or it is enabled by virtue of being in conf.d/?
--
"I hate to advocate drugs, alcohol, violence, or insanity to anyone, but
they've always worked fo...
2019 Jun 24
0
LastLogin update
...at 08:25, J?lio Covolato via dovecot <dovecot at dovecot.org>
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 }
> Thank you, that is very clear.
>
> Where is the file dovecot-last-login.conf referenced in the dovecot.conf?
Or it is enabled by virtue of being in conf.d/?
Sory, forgot this:
dovecot.conf:
dict {
??? #expire = db:/var/lib/dovecot/expire/expire.db
??? quot...
2014 Oct 18
0
Recap: last_login plugin with MySQL
...he
lastlogin value is an integer in time() format
Alter mailbox SQL table to add a `lastlogin` unsigned int field
Add this to 10-master.conf
service dict {
unix_listener dict {
mode = 0660
user = vmail
}
}
In 90-plugin.conf add this:
plugin {
last_login_dict = proxy::lastlogin
last_login_key = last-login/%u # default
}
dict {
lastlogin = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext
}
Enable last login for IMAP and POP3:
protocol imap {
mail_plugins = $mail_plugins last_login
}
protocol pop3 {
mail_plugins = $mail_plugins last_login
}
Finally edit dovecot-dict-sql.conf.ext a...
2019 Jun 22
2
LastLogin update
> On 20 Jun 2019, at 11:36, Adrian Minta via dovecot <dovecot at dovecot.org> 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 with or confuse postfixadmin? I use that so that users can
2019 Jan 16
2
auth-worker: Error: double free or corruption (fasttop)
...ovecot-sql.conf
driver = sql
}
plugin {
acl_shared_dict = file:/var/lib/dovecot/shared-mailboxes
al = vfile
expire = Trash
expire2 = Trash/*
expire3 = Spam
expire_cache = yes
expire_dict = proxy::expire
fts = lucene
fts_lucene = whitespace_chars=@.-+_*:/\"'
last_login_key = # hidden, use -P to show it
quota = dict:User Quota::proxy::sqluserquota
quota_exceeded_message = Quota exceeded
quota_grace = 10%%
quota_rule2 = Trash:storage=+15%%
quota_rule3 = Spam:ignore
quota_status_nouser = DUNNO
quota_status_overquota = 552 5.2.2 Mailbox is over quota...
2018 Oct 15
0
Problems with qouta_clone plugin
...t;Sent Messages" {
> special_use = \Sent
> }
> mailbox Trash {
> special_use = \Trash
> }
> prefix =
> }
> passdb {
> args = /etc/dovecot/dovecot-sql.conf.ext
> driver = sql
> }
> plugin {
> last_login_dict = proxy::lastlogin
> last_login_key = last-login/%u
> mail_replica = tcp:imapb01.litmail.dk:12345
> quota = maildir:User quota
> quota_clone_dict = proxy::quotaclone
> quota_grace = 10%%
> quota_status_nouser = DUNNO
> quota_status_overquota = 552 5.2.2 Mailbox is full
> quota_status_success = DUNNO...
2020 Apr 25
4
problem with a public folder
...rt-spam.sieve
imapsieve_mailbox1_causes = COPY
imapsieve_mailbox1_name = Spam
imapsieve_mailbox2_before = file:/usr/local/lib/dovecot/sieve/report-ham.sieve
imapsieve_mailbox2_causes = COPY
imapsieve_mailbox2_from = Spam
imapsieve_mailbox2_name = *
last_login_dict = proxy::lastlogin
last_login_key = # hidden, use -P to show it
mail_crypt_curve = prime256v1
mail_crypt_global_private_key = # hidden, use -P to show it
mail_crypt_global_public_key = # hidden, use -P to show it
mail_crypt_save_version = 2
mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename
mai...