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

2. To insert values in the new columns while creating a session, modify the
StartSession SQL action. Following is the list of new columns in the session
table, and their corresponding values:
1. session_timeout — Specifies the value configured in the
Session-Timeout attribute. You can configure the Session-Timeout
attribute using either the user profile or through policy. The following mapping
is used to insert this value:
• For Oracle,
RAD(Session-Timeout, REPLY) DBP(sess_timeout, 11, INT)
• For MySQL,
RAD(Session-Timeout, REPLY) DBP(9, 11, INT)
2. from_host — Specifies the host from which the authentication request was
received. The get_from_host mapping function retrieves this value. The
following mapping is used to insert this value:
• For Oracle,
FUNC(get_from_host) DBP(from_host, 253, CHAR)
• For MySQL,
FUNC(get_from_host) DBP(10, 253, CHAR)
3. session_status — Specifies the status of the session. The initial state is set
to <server_name>_ACTIVE. The get_server_name mapping function
retrieves a unique value for <server_name>. The following mapping is used
to insert this value:
• For Oracle,
FUNC(get_server_name) DBP(server_name, 259, CHAR)
• For MySQL,
FUNC(get_server_name) DBP(11, 259, CHAR)
4. sess_mod_time — Specifies the time when the session entry was modified.
The initial value is Current timestamp. This column does not require
mapping. The current_timestamp function is directly used in the SQL
statement.
5. filter_id — Specifies the data filter used for this session. The value is
retrieved from the Filter-Id attribute. You can configure Filter-Id using
either the user profile or through policy. The following mapping is used to
insert this value:
• For Oracle,
RAD(Filter-Id, REPLY) DBP(filterid, 253, CHAR)
• For MySQL,
RAD(Filter-Id, REPLY) DBP(12, 253, CHAR)
298 Configuring the HP-UX AAA Server for Dynamic Authorization