8.8 Planning the Vibe Database

OpenText Vibe database disk space requirements are relatively modest. Files that are imported into Vibe are saved in the Vibe file repository, as described in Install Location.

The Vibe database is primarily used for storing the following information:

  • Structural information about workspaces, folders, and entries (for example, their location in the workspace tree)

  • Identification information about workspaces, folders, and entries (for example, titles, descriptions, dates of creation/modification, and users associated with creation/modification)

  • User profile information (for example, full name, phone number, and email address)

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

8.8.1 Database Type

Vibe supports the following database types:

On Linux: MariaDB, MySQL, Oracle, and PostgreSQL

On Windows MariaDB, MySQL, Microsoft SQL, Oracle, and PostgreSQL

BASIC VIBE INSTALLATION SUMMARY SHEET

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

Ensure that a supported version of the database server, as listed in Database Server Requirements, is installed and running before you install Vibe.

8.8.2 Database Setup Method

You or your database administrator must manually create the Vibe database. This is a requirement, regardless of which type of database you are using.

Basic Setup

If you plan to deploy the Vibe database as a basic installation, with the database running on the same server as the Vibe software, you first install the Vibe software, and then create the database, as described in Section 11.0, Installing and Setting Up a Basic Vibe Site.

Remote Server Setup

If you plan to deploy the Vibe database on a remote server, follow the instructions in Section 19.0, Creating the Vibe Database on a Separate Server.

BASIC VIBE INSTALLATION SUMMARY SHEET

Under Database Setup Method, mark whether you are setting up the database as a basic installation (with the database running on the same server as the Vibe software), or whether you are performing a remote server setup, with the database server on a remote server.

8.8.3 Database Location

Creating the database on the same server where you install the Vibe software is the preferable location for your Basic installation. The default database name is sitescape (a reference to the company that previously developed the Vibe software).

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

You must decide before installation whether you want the database on the Vibe server or on a remote server. See Section 19.0, Creating the Vibe Database on a Separate Server.

Vibe 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 Vibe software, the default JDBC URL that provides localhost as the hostname of the Vibe 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 Vibe can communicate with the database server. The default port number depends on the database server you are using:

Database Server

Default Port Number

MySQL/MariaDB

3306

Microsoft SQL

1433

Oracle

1521

PostgreSQL

5432

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

BASIC VIBE 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 Vibe.

8.8.4 Database Credentials

When you have the Vibe Installation program create the database for you, it defaults to the following administrator user names for the database server:

Database

Default Administrative User Name

MySQL/MariaDB

root

IMPORTANT:The database root user name is not the same as the Linux root user on a Linux server.

Microsoft SQL

(no default) For a Microsoft SQL database, your database administrator establishes the administrator user name and password for the database server.

Oracle

(no default) For an Oracle database, your database administrator establishes the administrator user name and password for the database server.

PostgreSQL

postgres

For an Oracle database and Microsoft SQL database, your database administrator establishes the administrator user name and password for the database server.

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

BASIC VIBE INSTALLATION SUMMARY SHEET

Under Database Credentials, specify the administrator user name and password for the database server so that Vibe can access its database.

8.8.5 Database Encryption Algorithm

Different encryption algorithms provide differing encryption strength. The supported algorithms for encrypting the Vibe database password are listed below.

BASIC VIBE INSTALLATION SUMMARY SHEET

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