Table of Contents
![[Note]](images/note.png) | Note |
|---|---|
|
This section applies only to first-time installation. If you are upgrading, skip to Chapter 5, Upgrading. |
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]](images/caution.png)
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 |
|---|---|
|
PostgreSQL support was present in version 1.x, but has been removed in version 2 due to lack of use. |
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.
| 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. |
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
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.
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.