imapd.conf: sasl_sql_update and sasl_sql_insert understanding

[Dan White]

On 08/18/15 12:52 +0400, Sergey wrote:
>Hello.
>
>I need to fixate time of last succesful logon to Cyrus-IMAP.
>I see sasl_sql_update and sasl_sql_insert in some imapd.conf
>examples but does not see description of behavior of them.
>
>Can I solve this problem this way or I need to select another
>way ?

Those are documented here:

http://www.cyrussasl.org/docs/cyrus-sasl/2.1.25/options.php

sql_insert and sql_update would only be called when creating or updating a
user with saslpasswd2, or when auto_transition is enabled. If your sql
backend can trigger an update on access, you could update your sql entry
when sql_select is called. That would require 'sasl_auxprop_plugin: sql' to
be configured.

Or you could process your syslog (local6/mail/auth).

-- 
Dan White