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' ] ] ];