Installation

Initial Installation

Database

  • Connect to the sbcs main database and create the rs schema. Exit afterwards (e.g. using Ctrl+d)
    psql --host=localhost --user=sbcs --db=sbcs
    CREATE SCHEMA rs;

Smart-BCS

  • Install the Resource Service
    apt install sbcs-rs
  • Edit the Resource Service configuration file at /etc/ecm4u/sbcs-rs/config
    
    # URL context clients should use to access the Resource server.
    RS_CONTEXT=

Host of the DB server.

RS_DB_HOST=postgresql

Name of the DB database.

RS_DB_DB=sbcs

Password to access the DB database.

RS_DB_PASSWORD=3KS2AfjdnwZU9dVAk92dY7v7JeVfnoaTmffJ

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

RS_DB_OPTIONS=currentSchema=rs

* Create required tables in the `rs` schema

sbcs-rs-migrate migrate

* Create a new connector configuration at `/etc/ecm4u/sbcs-rs/connectorConfiguration.json`. This configuration describes the possible resource backends. You can add several connecotrs to this configuration
    * Use the Managed File Connector to locally store documents.
    "managedHdd" : {
        "default" : true,
        "connectorClass" : "de.ecm4u.rs.connector.ManagedFileConnector",
        "rootFolder" : "/etc/ecm4u/rs/content",
        "property-mapping": {
            "name": "name",
            "size": "size",
            "modified": "modified",
            "created": "created"
        }
    }
```
* Use the Alfresco Connector to store documents in Alfresco. Change this configuration to fit your environment.
```
"http://alfrescohost/" : {
    "default" : false,
    "connectorClass" : "de.ecm4u.rs.connector.AlfrescoResourceConnector",
    "host" : "https://alfrescohost",
    "username": "user",
    "password": "password",
    "property-mapping": {
        "name": "name",
        "title": "title",
        "size": "size",
        "modifiedOn": "modified"
    }

}

* Start the Resource Service

systemctl start sbcs-rs



## Upgrading

TODO