This SQL statement is executed whenever a new policy state
entry is created for a username. It is expected to record the details of
both consecutive and cumulative counters, policy violation and current
window time in the SQL database. Special formatting characters are
replaced as follows:
- %0 with the username
- %1 with the
FailurePolicyContext parameter
value
- %2 with the current consecutive failures
- %3 with the current consecutive failure window end timestamp
- %4 with the current consecutive lock end timestamp
- %5 with the current cumulative failures
- %6 with the current cumulative failure window end timestamp
- %7 with the current cumulative lock end timestamp
There is no default and
AddQuery is not
run.
AddQuery is not needed if
UpdateQuery can do both the add and update.
AddQuery supports SQL bind variables with
AddQueryParam. See the sample configuration file
goodies/failurepolicy.cfg for an example query. For
more information about bind variables, see
Section 3.8.1. SQL bind variables.
