Defining Your Query Databases in iManager

Before you can query a database, iManager needs to know where to find the data store and how to communicate with the database. This information is stored in the database definition. Every database you want to query must have its own database definition in iManager.

IMPORTANT: The database definitions you create in iManager are stored in the User object you use to log in to iManager. Consequently, they are not available to other users on the system.

To create a database definition in iManager:

1 Open the Query Options task.

NU) 01 February 2006 1a Click the Roles and Tasks button on the iManager toolbar.

1b In the Roles and Tasks view, expand the Auditing and Logging Role.

1c Click the Query Options task.

2 In the Query Options page, click Databases > New.

3 In the New Database Definition menu, specify the database information.

The following table provides a description of each field in the Database menu.

4 When finished, click OK.

The new database definition now appears in the Database Name list.

The following table provides a description of each field in the database definition.

Table 9-1 Database Definition Menu Fields

Field Description

Name The name you want to use to refer to this database.

This name appears in the Database Name list.

JDBC Class Package and name of the Java Class providing JDBC connectivity.

The JDBC drivers for the Nsure Audit supported data stores are available at the following sites:

• MySQL: MySQL Connector/J

The MySQL JDBC .jar file can be downloaded from the MySQL Development site (http://dev.mysql.com/downloads/).

• Oracle: Oracle Instant Client

The Oracle JDBC .jar file can be downloaded from the Oracle Web site (http://www.oracle.com/technology/tech/oci/instantclient/

instantclient.html).

• Microsoft SQL Server: Microsoft SQL Server Driver for JDBC

The SQL Server JDBC .jar file can be downloaded from the Microsoft Download Center (http://www.microsoft.com/downloads/).

• QL Server and Sybase JDBC Driver: jTDS (S)

The QL Server and Sybase JDBC .jar file can be downloaded from SourceForge.net (http://www.sourceforge.net/) site.

JDBC Class continued

You must copy the JDBC drivers for your data store to the following Nsure Audit Java classpath or a subdirectory thereof:

• Windows, Linux, and Solaris: Novell_Audit_install_

directory\java\logdriver\

• NetWare: Novell_Audit_install_directory\

Additionally, if you are going to query a JDBC data store in iManager, copy all required JDBC drivers (*.jar) to the following iManager classpaths on your iManager server:

• NetWare: sys:\tomcat\4\common\lib

• Linux and Solaris: /var/opt/novell/tomcat4/common/lib

NU) 01 February 2006

Editing and Deleting Database Definitions

After you have created a database definition, you can edit or delete the definition by selecting the database, then clicking Edit or Delete.

JDBC URL A valid JDBC URL, including the database name, that iManager uses to communicate with the database. Any JDBC-compliant driver can be used.The driver name is case sensitive.

Consult the documentation provided by your database vendor for specifics on constructing JDBC URLs. The following are JDBC URL examples for the most common databases using the default port. This database name must be replaced with the name of your Nsure Audit database, the default Nsure Audit database name is naudit.

• MySQL: jdbc:mysql://ip_address:port / database_name

• Oracle: jdbc:oracle:thin:@ip_address:port:sid

• Microsoft SQL Server: jdbc:microsoft:sqlserver://ip_address:port;

DatabaseName=database_name Table The name of the table iManager queries.

In Nsure Audit, table names are defined in MySQL and Oracle Channel objects. The default table name is log.

If you have multiple MySQL or Oracle Channel objects, you must create a separate database definition for each data store.

Username The user name iManager uses to authenticate with the database.

The default username for the NetWare 6.5 data store is auditusr. (This default can be changed during the installation of Nsure Audit.) This account has all privileges to the default database (naudit) and can log in from any IP address.

By default, MySQL installs in Secure Mode on NetWare 6.5. In Secure Mode, the default MySQL administrative account, Root, has rights to log in only at the database server. Therefore, if MySQL is running in Secure Mode and you want iManager to use the Root account to log in to the database, MySQL and the iManager Web server must be located on the same server and you must specify a loopback address (127.0.0.1 or localhost) in the Host field.

Password The password the logging server uses to authenticate with the database.

The default password for the NetWare 6.5 data store is auditpwd. (This default can be changed during the installation of Nsure Audit.)

IMPORTANT: If you do not specify a different default password during the installation, new databases can be created and accessed using the default username and password. To prevent this, specify a different default password during the install.

Store Password Stores the password the logging server uses to authenticate with the database. This enables iManager to automatically log in to the database.

If you do not select the Store Password option, you must specify the password each time you run a query on the current database.

Field Description

NU) 01 February 2006 NOTE: Deleting a database definition does not affect the actual database. It only removes the

database from the Query Options task’s Database list, which means that iManager can no longer query the database.