IPv4/v6 based access checking and logging
Lefteris Tsintjelis
lefty at spes.gr
Fri Nov 12 21:43:18 UTC 2021
Exactly what I was looking for and the script as well! Thank you very
much Julio
On 12/11/2021 20:33, julio covolato wrote:
>
> Em 12/11/2021 14:47, Lefteris Tsintjelis escreveu:
>> Hi,
>>
>> I am currently using postfix/dovecot with postfix admin and I track
>> the last login date already by using this:
>>
>> https://doc.dovecot.org/configuration_manual/lastlogin_plugin/
>>
>> Besides last login date, I would like to also implement IPv4 and IPv6
>> last login tracking also and if possible, IP based login checking. Is
>> post-login scripting the best most efficient way to go?
>>
>> Regards,
>>
>> Lefteris
>
> Hi,
>
> This is my lastlogin config to track remote ip:
>
> dovecot.conf:
>
> dict {
>
> lastlogin = mysql:/etc/dovecot/dovecot-last-login.conf
> ....
> }
>
> dovecot-last-login.conf:
>
> connect = host=127.0.0.1 port=3306 dbname=vmail user=vmailadmin
> password=XXXXXXXXXXXXXXX
>
> map {
> pattern = shared/last-login/$user/$domain/$rip/$service
> table = last_login
> value_field = last_login
> value_type = uint
>
> fields {
> username = $user
> domain = $domain
> rip = $rip
> proto = $service
> }
> }
>
> Mysql table last_login:
>
> +------------+--------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +------------+--------------+------+-----+---------+-------+
> | username | varchar(255) | NO | PRI | | |
> | domain | varchar(255) | NO | MUL | | |
> | last_login | int(11) | YES | MUL | NULL | |
> | rip | varchar(16) | NO | MUL | | |
> | proto | varchar(10) | NO | | NULL | |
> +------------+--------------+------+-----+---------+-------+
>
> Hope this help!
>
> ----------------------------------
> _ Engº Julio Cesar Covolato
> 0v0 <julio at psi.com.br>
> /(_)\ F: 55-11-99175-9260
> ^ ^ PSI INTERNET
> ----------------------------------
>
More information about the dovecot
mailing list