HP-UX AAA Server A.08.00.01 Administrator's Guide

Table 22-1 The sqlaccess.config Sample File (continued)
OperationTable Operated OnSQL Action
A stored procedure that is created
using dbsetup.sql. This procedure
RAD_TOKENS_TABLEUpdateFailedAuthCount
AndTokenStatus
increments the failed authentication
count after a failed authentication.
This stored procedure also increments
the lock counter for each failed
authentication. If the number of
consecutive failed authentication
attempts is greater than the
configured token lock counter value
(default 6), where the time interval
between two consecutive failed
authentication attempts is less than
60 seconds, it updates the token status
to LOCKED.
Inserts a row to the accounting table
for each user to start accounting.
RAD_ACCT_TABLEInsertAcct
Updates the column update_time
in the accounting table with the
current time for an active account.
RAD_ACCT_TABLEUpdateAcct
Sets the stop time in the accounting
table for a given session ID.
RAD_ACCT_TABLEStopAcct
Inserts a user session entry.
RAD_SESS_TABLEStartSession
Removes a user session entry.
RAD_SESS_TABLEStopSession
Removes all expired sessions that are
older than 24 hours.
RAD_SESS_TABLECleanupExpired
Sessions
Sets the stop time for all accounts that
match the client’s NAS identifier.
RAD_ACCT_TABLEStopAllAccts
Removes all sessions from the session
table that match the client’s NAS
identifier.
RAD_SESS_TABLECleanupAllSessions
Uses a stored procedure to return the
IP address of the session entry and
RAD_SESS_TABLEStopSession-DHCP
(OCI only)
removes the entry with a matching
session id from the session table. The
returned IP address is passed to the
AAAFreeIP mapping function to
initiate the releasing of the IP address
via DHCP.
Implementing SQL Access 339