Page tree
Skip to end of metadata
Go to start of metadata

Install Database Server

COmanage Match currently only supports PostgreSQL, version 9.1 or later, with the fuzzystrmatch module installed.

If building PostgreSQL from scratch, this module is available as part of world:

$ make world
# make install-world

If using a distribution, you will likely need to install the appropriate package. For Debian, the package is postgresql-contrib-x.y.

Set Up Database

Create a database and owner. (These can be named whatever you like.)

postgres=# create user match password 'somepass';
CREATE ROLE
postgres=# create database matchprod owner match;
CREATE DATABASE

Enable the fuzzystrmatch module. This needs to be done once per logical database.

postgres=# \c matchprod;
postgres=# create extension fuzzystrmatch;

Configure COmanage Match

Copy the file $MATCH/app/config/database.php.dist to local/Config/database.php. Edit the file with your database connection information.

Example database.php for PostgreSQL
<?php
 return [
  'Datasources' => [
   'default' => [
    'className' => 'Cake\Database\Connection',
    // Postgres is currently the only supported backend for COmanage Match
    'driver' => 'Cake\Database\Driver\Postgres',
    'host' => 'localhost',
    'username' => 'match',
    'password' => 'somepass',
    'database' => 'matchprod'
   ]
  ]
 ];

Next Step

Match Installation - Email