Sami Ketola wrote:

...

On 19. Oct 2020, at 18.54, Victor Sudakov <vas@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@fidonet http://vas.tomsk.ru/

On 20.10.2020 9.30, Matthias Lay wrote:

Am Tue, 20 Oct 2020 09:31:16 +0700 schrieb Victor Sudakov <vas@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. It's not just database.

plugin {

   last_login_dict = file:/somewhere/lastlogin

}

Aki

On 20 Oct 2020, at 00:33, Aki Tuomi <aki.tuomi@open-xchange.com> wrote:

plugin {

last_login_dict = file:/somewhere/lastlogin

}

It may be worth nothing that this can be specified as ~/.lastlogin As well as something along the liens of /usr/local/virtual/%d/%u/.lastlogin

Dovecot is smart enough to do the expansion per user in the ~

The contents of the file are simply the epoch times stamp of the last login and the string

"shared/last-login/%u"

As far as I can tell, though I suppose %u may vary by config?

(It makes much more sense to me to put this information into the user database than into a text file, but that's neither here nor there).

-- "Are you pondering what I'm pondering?" Pinky: (holding one of the pointy pieces from Sorry! and the bottle of Slick 'n Slide) I think so, Br... Brain: [shuts Pinky's mouth] No, on second thought, don’t tell me... I don't think they allow that in a book with the Comics Code.

On 20/10/2020 05:31, Victor Sudakov wrote:

Sami Ketola wrote:

...

...

On 19. Oct 2020, at 18.54, Victor Sudakov <vas@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 19 Oct 2020, at 20:31, Victor Sudakov <vas@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.

On 20 Oct 2020, at 20:08, Victor Sudakov <vas@sibptus.ru> wrote:

@lbutlr wrote:

...

On 19 Oct 2020, at 20:31, Victor Sudakov <vas@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.

How is SQLite different from MySQL? I have both on my system. They are both on-disk database files.

-- 'They come back to the mountains to die,' said the King. 'They live in Ankh-Morpork.' --The Fifth Elephant