HP-UX AAA Server A.08.02.10 Administrator's Guide HP-UX 11i v3 (T1428-90093, November 2013)

Table 67 SQL Actions that Support Dynamic Authorization in Groups (continued)
DescriptionSQL Action
Updates the status of a session entry for which Disconnect-NAK
was received. This SQL action is used only when multiple HP-UX
AAA Servers are configured as a group.
SuspendDisconnectedSessionServerGroup
Distributes the list of sessions for which CoA requests must be sent,
among the live HP-UX AAA Servers in the group. This SQL action
DistributeCoASessions
is used only when multiple HP-UX AAA Servers are configured as
a group.
Creates CoA requests to change data filters. This SQL action is used
only when multiple HP-UX AAA Servers are configured as a group.
CreateCoAReqServerGroup
Updates the status of the session entry to indicate that it is already
processed for CoA-Request. This SQL action is used only when
multiple HP-UX AAA Servers are configured as a group.
UpdateCoAReqServerGroup
Updates the status of the session entry to indicate that the
CoA-Request has timed out. This SQL action is used only when
multiple HP-UX AAA Servers are configured as a group.
TimeoutCoAReqServerGroup
Updates the session entry for which CoA-ACK was received. This
SQL action is used only when multiple HP-UX AAA Servers are
configured as a group.
UpdateCoASessionServerGroup
Updates the status of a session entry for which CoA-NAK was
received. This SQL action is used only when multiple HP-UX AAA
Servers are configured as a group.
SuspendCoASessionServerGroup
Restores timed out sessions to ACTIVE state after 60 seconds.
Subsequently, Disconnect or CoA requests can be resent. Each
UpdateTimedOutSessionsServerGroup
time a Disconnect or a CoA request for a session times out, the
session is disabled for 60 seconds. This SQL action is used only
when multiple HP-UX AAA Servers are configured as a group.
Checks the database for sessions for which the Disconnect or
CoA requests cannot be sent after updating the session_status
RestoreDroppedSessionsServerGroup
attribute. For example, if a HUP signal is received, all the requests
are purged from the queue. Under such circumstances, sessions
that are updated with DISCONNECT_INIT will not be processed
again. Checks in the database for such sessions ensure that the
sessions are restored to ACTIVE state. This SQL action is used only
when multiple HP-UX AAA Servers are configured as a group.
Sends an Access-Reject and disconnects a session if the session
is not found in the session table. If the session is found, this SQL
AuthorizeSession
action sends an Access-Accept to reauthorize the session with
a new Filter-Id value.
The dbsetup.sql.dynauth_server_group Sample File
The dbsetup.sql.dynauth_server_group sample file contains the SQL commands required
to create tables and stored procedures in the database server.
Table 68 lists the stored procedures and tables.
Table 68 Tables and Stored Procedures in the dbsetup.sql.dynauth_server_group File
DescriptionTables and Stored Procedures
Contains information related to the HP-UX AAA Servers that are
sharing the same database tables. This table is used to keep track
of the live HP-UX AAA Servers.
RAD_SERVER_TABLE
Updates the UPDATE_TIME value of the entry corresponding to the
HP-UX AAA Server passed in as argument, in the
update_server_table
240 Configuring the HP-UX AAA Server for Dynamic Authorization