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

Table 71 Database Access Parameters (continued)
DescriptionDatabase Access Variable
libraries require the password to be specified in their configuration file.
These libraries ignore the DBPassword keyword.
Optional. Timer in seconds after which reconnection to the database is
attempted, when connection fails.
Default:
reconnect_wait_time
60
Optional: Comma separated native database error codes got if database
is unreachable or shutdown. Whenever the server gets any of these
reconnect_err_code
configured error code, it attempts to reconnect periodically at an interval
of reconnect_wait_time until the connection to database is successfully
established. No error codes are configured by default.
Required for OCI only. Identifies the Oracle database instance to connect
to. The supported format for this parameter is determined by the OCI client
software.
Oracle_db_instance
Required for ODBC only. Identifies the database instance to connect to.
The supported format for this parameter is determined by the ODBC driver
software.
ODBC_db_instance
Example 1 defines an instance of an Oracle database interface as db_oci with the connection
parameters. In the Oracle instance, the Server will attempt to reconnect after every 60 second, if
it gets ORA-3113 or ORA-3114 due to database access failures.
Example 1 Define the Oracle Database Connection Parameters
## Define the Oracle/OCI connection.
DBID db_oci {
DBClient OracleOCI
DBUser aaaoracleuser
DBPassword aaaoraclepassword
ReconnectWaitTime 60
ReconnectErrorCodes 3113,3114
OracleSID "example.db.com:1521/testdb"
}
Example 2 (page 257) defines an instance of an ODBC database interface as db_odbc with the
connection parameters:
Example 2 Define the MySQL Database Connection Parameters
## Define the MYSQL ODBC connection.
DBID db_odbc {
DBClient ODBC
DBUser mysqlaaauser
DBPassword mysqlaaapassword
ReconnectWaitTime 30
ReconnectErrorCodes 2006
ODBCDatastore RadiusStore
}
SQL Actions
SQL actions are defined in the data structure identified by the keyword SQLAction.
Following is the syntax of the SQLAction data structure:
Implementing SQL Access 257