IPv4/v6 based access checking and logging

[julio covolato]

Hi Lefteris.

Say thank you to Aki Tuomi, he was the one who taught me all this!!
That's the spirit of opem sourse!

----------------------------------
     _    Engº Julio Cesar Covolato
    0v0   <julio at psi.com.br>
   /(_)\  F: 55-11-99175-9260
    ^ ^   PSI INTERNET
----------------------------------

Em 12/11/2021 18:43, Lefteris Tsintjelis escreveu:
> 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
>> ----------------------------------
>>
>