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

Table Of Contents
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 20-3 lists the stored procedures and tables.
Table 20-3 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
RAD_SERVER_TABLE. If an entry for the server is not
available in the table, an entry is added in the table.
Distributes those expired sessions that need to be
disconnected among the live HP-UX AAA Servers of a
distribute_disconnect_sessions
group, for Disconnect request processing. The number of
expired sessions is retrieved from the RAD_SESS_TABLE
based on the session_timeout value configured for the
sessions. The number of live HP-UX AAA Servers is obtained
from the RAD_SERVER_TABLE based on the UPDATE_TIME
value. The sessions are assigned to the servers by setting the
SESSION_STATUS to <groupname>_DISCONNECT. The
number of expired sessions for Disconnect processing
assigned to each server is equal to ((number of
sessions/number of servers) + 1). If an HP-UX AAA Server
is down, because the UPDATE_TIME in the
RAD_SERVER_TABLE was not updated for some time, the
assigned sessions are reset to the ACTIVE state to ensure
that the sessions are assigned to one of the live HP-UX AAA
Servers.
Distributes those sessions that need to be changed among
the liveHP-UX AAA Servers of a group, for CoA request
distribute_coa_sessions
processing. The number of sessions is retrieved from the
RAD_SESS_TABLE. The number of live HP-UX AAA Servers
is obtained from the RAD_SERVER_TABLE based on the
UPDATE_TIME value. The sessions are assigned to the
servers by setting the SESSION_STATUS to
<groupname>_CoA. The number of expired sessions for
CoA processing assigned to each server is equal to ((number
of sessions/number of servers) + 1). If an HP-UX AAA Server
is down, because the UPDATE_TIME in the
RAD_SERVER_TABLE was not updated for some time, the
assigned sessions are reset to the ACTIVE state to ensure
that the sessions are assigned to one of the live HP-UX AAA
Servers.
Sample Configuration Files 331