Chapter 4. Installation

Table of Contents

Data store setup
SQLite
MySQL
Main setup
Web server URL rewriting
Initial configuration
Security considerations
[Note]Note

This section applies only to first-time installation. If you are upgrading, skip to Chapter 5, Upgrading.

Data store setup

In contract to version 1.x, a data store is required in version 2.0. dmBridge currently supports two different data stores:

SQLite 3 (default)

A simple file-based database that is fast, reliable, and easy to configure. Recommended if you don't have access to a MySQL server.

[Caution]Caution

The SQLite database must reside on the local filesystem. SQLite will not work over an NFS or CIFS share.

MySQL 4.x and above

Requires the PHP PDO extension.

[Note]Note

PostgreSQL support was present in version 1.x, but has been removed in version 2 due to lack of use.

SQLite

SQLite is often pre-installed in many Linux distributions. If you are running Linux, search your system for an executable named sqlite. If that fails, check your package manager.

If SQLite is available, proceed to the section called “Main setup”. If not, you will have to download and install it manually; see the SQLite home page for more information.

MySQL

[Caution]Caution

The MySQL options is intended for organizations that already have a MySQL server set up and available, and have someone on staff who knows the basics of administering it. If this is not the case, you should use SQLite instead. Installation instructions for the MySQL database itself will not be provided here; we will assume it is already up and running at your site.

Configuring with PHP

MySQL requires the PHP PDO extension for use with dmBridge. To verify that this is installed, run phpinfo():

<?php phpinfo(); ?>

And search for a "PDO" section. If you don't also see a "pdo_mysql" or "pdo_sqlite" section (depending on your database), you will need to install the appropriate PDO driver. Depending on your operating system, this may be available as a package, or you may have to install it from PECL:

# pecl install pdo_mysql

Creating the database

dmBridge does not have a tool for creating the database itself; you will have to do this manually. However, you should not have to create the database tables; see the next section.

Enabling in dmBridge

The final step is to enter the database connection settings. This is done in config.ini by setting the necessary parameters beginning with database.

If the database does not already have the necessary tables, dmBridge will attempt to create them. If this should happen to fail for some reason, you must manually execute (and if necessary, tweak) one of the sample SQL scripts provided in the dm/includes/data/schema folder.