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
:
|
If using a distribution, you will likely need to install the appropriate package. For Debian, the package is postgresql-contrib-x.y
.
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; |
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' ] ] ]; |