Help banner

Query Options - Databases

The Database page allows you to create, edit, and delete database definitions.

 

Creating Database Definitions

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 are stored in the User object you use to log in to iManager. Therefore, they are not available to other users on the system.

To create a database definition:

  1. Click New.

  2. Define the database options.

  3. When finished, click OK.

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

 

Editing Database Definitions

To modify an existing database definition:

  1. Select the database you want to modify.

  2. Click Edit.

  3. Modify the database options.

  4. When finished, click OK.

 

Deleting Database Definitions

To delete an existing database definition, select the check box next to the database name and click Delete. The database definition is removed from the Database Name list.

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 iManager can no longer query the database.

 

Database Options

Item

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 Java archive file (.jar) containing the JDBC class must be located in the
iManager class path. On NetWareŽ, this is sys:\tomcat\4\common\lib. On Linux*, it is /var/opt/novell/tomcat4/common/lib.

The following examples contain the JDBC class provided by the manufacturer for the most common databases:

  • MySQL*: com.mysql.jdbc.Driver

    The MySQL JDBC jar file can be downloaded from http://dev.mysql.com/downloads/. Search for the "MySQL Connector/J" file.

    The Java archive file (i.e., mysql-connector-java-3.1.10-bin.jar) containing this JDBC class must be manually copied to the iManager class path. Failure to manually copy this file will result in the error "Could not find the Driver Class: com.mysql.jdbc.Driver" when attempting to run a built-in query.

  • Oracle*: oracle.jdbc.driver.OracleDriver

    The Oracle JDBC jar file can be downloaded from Oracle (http://otn.oracle.com/software/tech/ java/sqlj_jdbc/index.html). This file must be in the classpath of your iManager server.

  • SQL Server: com.microsoft.jdbc.sqlserver.SQLServerDriver

    The SQL Server JDBC jar file can be downloaded from the Microsoft Download Center (http:// www.microsoft.com/downloads/search.asp). This file must be in the classpath of your iManager server.

  •  

JDBC URL

The JDBC URL that iManager uses to communicate with the MySQL database. This URL should contain a port if using a non-standard port, and the database name.

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 Novell® Audit database. The default Novell Audit database name is naudit.

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

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

  • SQL Server: jdbc:microsoft:sqlserver://ip_address:port; DatabaseName=database_name

 

Table

The name of the table iManager queries.

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

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 Novell 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 Novell 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 enter the password each time you run a query on the current database.

 

Related Topics

Configuring Query Options

Running Queries and Event Verifications

Novell Audit Help

A trademark symbol (®, ™, etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.

Close