Install Database Server

COmanage Match currently only supports PostgreSQL, with the fuzzystrmatch module installed. A supported version of PostgreSQL should be used; versions early than 9.5 are known to not be compatible with Match.

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.

<?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