Sami Ketola wrote:> > > > On 19. Oct 2020, at 18.54, Victor Sudakov <vas at sibptus.ru> wrote: > > > > Dear Colleagues, > > > > Is there a file or directory within a user's Maildir, whose date of > > modification or access indicates the last time the user accessed his/her > > E-mail via IMAP or POP3? > > > > I'd like to figure out the time a user last logged in into his/her mail > > account, not the last time a mail was delivered to the INBOX. > > > > This information is probably available in the log, but a file which is > > touched each time a user accesses his/her mail, is more convenient. > > Not directly but you might want to take a look at this: https://doc.dovecot.org/configuration_manual/lastlogin_plugin/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. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/49 at fidonet http://vas.tomsk.ru/ -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 455 bytes Desc: not available URL: <https://dovecot.org/pipermail/dovecot/attachments/20201020/a821cb21/attachment.sig>
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 473 bytes Desc: Digitale Signatur von OpenPGP URL: <https://dovecot.org/pipermail/dovecot/attachments/20201020/7298955b/attachment.sig>
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 scriptYou can use lastlogin plugin to write to a file too. It's not just database. plugin { ?? last_login_dict = file:/somewhere/lastlogin } Aki -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 488 bytes Desc: OpenPGP digital signature URL: <https://dovecot.org/pipermail/dovecot/attachments/20201020/4e023f8b/attachment-0001.sig>
On 20/10/2020 05:31, Victor Sudakov wrote:> Sami Ketola wrote: >> >>> On 19. Oct 2020, at 18.54, Victor Sudakov <vas at sibptus.ru> wrote: >>> >>> Dear Colleagues, >>> >>> Is there a file or directory within a user's Maildir, whose date of >>> modification or access indicates the last time the user accessed his/her >>> E-mail via IMAP or POP3? >>> >>> I'd like to figure out the time a user last logged in into his/her mail >>> account, not the last time a mail was delivered to the INBOX. >>> >>> This information is probably available in the log, but a file which is >>> touched each time a user accesses his/her mail, is more convenient. >> Not directly but you might want to take a look at this: https://doc.dovecot.org/configuration_manual/lastlogin_plugin/ > 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. >I think you should be able to use sqlite just as well as MySQL. https://wiki.dovecot.org/Dictionary Good luck! Reio
> On 20. Oct 2020, at 5.31, Victor Sudakov <vas at sibptus.ru> wrote: > > Sami Ketola wrote: >> >> >>> On 19. Oct 2020, at 18.54, Victor Sudakov <vas at sibptus.ru> wrote: >>> >>> Dear Colleagues, >>> >>> Is there a file or directory within a user's Maildir, whose date of >>> modification or access indicates the last time the user accessed his/her >>> E-mail via IMAP or POP3? >>> >>> I'd like to figure out the time a user last logged in into his/her mail >>> account, not the last time a mail was delivered to the INBOX. >>> >>> This information is probably available in the log, but a file which is >>> touched each time a user accesses his/her mail, is more convenient. >> >> Not directly but you might want to take a look at this: https://doc.dovecot.org/configuration_manual/lastlogin_plugin/ > > 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.As you have already been told dict can be a file too. There just performance limits in writing to file dict. Sami -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20201020/6672046e/attachment.html>
On 19 Oct 2020, at 20:31, Victor Sudakov <vas at sibptus.ru> wrote:> I have seen this but I do not want this information in a database.?> Even a local sqlite database would do.What? -- I desire the things that will destroy me in the end.
@lbutlr wrote:> On 19 Oct 2020, at 20:31, Victor Sudakov <vas at sibptus.ru> wrote: > > I have seen this but I do not want this information in a database. > ? > > > Even a local sqlite database would do. > > What? >This meant that an external DMBS/daemon process (MySQL, Redis etc) was not desirable, but any on-disk format Dovecot can save the data in was fine with me. The sqlite format too. -- Victor Sudakov, VAS4-RIPE, VAS47-RIPN 2:5005/49 at fidonet http://vas.tomsk.ru/ -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 455 bytes Desc: not available URL: <https://dovecot.org/pipermail/dovecot/attachments/20201021/6c2f85cd/attachment.sig>