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

Example 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.
This section discusses the following topics:
• “Managing Users” (page 274)
• “Managing Users Using OTP to Authenticate” (page 277)
Managing Users
This section discusses the following topics:
• “Adding Users to an SQL Database” (page 275)
• “Modifying User Credentials” (page 276)
• “Viewing User and Token Statistics” (page 280)
274 SQL Access