last login user tracking

[Lefteris Tsintjelis]

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 your table and add it to the primary key
> 
> add %r to the last_login_key
> 
> last_login_key = last-login/%u/%d/%r
> 
> add $rip to the pattern and fields section in your
> /etc/dovecot/dovecot-last-login.conf
> 
> map {
>     pattern = shared/last-login/$user/$domain/$rip
>     table = last_login
>     value_field = last_login
>     value_type = uint
> 
>     fields {
>         username = $user
>         domain = $domain
>        rip = $rip
>     }
> }
> 
> By adding the rip field to the primary key of the table, you can end up
> with multiple rows per username each with different ips, but if you
> don't do that, the rip field is never updated after the first insert.

Does it work with IPv4 as well as IPv6? What is the optimal way to
declare the rip field as?