Displaying 20 results from an estimated 2000 matches similar to: "Last Login example"
2020 Nov 16
1
last-login Plugin
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 ignored but last_login time.
Debugging MySQL, I notice that dovecot is using this query:
INSERT
2019 Apr 01
1
Possible bug with last_login plugin and PostgreSQL
Dear all,
I'm trying to get last_login plugin working with PostgreSQL, but seems Dovecot
doesn't handle duplicate key while updating last login time (note: same setting
works fine with MariaDB). I wonder whether it's a bug of Dovecot or i should handle
this with PostgreSQL trigger.
OS: OpenBSD 6.4 (amd64)
Dovecot: 2.2.36
PostgreSQL: 10.5
Error log:
###################
Mar 31
2019 Jun 06
3
Last Login Plugin Help
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 = proxy::lastlogin
??? last_login_key = last-login/%u/%d/%r
}
dict {
...
??? lastlogin =
2019 Jun 24
3
LastLogin update
Em 22/06/2019 22:41, Zhang Huangbin via dovecot escreveu:
>
>> On Jun 23, 2019, at 4:43 AM, @lbutlr via dovecot <dovecot at dovecot.org> 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
2019 Jun 07
0
Last Login Plugin Help
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 6 June 2019 22:40 Júlio Covolato via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
2018 Apr 11
3
two unrelated issues, lastlogin, and an out of memory fatal error
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 the table and the user:
mysql> describe users;
2018 Apr 11
0
two unrelated issues, lastlogin, and an out of memory fatal error
Hi!
On 10.04.2018 19:31, David Mehler wrote:
> Hello,
>
> I've got a few misc issues that I'm trying to get a handle on.
>
> I'm having what is probably a simple error with last logins. It's not
> working, unable to write values to the database. Here's the log lines:
>
> 2018-04-10 10:43:34 imap-login: Info: Login: user=<user at domain.com>,
>
2018 Mar 07
0
last login tracking
Hello,
I've got dovecot going with postfix and MySQL database for user and
domain storage. Dovecot handles the authentication.
My last login is not working, does anyone have a table example and
configs? I looked at the wiki page on the lastlogin plugin but
obviously what I'm doing isn't working, I keep getting message write
was unsuccessful for the lastlogin ip.
I'd appreciate
2017 Mar 22
0
last_login LDAP - killed with signal 11 (core dumped)
On 22.03.2017 10:03, Leon Kyneur wrote:
> Hi
>
> I am trying to configure the last_login plugin with LDAP dictionary
> which is causing dict service to crash. Not sure if this is a bug or
> some configuration parameter I'm getting wrong?
>
> Running latest dovecot but was having the same problem in earlier
> version 2.2.25
>
> # dovecot --version
> 2.2.28
2018 Apr 07
1
last login tracking error
Hello,
I'm running dovecot 2.2 and trying to do last login tracking. I am
using a MySQL database. When a user logs in I get this in the log:
2018-04-07 16:55:14 imap(user at example.com)<54415><BmevY0hpMN5/AAAB>:
Error: last_login_dict: Failed to write value for user
user at example.com: dict-server returned failure: sql dict: commit
failed: Field 'name' doesn't have
2017 Apr 28
4
Dovecot last_login plugin and Mysql
Hello,
Trying to implement lastlogin via mysql. I'm getting an unknown column
username which I don't get. Here's the log:
Apr 28 17:18:15 ohio dovecot: imap-login: Login:
user=<user at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,
mpid=16257, secured, session=<KxiSnEBOwUx/AAAB>
Apr 28 17:18:15 ohio dovecot: dict(17099): Error: sql dict: commit
failed: Unknown
2014 Oct 18
1
last_login plugin with MySQL
Hi,
I have a Dovecot test installation with MySQL userbase and authentication where
I am trying to setup last_login plugin with SQL dictionary
I read http://wiki2.dovecot.org/Plugins/LastLogin and I addes this to my
configuration
plugin {
last_login_dict = sql:/etc/dovecot/dovecot-sql.conf.ext
}
mail_plugins = $mail_plugins stats
protocol imap {
mail_plugins = $mail_plugins imap_stats
2014 Oct 18
0
Recap: last_login plugin with MySQL
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
With many thanks to Gedalya and Sven Hartge
Situation: Dovecot installation with userbase in a MySQL table with the same
structure described in Postfix.Admin installation; filesystem permission is
flat with a single user (vmail) who owns maildir mailbox files and directories.
Procedure to implement last-login plugin to update mailbox table. The
2017 Mar 22
1
last_login LDAP - killed with signal 11 (core dumped)
On Wed, Mar 22, 2017, at 01:04 AM, Aki Tuomi wrote:
>
> On 22.03.2017 10:03, Leon Kyneur wrote:
> > Hi
> >
> > I am trying to configure the last_login plugin with LDAP dictionary
> > which is causing dict service to crash. Not sure if this is a bug or
> > some configuration parameter I'm getting wrong?
> >
> > Running latest dovecot but was
2017 Mar 22
2
last_login LDAP - killed with signal 11 (core dumped)
Hi
I am trying to configure the last_login plugin with LDAP dictionary
which is causing dict service to crash. Not sure if this is a bug or
some configuration parameter I'm getting wrong?
Running latest dovecot but was having the same problem in earlier
version 2.2.25
# dovecot --version
2.2.28 (bed8434)
I have configured dovecot like so:
dovecot.conf (before conf.d/*.conf:
dict {
2018 Apr 10
2
two unrelated issues, lastlogin, and an out of memory fatal error
Hello,
I've got a few misc issues that I'm trying to get a handle on.
I'm having what is probably a simple error with last logins. It's not
working, unable to write values to the database. Here's the log lines:
2018-04-10 10:43:34 imap-login: Info: Login: user=<user at domain.com>,
method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=75934, TLS,
2015 Jan 13
0
dovecot-2.2.15 process dovecot/imap segfaults when dict process has troubles
W dniu 13.01.2015 o 13:53, Lazy pisze:
> I can't reproduce this with redis dict.
>
> Could You provide us with a doveconf -n ?
> Does this also happen with other dict engines ?
Working configuration:
auth_cache_size = 64 k
auth_cache_ttl = 10 mins
auth_master_user_separator = *
auth_mechanisms = plain login
deliver_log_format = msgid=%m: from=%f: phys=%p: virt=%w %$
dict {
2018 Oct 15
0
Problems with qouta_clone plugin
On 15.10.2018 15:34, Christian Ejlertsen wrote:
> On Mon, 2018-10-15 at 15:31 +0300, Aki Tuomi wrote:
>> You should add quota_clone to mail plugins.
>>
>> Aki
>>
>>
>> On 15.10.2018 15:28, Christian Ejlertsen wrote:
>>> Hello
>>>
>>> I'm having troubles getting the quota_clone plugin to work for me.
>>> i?, trying to
2018 Oct 15
2
Problems with qouta_clone plugin
On Mon, 2018-10-15 at 15:31 +0300, Aki Tuomi wrote:
> You should add quota_clone to mail plugins.
>
> Aki
>
>
> On 15.10.2018 15:28, Christian Ejlertsen wrote:
> > Hello
> >
> > I'm having troubles getting the quota_clone plugin to work for me.
> > i?, trying to put the quota values into to to fields, messages and
> > usage_in_bytes, in the
2018 Apr 02
0
dovecot lastlogin tracking
Hello,
I am trying to get Dovecot 2.3.1 to track lastlogins of users. I'm
using a MySQL database. When I log in I am getting this in the error
log:
2018-04-02 18:24:21 imap(user at domain.com)<61855><6R0rDeVodcl/AAAB>:
Error: last_login_dict: Failed to write value for user
user at domain.com: dict-server returned failure: sql dict: commit
failed: Field 'name' doesn't