test

Sun OpenSSO Enterprise 8.0 Technical Overview

Relational Database Format

When OpenSSO Enterprise uses a relational database to log messages, the messages are stored in a database table. OpenSSO Enterprise uses Java Database Connectivity (JDBC), which provides connectivity to a wide range of databases. (Oracle® and MySQL databases are currently supported.) Table 15–2 summarizes the schema for a relational database.

Table 15–2 Relational Database Log Format

Column Name 

Data Type 

Description 

 
TIME

Date (Oracle) 

DateTime (MySQL) 

The format is YYYY-MM-DD HH24:MI:SS (Oracle) or %Y-%m-%d %H:%i:%s (MySQL). The formats are specified in the Logging Service attributes. 

 
DATA

CLOB (Oracle) 

LONGTEXT (MySQL) 

The data type is specified in the Logging Service attributes. 

 
MODULENAME

VARCHAR(255) 

Name of the OpenSSO Enterprise component invoking the log record. 

 
DOMAIN

VARCHAR(255) 

OpenSSO Enterprise domain of the user. 

 
LOGLEVEL

VARCHAR(255) 

JDK 1.4 log level of the log record. 

 
LOGINID

VARCHAR(255) 

Login ID of the user who performed the logged operation. 

 
IPADDR

VARCHAR(255) 

IP Address of the machine from which the logged operation was performed. 

 
LOGGEDBY

VARCHAR(255) 

Login ID of the user who writes the log record. 

 
HOSTNAME

VARCHAR(255) 

Host name of machine from which the logged operation was performed. 

 
MESSAGEID

VARCHAR(255) 

Non-internationalized message identifier for this log record's message. 

 
CONTEXTID

VARCHAR(255) 

Identifier associated with a particular login session.