search for: lastlogin

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 { mode = 0660 group = postfix } } service lastlogin { executable = script-login -d /usr/local/bin/lastlogin.sh unix_listener lastlogin { user = $default_internal_user mode = 0666 }...

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 and protocol? Thanks in advanced, -------------- next part -------------- An HTML attachment was scrubbed...

Hi, Cool howto, and for protocol would this have that option also? From: dovecot <dovecot-bounces at dovecot.org> On Behalf Of Adrian Minta via dovecot Sent: Thursday, June 20, 2019 18:37 To: dovecot at dovecot.org Subject: Re: LastLogin update Hi, this seems to work very well: https://docs.iredmail.org/track.user.last.login.html You could also add "rip = $rip" in "fields" for the ip address. On 6/20/19 3:24 PM, Jorge Bastos via dovecot wrote: Howdy, I'd like an adive on what to use. I have...

On 20.10.2020 9.30, Matthias Lay wrote: > Am Tue, 20 Oct 2020 09:31:16 +0700 > schrieb Victor Sudakov <vas at sibptus.ru>: > > >> Hello Sami, >> >> I have seen this but I do not want this information in a database. If >> you know how to make the lastlogin_plugin write to a local file, that >> would be very helpful. Even a local sqlite database would do. >> >> The documentation for the plugin seems very scarce. >> >> > you could touch a file in the postlogin script You can use lastlogin plugin to write to a file too...

...eu: > 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/? Sory, forgot this: dovecot.conf: dict { ??? #expire = db:/var/...

...ould you share with us your "acl" config for shared folder? May be interesting for me, Jorge, -----Original Message----- From: dovecot <dovecot-bounces at dovecot.org> On Behalf Of J?lio Covolato via dovecot Sent: Monday, June 24, 2019 16:15 To: dovecot at dovecot.org Subject: Re: LastLogin update 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...

...pe = uint ??? 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 | +-------...

...s://docs.iredmail.org/track.user.last.login.html You could also add "rip = $rip" in "fields" for the ip address. On 6/20/19 3:24 PM, Jorge Bastos via dovecot wrote: > > 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 and protocol? > > Thanks in advanced, > -- Best regards, Adrian Minta...

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

...> wrote: >>>>> 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 >>>>>> the last_login time stamp. Here...

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

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

> 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

...39;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 = 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:...

My config: config plugins: # cat /etc/dovecot/conf.d/90-last_login.conf > dict { > lastlogin = mysql:/etc/dovecot/dict.conf.d/90-lastlogin.conf > } > plugin { > last_login_dict = proxy::lastlogin > } config db connector: # cat /etc/dovecot/dict.conf.d/90-lastlogin.conf > connect=host=localhost dbname=mail_user user=userDB password=Pa$$w0rd > map { > pattern =...

> 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 interfere with or confuse postfixadmin? I use that so that users can update their

...ation: 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 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_k...

Hi List, We have a remote asterisk SIP phone at the cottage. I'd like it to have minimal privileges when it first registers with Asterisk. Ideally it should be in a restricted context. Dialing any number would intercept the call and tell the person to log on. This way, if the phone was stolen or someone got into the cottage, we wouldn't have a bunch of surprise charges on our phone

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 ohi...

...le: >> me = User.find(''PS12345'') => #<User:0x2379788 @attributes={"mtime"=>"01.03.2006 13:26:32.737166", "valid"=>"8", "valid_from"=>"01.03.1999 14:09:21 CET", "valid_thru"=>nil, "lastlogin"=>"13.03.2006 16:04:58", "password"=>"cbd8f7984c654c25512e3d9241ae569f", "login"=>"PS12345", "email"=>"jan.foeh@parship.de"}> >> puts me.valid_from nil => nil Using before_type_cast, I can see the...