3.5 Planning the Teaming Database

Novell Teaming database disk space requirements are relatively modest. Files that are imported into Teaming are saved in the Teaming file repository, as described in Section 3.2.4, Teaming Installation Locations.

The Teaming database is primarily used for storing:

You or your database administrator must make the following decisions about the Teaming database:

3.5.1 Database Type

By default, Novell Teaming uses open source MySQL as its database on Linux and on Windows. On Linux, Teaming also supports Oracle. On Windows, Teaming also supports Microsoft SQL Server and Oracle.

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under Database Type, mark the type of database that you want to use with Teaming.

Make sure that a supported version of the database server, as listed in Section 2.1, Teaming Server Requirements, is installed and running before you install Teaming.

3.5.2 Database Setup Method

If you plan to use a MySQL database or a Microsoft SQL database, the Novell Teaming Installation program can automatically set up the database for you. This is the easiest way to get started.

If you plan to use an Oracle database, you must have your database administrator set up the database for you. Instructions for your database administrator are provided in Section 13.4, Creating an Oracle Database.

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under Database Setup Method, mark whether you want the Teaming Installation program to automatically set up a MySQL or Microsoft SQL database, or you need your database administrator to manually set up an Oracle database before you install Teaming.

3.5.3 Database Location

When you have the Novell Teaming Installation program create the database for you, the database is created on the same server where you install the Teaming software. This is the preferable location for your Basic installation. The default database name is sitescape, a reference to the company that previously developed the Teaming software.

Database Server

Default Linux Location

Default Windows Location

MySQL

/var/lib/mysql
c:\Documents and Settings\All Users\
                     Application Data\MySQL\
                     MySQL Server version\Data

Microsoft SQL

N/A

c:\Program Files\Microsoft SQL Server\
                                    MSSQL\Data

Oracle

N/A

N/A

You can have your database administrator create a database on a remote server later, after you have successfully tested your Basic installation. See Section 13.0, Creating the Teaming Database on a Remote Server.

If you need to have your database administrator create an Oracle database, you must decide before installation whether you want the database on the Teaming server or on a remote server. See Section 13.4, Creating an Oracle Database.

Teaming knows where to find its database from the JDBC* (Java Database Connectivity) URL that you provide during installation. For a database that is local to the Teaming software, the default JDBC URL that provides localhost as the hostname of the Teaming server is appropriate. If the database is on a remote server, the JDBC URL must provide the hostname of the remote database server.

The JDBC URL also includes the port number on which Teaming can communicate with the database server. The default port number depends on the database server you are using:

Database Server

Default Port Number

MySQL

3306

Microsoft SQL

1433

Oracle

1521

Use this port number unless it is already in use by another process on the database server.

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under JDBC URL, specify the appropriate hostname for the database server (localhost or the hostname of a remote server) and the port number it will use to communicate with Teaming.

3.5.4 Database Credentials

When you have the Novell Teaming Installation program create the database for you, it defaults to the following administrator usernames for the database server:

Database

Default Administrative Username

MySQL

root

IMPORTANT:The MySQL root username is not the same as the Linux root user on a Linux server.

Microsoft SQL

sa (system administrator)

Oracle

(no default)

For an Oracle database, your database administrator establishes the administrator username and password for the database server.

Check with your database administrator to see if the default administrator username is still in use for your database server, and obtain the administrator password for the database server before you run the Teaming Installation program.

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under Database Credentials, specify the administrator username and password for the database server so that Teaming can access its database.

3.5.5 Database Encryption Algorithm

Different encryption algorithms provide differing encryption strength. The supported algorithms for encrypting the Novell Teaming database password are listed below, in order from least strength to most strength.

  • MD5

  • SHA (default)

  • SHA-256

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under Database Encryption Algorithm, mark the encryption algorithm you want to use for Teaming passwords.