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

Example 22-8 Timestamp Synchronization
For OCI:
SQLAction UpdateAcct {
{
input
RAD(Class) DBP(sessid, 254, CHAR)
output
DBR(-1:*) RET(ERROR)
DBR(0:0) RET(ACK)
DBR(*:*) RET(NAK)
SQLStatement db_oci {
UPDATE RAD_ACCT_TABLE
SET update_time=current_timestamp
WHERE session_id=:sessid
}
}
}
Finite State Table Configuration in the FSM
SQL Access for user profile retrieval requires no modification to the FSM. Use the Local
Realm screen in the Server Manager to configure the SQL action for the desired realm.
However, the FSM must be modified to perform more complex database interactions
such as accounting or session management with SQL Access.
At server startup, the FSM reads instructions from a state table by loading and parsing
the radius.fsm file. The radius.fsm file consists of definitions for states, events,
and actions that determine how a request is processed. See Chapter 26: “Customizing
the HP-UX AAA Server Using the Finite State Machine” (page 390) for more details on
state tables in the FSM.
To specify the SQL action to be executed during a particular state, modify the
radius.fsm file as follows:
1. Set ‘ Action’ to ‘SQLAccess’ for the state event to trigger the execution of an
SQL action.
2. Specify the SQL action in the xstring argument.
The following is an example of a modified FSM that executes account log requests via
SQL Access:
Implementing SQL Access 367