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

RADIUS Attribute to SQL Statement Mapping
You can use SQL mappings to define how to associate or "map" RADIUS attributes to
and from the input and output of your SQL statement . The execution of the SQL
statement and associated mappings occur in three steps:
1. Input Mappings
2. SQL statement execution
3. Output mappings
In the typical case, you map RADIUS attributes (input source) to SQL statement
placeholders (input target). The AAA Server binds the RADIUS data to the SQL
statement in preparation for execution.
After execution of the SQL statement, the AAA Server processes the output mappings,
which typically consist of a mapping to check the result of the SQL statement execution
and one or more mappings of database columns (output source) to RADIUS reply
attributes (output target). A new RADIUS attribute will be allocated for each output
mapping.
For maximum flexibility and customization, there are no pre-determined or hard coded
relationships between database columns and RADIUS attributes; that relationship is
created entirely through the sqlaccess.config file. See “sqlaccess.config File
Configuration” (page 218) for complete configuration definitions of the
sqlaccess.config file.
Figure 18-2 (page 210) illustrates the SQL mapping concept for RADIUS attribute to
database column mapping for a specific access request using OCI, in this example by
user John.
SQL Access Overview 209