dovecot - Feb 2021 - last login plugins

last_login supports some of the variables. 


Mail service and mail user variables are supported. 

You can try export the auth variables as userdb variables and use $variablename.

Aki

On 27 February 2021 7.29.10 EET, Henry <hl1723 at yahoo.com.hk>
wrote:
> 
>Anyone know then last_login plugins do support standard auth variables
>in var-expand?like %k %a??variables.
>I need logging other fields such as port 143 or 993, and tls 1.1 or tls
>1.3, client hostname,
>any patch for this? thanks
>
>https://doc.dovecot.org/configuration_manual/config_file/config_variables/
> Henry (<hl1723 at yahoo.com.hk>) ? 2021?2?19???? ??12:15:10 [GMT+8]
???
> 
>but I need logging other fields such as port 143 or 993, and tls 1.1 or
>tls 1.3, client hostname,?what should I do it ?
>https://doc.dovecot.org/configuration_manual/config_file/config_variables/
>
>Aki Tuomi (<aki.tuomi at open-xchange.com>) ? 2021?2?18???? ??03:04:10
>[GMT+8] ???  
> 
> 
>> On 18/02/2021 08:57 Henry <hl1723 at yahoo.com.hk> wrote:
>> 
>> 
>> 
>> 
>> Anyone kwon the last-login plugins can using Authentication variables
>such as?%m mechanism, %a local_port .
>> we want to record this in DB, thanks
>
>You can use this syntax to add further fields for last_login plugin.
>
> map {
>? ? pattern = shared/last-login/$user/$domain
>? ? table = last_login
>? ? value_field = last_login
>? ? value_type = uint
>
>? ? fields {
>? ? ? ? username = $user
>? ? ? ? domain = $domain
>? ? ? rip = $rip
>? ? }
>} 
>
>Aki
>    
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

> On Feb 27, 2021, at 7:32 PM, Aki Tuomi <aki.tuomi at
open-xchange.com> wrote:
> 
> last_login supports some of the variables. 
Dear Aki,

Does last_login plugin support PostgreSQL now?

Old reports:

- https://marc.info/?t=155411531600001&r=1&w=2
- https://marc.info/?t=155826327900001&r=1&w=2

----
Zhang Huangbin, founder of iRedMail project: https://www.iredmail.org/

I already try using other?variables , I found it only support "Mail service
user variables", no support "Login variables" and
"Authentication variables"
below the error when I try to using?"Login variables" and
"Authentication variables"
Error: Failed to expand plugin setting last_login_key =
'last-login/%u/%d/%r/%l/%k': Unknown variable '%k'
Error: Failed to expand plugin setting last_login_key =
'last-login/%u/%d/%r/%l/%b': Unknown variable '%b'Error: Failed
to expand plugin setting last_login_key = 'last-login/%u/%d/%r/%l/%m':
Unknown variable '%m'

I using centos 8 and dovecot-2.3.13-2.x86_64,?

thanks?
    Aki Tuomi (<aki.tuomi at open-xchange.com>) ? 2021?2?27???? ??07:32:38
[GMT+8] ???
 
 last_login supports some of the variables. 


Mail service and mail user variables are supported. 

You can try export the auth variables as userdb variables and use $variablename.

Aki

On 27 February 2021 7.29.10 EET, Henry <hl1723 at yahoo.com.hk>
wrote:
> 
>Anyone know then last_login plugins do support standard auth variables
>in var-expand?like %k %a??variables.
>I need logging other fields such as port 143 or 993, and tls 1.1 or tls
>1.3, client hostname,
>any patch for this? thanks
>
>https://doc.dovecot.org/configuration_manual/config_file/config_variables/
> Henry (<hl1723 at yahoo.com.hk>) ? 2021?2?19???? ??12:15:10 [GMT+8]
????
> 
>but I need logging other fields such as port 143 or 993, and tls 1.1 or
>tls 1.3, client hostname,?what should I do it ?
>https://doc.dovecot.org/configuration_manual/config_file/config_variables/
>
>Aki Tuomi (<aki.tuomi at open-xchange.com>) ? 2021?2?18???? ??03:04:10
>[GMT+8] ???? 
> 
> 
>> On 18/02/2021 08:57 Henry <hl1723 at yahoo.com.hk> wrote:
>> 
>> 
>> 
>> 
>> Anyone kwon the last-login plugins can using Authentication variables
>such as?%m mechanism, %a local_port .
>> we want to record this in DB, thanks
>
>You can use this syntax to add further fields for last_login plugin.
>
> map {
>? ? pattern = shared/last-login/$user/$domain
>? ? table = last_login
>? ? value_field = last_login
>? ? value_type = uint
>
>? ? fields {
>? ? ? ? username = $user
>? ? ? ? domain = $domain
>? ? ? rip = $rip
>? ? }
>} 
>
>Aki
>? ? 
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20210227/fbbe4286/attachment.html>