imapd.conf: sasl_sql_update and sasl_sql_insert understanding

[Bron Gondwana]

On Wed, Aug 19, 2015, at 04:31, Dan White wrote:
> 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).

Yeah, that's pretty easy.  We process our syslog for many things, but we actually run a custom saslauthd anyway, so we use that for tracking last login.

Bron.

-- 
  Bron Gondwana
  brong at fastmail.fm