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?