Re: last login user tracking

2019-06-22 Thread John Fawcett via dovecot
On 21/06/2019 23:13, David Mehler via dovecot wrote: > 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

Re: last login user tracking

2019-06-22 Thread Lefteris Tsintjelis via dovecot
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

Re: last login user tracking

2019-06-22 Thread John Fawcett via dovecot
On 22/06/2019 16:59, Lefteris Tsintjelis via dovecot wrote: > 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 >> >>

Re: LastLogin update

2019-06-22 Thread @lbutlr via dovecot
> On 20 Jun 2019, at 11:36, Adrian Minta via dovecot > 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

Re: LastLogin update

2019-06-22 Thread Zhang Huangbin via dovecot
> On Jun 23, 2019, at 4:43 AM, @lbutlr via dovecot 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