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

for detailed information on how to install your sample SQL Access implementation
for Oracle.
• /opt/aaa/examples/sqlaccess/mysql-1: files to set up a sample
implementation for MySQL and Unix ODBC driver. See the README in that
directory for detailed information on how to install your sample SQL Access
implementation for MySQL.
NOTE: The database server and client are not provided with the HP-UX AAA Server.
However, HP supports connectivity to selected database clients and provides a
corresponding client connector library for those supported clients.
The following section provides an overview of the sample implementation:
sqlaccess.config Sample File
The sqlaccess.config sample file is configured for the database tables defined in
the schema files provided with this sample configuration. Its SQL actions operate on
the database tables as follow:
Table 22-1 The sqlaccess.config Sample File
OperationTable Operated OnSQL Action
Retrieves the user profile. Uses SQL
result mapping to test that at least one
RAD_USERS_TABLE
RetrieveUser
row is returned and sets event to
RETRIEVE_SUCCESS upon exiting to
the FSM.
Retrieves token information. Uses
SQL result mapping to test that at
RAD_TOKENS_TABLERetrieveToken
least one row is returned and sets the
event to RETRIEVE_SUCCESS on
exiting to the FSM.
Retrieves user and token information.
Uses SQL result mapping to test that
RAD_TOKENS_TABLE and
RAD_USERS_TABLE
RetrieveUserAndToken
at least one row is returned and sets
the event to RETRIEVE_SUCCESS on
exiting to the FSM.
A stored procedure that is created
using dbsetup.sql. This procedure
RAD_TOKENS_TABLEUpdateSequenceCounter
AndSuccessAuthCount
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.
338 SQL Access