On 17/07/2024 23:35, Adam Miller via dovecot wrote:
Yes, I did see that, thank you. If I did want to get this working
globally, do you know what the issue is here and how to resolve it? I
think it has something to do with my database table but I am not
positive what the issue is. Here’s my dat
e 7/17/2024 2:07:29 PM
Subject Re: Invalid/Unmapped Key with Last Login Plugin
On 17/07/2024 22:59, Adam Miller via dovecot wrote:
Yikes, this is my bad! I AM using the LMTP service for delivery. What I meant
was that I do not necessarily need to track the logins to the LMTP service. I
suppose
On 17/07/2024 22:59, Adam Miller via dovecot wrote:
Yikes, this is my bad! I AM using the LMTP service for delivery. What
I meant was that I do not necessarily need to track the logins to the
LMTP service. I suppose it wouldn’t hurt to track them though. Any
idea why it would be throwing this
.
Thank you!
-- Original Message --
From "John Fawcett via dovecot"
To dovecot@dovecot.org
Date 7/17/2024 10:23:24 AM
Subject Re: Invalid/Unmapped Key with Last Login Plugin
On 17/07/2024 16:03, dovecot--- via dovecot wrote:
Hello all! I have the last login plugin working wit
On 17/07/2024 16:03, dovecot--- via dovecot wrote:
Hello all! I have the last login plugin working with the IMAP service
however with LMTP, it errors.
I do not necessarily need / want the LMTP service and did not
explicitly enable it but it is throwing an error in my logs.
Jul 17 10:22:14
On 17/07/2024 12:28, Adam Miller via dovecot wrote:
OS: Ubuntu 22.04.1
Dovecot: 2.3.16 (7e2e900c1a)
Hello all! I have the last login plugin working with the IMAP service
however with LMTP, it errors. I do not necessarily need / want the
LMTP service and did not explicitly enable it but it is
Hello all! I have the last login plugin working with the IMAP service however
with LMTP, it errors.
I do not necessarily need / want the LMTP service and did not explicitly enable
it but it is throwing an error in my logs.
Jul 17 10:22:14 lmtp(184051):Error: last_login_dict: Failed to write
OS: Ubuntu 22.04.1
Dovecot: 2.3.16 (7e2e900c1a)
Hello all! I have the last login plugin working with the IMAP service
however with LMTP, it errors. I do not necessarily need / want the LMTP
service and did not explicitly enable it but it is throwing an error in
my logs.
Jul 17 10:22:14 lmtp
On 9/14/21 05:44, dove...@ptld.com wrote:
>
> Thank you for the solution of using sql triggers. I was able to get it
> working that way.
> I hope it doesn't add too much overhead as it feels like a band-aid and
> duct-tape fix.
Yes, it's a workaround rather than being able to customize the SQL q
On 9/14/21 02:25, dove...@ptld.com wrote:
>
> The problem im having with the last-login plugin is the only option i can see
> to use is a dict map{}. I can not create my own query for the plugin to
> execute otherwise this would be way easier. Using the map{} method all you
> ca
On 9/14/21 02:12, dove...@ptld.com wrote:
>
> Anyone have any idea how to get the last-login plugin to update a date/time
> column in sql?
I use this to throttle updates to once in 900 seconds:
create trigger tg1 before update on mailacct for each row if new.lastlogin <
(old.las
Assuming you use MariaDB / MySQL, you create this trigger in the
database.
Assuming your int/bigint/varchar column is lastlogin and the table name
is mailacct,
the trigger will update the datetime `logindate` column whenever the
table is updated,
by whatever existing queries you have. This is yo
On 09-13-2021 2:20 pm, Gedalya wrote:
On 9/14/21 02:12, dove...@ptld.com wrote:
Anyone have any idea how to get the last-login plugin to update a
date/time column in sql?
I use this to throttle updates to once in 900 seconds:
create trigger tg1 before update on mailacct for each row if
The last-login plugin sends a number (epoch seconds) as uint or string
in a query to sql. If i create a column type in sql of varchar() the
number is saved in the column as a string, but not very useful.
I can not figure out how to get that value into a date/time column such
as date, datetime
Em 02/09/2021 10:59, White, Daniel E. (GSFC-770.0)[NICS] escreveu:
https://doc.dovecot.org/configuration_manual/lastlogin_plugin/
Is there any documentation about how to get the "Last Login" info into the
PostfixAdmin database ?
Hi Daniel.
I tried it some time ago without success, I ended gi
https://doc.dovecot.org/configuration_manual/lastlogin_plugin/
Is there any documentation about how to get the "Last Login" info into the
PostfixAdmin database ?
On 16/11/2020 11:55, Andrea Gabellini wrote:
> Hello,
>
> i'm using last_login plugin and store data into a MySql DB. I'm using
> version 2.3.10.1 and the config is at the end of the email.
>
> I would like to store also the remote IP and the session name. The
> config is working but other informat
Hello,
i'm using last_login plugin and store data into a MySql DB. I'm using
version 2.3.10.1 and the config is at the end of the email.
I would like to store also the remote IP and the session name. The
config is working but other informations are written only the first
time. Any update is ignor
Em 06/06/2019 22:45, Aki Tuomi via dovecot escreveu:
map {
pattern = shared/last-login/$user/$domain
table = last_login
value_field = last_login
value_type = uint
fields {
username = $user
domain = $domain
rip = $rip
}
}
You are missing /$rip in p
On 6 June 2019 22:40 Júlio Covolato via dovecot <
dovecot@dovecot.org> wrote:
Hi,
I'm configuring Last_Login plugin whith Mysql back end and all works fine.
I just wonder to track
Sory, forgot dovecot -n:
# 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf
# Pigeonhole version 0.4.21 (92477967)
# OS: Linux 4.15.0-47-generic x86_64 Ubuntu 18.04.2 LTS
auth_default_realm = psi.com.br
auth_master_user_separator = *
auth_mechanisms = PLAIN LOGIN
deliver_log_format = from=%{from},
Hi,
I'm configuring 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 = pr
last_login_dict = redis:host=127.0.0.1:port=6379
> with this:
> last_login_dict = sql:my_sql_config_file.conf
>
> Please test it out as I myself haven’t used the plugin yet.
>
>
> Philon
>
> > Am 30.08.2016 um 13:59 schrieb Adrian M :
> >
> > Hello,
>
onfig_file.conf
Please test it out as I myself haven’t used the plugin yet.
Philon
> Am 30.08.2016 um 13:59 schrieb Adrian M :
>
> Hello,
> is it possible to use Last Login Plugin with mysql instead of redis ?
> http://wiki2.dovecot.org/Plugins/LastLogin
>
> .--
> Best regards,
> Adrian Minta
Hello,
is it possible to use Last Login Plugin with mysql instead of redis ?
http://wiki2.dovecot.org/Plugins/LastLogin
.--
Best regards,
Adrian Minta
25 matches
Mail list logo
