similar to: Last Login Plugin Help

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

> 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

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

Em 24/06/2019 11:48, @lbutlr via dovecot escreveu: > 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 =

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

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,

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 mysql database. The quotas are getting written to the maildirsize file and can be updated with the doveadm quota recalc -A or -u "*" command But i can't seem to get it to trigger the quota_clone plugin, not even an

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

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

Hi Aki, Thanks. Can you tell me how you implemented it? Thanks. Dave. On 4/28/17, Aki Tuomi <aki.tuomi at dovecot.fi> wrote: > >> On April 28, 2017 at 8:08 PM David Mehler <dave.mehler at gmail.com> wrote: >> >> >> Hello, >> >> Is anyone using the last_login plugin with a Mysql database? I'd like >> to track when users were last on

On 22/6/2019 16:07, John Fawcett via dovecot wrote: > > 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

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

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

<!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>

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

On Mon, 2018-10-15 at 15:36 +0300, Aki Tuomi wrote: > > > > > It is :) > > > > > protocol imap { > > > mail_max_userip_connections = 1000 > > > mail_plugins = " quota notify replication imap_quota last_login > > > quota_clone" > > > } > > But that will only affect imap protocol. You should add it globally,

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 {

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;

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

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: https://docs.iredmail.org/public.folder.html