Installation

Initial Installation

Database

• Connect to the sbcs main database and create the mdh schema. Exit afterwards (e.g. using Ctrl+d)

  psql --host=localhost --user=sbcs --db=sbcs

  CREATE SCHEMA mdh;

Smart-BCS

• Install mdh and connectors

  apt install sbcs-mdh sbcs-mdh-ldap-connector sbcs-mdh-db-connector sbcs-mdh-alfresco-cmis-connector

• Edit the MDH configuration file at /etc/ecm4u/sbcs-mdh/config

  
  # Host of the DB server.
  MDH_DB_HOST=postgresql

Password to access the DB database.

MDH_DB_PASSWORD=3KS2AfjdnwZU9dVAk92dY7v7JeVfnoaTmffJ

Name of the DB database.

MDH_DB_DB=sbcs

Any options to append to the JDBC URL, must include a leading '?'.

MDH_DB_OPTIONS=currentSchema=mdh

* Install Java 8. We are using adoptOpenJDK.

wget -qO - https://adoptopenjdk.jfrog.io/adoptopenjdk/api/gpg/key/public | sudo apt-key add - sudo add-apt-repository --yes https://adoptopenjdk.jfrog.io/adoptopenjdk/deb/ apt install adoptopenjdk-8-hotspot-jre

* Create required tables in the `mdh` schema

sbcs-mdh-migrate migrate

* Start the Master Data Hub

systemctl start sbcs-mdh

## Upgrading

TODO