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

RAD_TOKENS_TABLE
serial_number
user_name
manufacturer
token_status
seq_counter
shared_secret
otp_length
lookup_window
checksum
activation_code
success_auth_count
failed_auth_count
failed_lock_count
locktime
The SQL actions and stored procedures listed in Table 16-6 are added in the
sqlaccess.config file to support OTP authentication.
Table 16-6 SQL actions and Stored Procedures that Support OTP Authentication
OperationTable Operated OnSQL action
Retrieves token information. Uses
SQL result mapping to ensure that
RAD_TOKENS_TABLERetrieveToken
at least one row is returned. It also
sets the event to
RETRIEVE_SUCCESS on exiting
to the FSM.
Retrieves user and token
information. Uses SQL result
RAD_TOKENS_TABLE and
RAD_USERS_TABLE
RetrieveUserAndToken
mapping to ensure that at least one
row is returned. It also sets the
event to RETRIEVE_SUCCESS on
exiting to the FSM.
A stored procedure that is created
using dbsetup.sql. This
RAD_TOKENS_TABLEUpdateSequenceCounterAnd
SuccessAuthCount
procedure updates the sequence
counter that is passed as an
argument. This action is called
after successful OTP
authentication. This stored
procedure also increments the
success authentication count.
Configuring OTP Authentication on the HP-UX AAA Server 213