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#functio...
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?