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

1. Retrieve a copy of the dbsetup.sql.dynauth_server_group script from the
following locations 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
2. 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
3. Copy sqlaccess.config.
For Oracle, enter the following command at the prompt:
$ cp /opt/aaa/examples/sqlaccess/oracle-1/sqlaccess.config
/etc/opt/aaa/sqlaccess.config
For MySQL, enter the following command at the prompt:
$ cp /opt/aaa/examples/sqlaccess/mysql-1/sqlaccess.config
/etc/opt/aaa/sqlaccess.config
4. Configure the Database Connection (DBID) section in /etc/opt/aaa/
sqlaccess.config.
• For Oracle — In the Database Connection (DBID) section of
sqlaccess.config file, replace <aaaoracleuser>,
<aaaoracleuserpassword>, <hostname>, <port>, and <SID> ,
with the Oracle username, password, hostname on which database is installed,
database server port number, and OracleSID.
• For MySQL — In the Database Connection (DBID) section of the
sqlaccess.config file, replace the variables <mysqlaaauser> and
<mysqlaaauserpassword> with the MySQL username and password, and
set ODBCDatastore to the ODBC Data Source.
5. Append the required SQLActions after replacing <groupname> with the name of
the group.
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:
Configuring for Dynamic Authorization 307