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 >> >> https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-u

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 you

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 i

Re: last login user tracking

2019-06-21 Thread @lbutlr via dovecot
On 21 Jun 2019, at 15:13, David Mehler via dovecot wrote: > the problem is the last login value does not mean anything to me. It is standard unix “seconds since the epoch’ and can be converted into any format you want in any time zone at any time by using the date command. # date -r 15

last login user tracking

2019-06-21 Thread David Mehler via dovecot
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 wonderi