HP-UX AAA Server A.08.01 administrator's guide (T1428-90072, May 2010)

4. Configure SQL Access execution based on your implementation:
• If SQL Access is used to retrieve user profiles, configure the SQL action for
the desired realm on the Local Realm screen in the Server Manager. See
“Adding a Realm” (page 105) for more information.
• If SQL Access is used for more advanced implementations, such as accounting
and session management, modify the Finite State Machine (FSM) radius.fsm
file to specify the execution of specific SQL actions for particular events. See
“Finite State Table Configuration in the FSM” (page 372) for more information.
The sample implementation includes two modified FSMs configured for
accounting without session management and accounting with session
management using the SQL Access feature.
5. Restart the server. You can also send the kill -HUP signal to activate the SQL
access implementation while the AAA server is running if you have not modified
the FSM. Refer to “HUP Processing” (page 519) for details on the kill -HUP
signal.
sqlaccess.config File Configuration
The sqlaccess.config file consists of the following definition types:
• An optional Global Definition;
• One or more database connection definitions (DBID) used to set up the database
connection;
• One or more SQL action definitions that identify the input and output parameters
and the SQL statement for execution.
The sqlaccess.config file definitions are as follows:
Implementing SQL Access 349