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

Figure 18-1 SQL Access Components
When the AAA Server receives a RADIUS request to perform an action (for example,
authentication), it calls the SQL Access AATV if SQL Access is configured. The SQL
Access AATV maps RADIUS attributes to database columns and prepares user defined
SQL statements for execution. The connector libraries pass the SQL statements to vendor
supplied database client libraries, which in turn communicate with the database.
After the database returns the query results, the SQL Access AATV maps the resulting
database columns to RADIUS attributes for further processing by the AAA Server.
The definition of the input into the SQL statements (input map), the SQL statement
itself, and the output definition (output map) is called an SQL action.
SQL Access Concepts
SQL actions are defined in the /etc/opt/aaa/sqlaccess.config file as a set of
one or more combinations of SQL mappings and user defined SQL statements that are
executed against the database.
SQL mappings consist of input and output maps. An input map consists of one or more
input mapping entries, which identify the input into an SQL statement. An output map
consists of one or more output mapping entries which identify what to do with the
output from the SQL statement. Each mapping entry, input or output, consists of a
source and target component.
Mappings without SQL statements are possible, and SQL statements can be executed
without mapping entries. See “Advanced SQL Mapping Configuration” (page 232) for
more information.
208 SQL Access