1.4 Database Configuration

1.4.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)

1.4.2 Changing Database Configuration Settings

Changing the Database Configuration Settings for a Small Installation

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

    You can modify the following configuration options:

    Database Type: Filr uses a MySQL database in a small installation. 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. In a small installation, this is localhost.

    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.

    User Name: The user name for your MySQL database. For more information, see Section 1.4.5, Database Credentials.

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

  2. Click OK, then click Reconfigure Filr Server for your changes to take effect.

    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, it is recommended that you use your organization’s existing MySQL or Microsoft SQL database as the Filr database.

Alternatively, you can use the MySQL database appliance that ships with Filr as the Filr database. You modify the configuration settings of the MySQL database appliance as described in Configuring and Maintaining the MySQL Database Appliance in the Novell Filr 1.1 Installation and Configuration Guide.

1.4.3 Database Type

Filr can be configured to use a MySQL or Microsoft SQL database in a large deployment. In a small deployment, Filr uses a MySQL database.

1.4.4 Database Location in a Small Deployment

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

Database Server

Default Location

MySQL

/vastorage/mysql

1.4.5 Database Credentials

The MySQL database defaults to root for the administrative user name.

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