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

Example 22-10 Remove Session Stored Procedure Definition
create or replace procedure remove_session(sessid IN
varchar2, ipaddr OUT NUMBER)
IS
BEGIN
select ASSIGNED_FRAMED_IP into ipaddr from RAD_SESS_TABLE
where session_id=sessid;
delete from RAD_SESS_TABLE where session_id=sessid;
END;
Run
Stored Procedure Call to remove_session in SQL Action:
SQLAction StopSession-DHCP {
{
input
RAD(Class) DBP(sessid, 254, CHAR)
output
DBR(-1:*) RET(ERROR)
DBP(ipaddr, 11, INT) FUNC(AAAFreeIP
DBR(0:0) RET(ACK)
DBR(*:*) RET(NAK)
SQLStatement db_oci {
BEGIN
remove_session( :sessid, :ipaddr );
END;
}
}
}
Administering Users and Tokens Stored in an SQL Database
The User Database Administration Manager is a web-based interface that enables
administrators to manage users that are stored in an SQL database. Using the interface,
administrators can add users, modify the credentials of existing users, and view user
and token information. Administrators can also use this tool to manage users with
tokens, required for OATH standards-based One Time Password (OTP) authentication.
The User Database Administration Manager has been created using PHP scripts that
enable administrators to easily customize this interface for specific deployment scenarios.
The PHP scripts are available in the /opt/aaa/examples/sqlaccess/userdb
directory.
You must set up the User Database Administration Manager and configure it with the
HP-UX Apache Web Server before following the procedures described in this section.
For configuration and set up procedures, see the /opt/aaa/examples/sqlaccess/
userdb/README file.
374 SQL Access