4.3 Database Configuration

4.3.1 Understanding Database Configuration

Novell Filr database disk space requirements are relatively modest. Files that are imported into Filr are saved in the Filr file repository.

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

  • Structural information about folders and files

  • Identification information about folders and files (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)

4.3.2 Changing Database Configuration Settings

Changing the Database Configuration Settings for a Small Installation

  1. Follow the steps in Section 4.1, Changing Configuration Options for the Filr Appliance.

    You can modify the following configuration options:

    Database Type: Filr uses a MySQL database. You cannot use another type of database.

    Host Name or IP Address: Host name or IP address of the MySQL appliance if MySQL is not running on the Filr appliance.

    Port: The JDBC URL also includes the port number on which Filr can communicate with the database server. The default port number for MySQL is 3306. Use this port number unless it is already in use by another process on the database server.

    Username: The username for your MySQL database. For more information, see Section 4.3.5, Database Credentials.

    Password: The password for your MySQL database. For more information, see Section 4.3.5, Database Credentials.

  2. Click Reconfigure Filr Server for your changes to take effect.

    NOTE:This stops and restarts your Filr server. Because this results in server downtime, you should restart the server at off-peak hours.

Changing the Database Configuration Settings for a Large Installation

If your Filr site is configured for a large installation (your MySQL database is a stand-alone appliance), you modify the configuration settings as described in Section 6.0, Configuring and Maintaining the MySQL Database Appliance.

4.3.3 Database Type

Filr uses a MySQL database. This is the only supported database for Filr 1.0.

4.3.4 Database Location

When you install a single virtual appliance for a small installation, all components are on the same appliance. This is the preferable location for a small installation. The default database name is filr.

Database Server

Default Location

MySQL

 
/vastorage/mysql

4.3.5 Database Credentials

The MySQL database defaults to root for the administrative username.

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