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

Table Of Contents
procedures determine the list of sessions to which Disconnect and CoA requests
must be sent, and ensure that the requests are distributed among the live HP-UX
AAA Servers. The RAD_SERVER_TABLE is used to determine the list of live HP-UX
AAA Servers.
For more information on these stored procedures and tables, see the following:
For Oracle — /opt/aaa/examples/sqlaccess/oracle-1/
dbsetup.sql.dynauth_server_group
For MySQL — /opt/aaa/examples/sqlaccess/mysql-1/
dbsetup.sql.dynauth_server_group
Configuring for Disconnect and CoA Request Processing
This section describes the procedure to configure all the HP-UX AAA Servers in a group
to perform authentication, accounting, and dynamic authorization. To dedicate some
HP-UX AAA Servers in a group for dynamic authorization, see “Dedicated HP-UX
AAA Servers for Dynamic Authorization” (page 311).
To configure for Disconnect and CoA request processing when multiple HP-UX
AAA Servers belong to a group, complete the following steps:
1. Configure the HP-UX AAA Server to enable session management using SQL.
For information on how to enable session management using SQL, see Chapter 22
(page 338)
2. Retrieve a copy of the dbsetup.sql.dynauth_server_group script from the
following directories and store it in the /tmp directory on the database system:
For Oracle — /opt/aaa/examples/sqlaccess/oracle-1/
dbsetup.sql.dynauth_server_group
For MySQL — /opt/aaa/examples/sqlaccess/mysql-1/
dbsetup.sql.dynauth_server_group
3. To create the necessary tables and stored procedures, you must execute the script.
For Oracle, enter the following command at the SQL prompt:
SQL> @ /tmp/dbsetup.sql.dynauth_server_group
For MySQL, enter the following command at the mysql prompt:
mysql> source /tmp/dbsetup.sql.dynauth_server_group
4. Replace <groupname> with the name of the group and append the required
SQLActions.
For Oracle, enter the following command at the prompt:
$ sed "s/<groupname>/test_group/g"
/opt/aaa/examples/sqlaccess/oracle-1/sqlaccess.config.dynauth_server_group
>> /etc/opt/aaa/sqlaccess.config
For MySQL, enter the following command at the prompt:
306 Configuring the HP-UX AAA Server for Dynamic Authorization