Installation

Steps to install and configure the electronic document exchange application in OpenKM v8.1:

CREATE USER 'edx'@'%' IDENTIFIED BY 'openkm';
CREATE DATABASE edx DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
GRANT ALL ON edx.* TO 'edx'@'%' WITH GRANT OPTION;

• Stop Tomcat
• Download the application from OpenKM download center
• Place the edx.war file into $TOMCAT_HOME/webapps
• Place the edx-plugins.jar file into $TOMCAT_HOME/plugins
• This application needs to share the database with OpenKM, so you don't need to create a new one
• Create the configuration file $TOMCAT_HOME/edx.properties (this is a sample configuration that needs to be adapted to the target environment)

# Database
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver
spring.datasource.url=jdbc:mariadb://localhost:3306/okmdb?useUnicode=true&characterEncoding=UTF8
spring.datasource.username=openkm
spring.datasource.password=openkm

# JPA stuff
spring.jpa.hibernate.ddl-auto=create
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MariaDB106Dialect

# OpenKM
openkm.url=http://localhost:8080/openkm
openkm.url.preview=http://localhost:8080/openkm

# OpenKM admin user
admin.user=okmAdmin
admin.password=admin

# OpenKM edx user
edx.user=edxUsr
edx.password=s3cr3t0

# Available languages
languages=es-ES#Espa\u00f1ol,en-GB#English
default.language=en-GB

# Logging config
logging.level.com.openkm.edx=INFO

The openkm.url configuration property family is also important because EDX will use this user to interact with your OpenKM instance. So, configure a user with enough permissions. This user should already exist in OpenKM. 

• Start Tomcat
• Log into OpenKM
• Go to Administration > Users and create the user-defined at edx.user configuration property. This user will be used to connect to the OpenKM instance, so double check the username and password, and make sure this user has access to the EDX base folder (the one defined at edx.base.uuid configuration property)
• Go to Administration > Utilities > Database query and execute these SQL sentences to create some needed configuration properties:

insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.base.uuid', 'string', '');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.inbox.name', 'string', 'Inbox');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.public.name', 'string', 'Public');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.template.folder.inbox.uuid', 'string', '');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.template.folder.public.uuid', 'string', '');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.notification.email.subject', 'string', 'EDX Document notification');
insert into OKM_CONFIG (CFG_KEY, CFG_TYPE, CFG_VALUE) values ('edx.notification.email.body.uuid', 'string', '[uuid-of-the-html-document]');

• Set the configuration properties according to their usage:
  • edx.base.uuid: The base folder UUID where the other folders will be created.
  • edx.inbox.name: The name of the folder used to store the incoming documents. Only used if the edx.template.folder.inbox.uuid property does not exist or it's empty.
  • edx.public.name: The name of the folder used to store public documents. Only used if the edx.template.folder.public.uuid property does not exist or it's empty.
  • edx.template.folder.inbox.uuid: UUID's folder template creates the inbox folder structure.
  • edx.template.folder.public.uuid: UUID's folder template creates the public folder structure.
  • edx.notification.email.subject: Mail subject used in document notifications.
  • edx.notification.email.body.uuid: The UUID of the HTML document used in mail notification body.

•  Create these automations:
  

  Name	Event	At	Validation	Action
  EDX Doc Create	Document create	Post	PathContains = /okm:root	EDX Catalog
  EDX Doc Move Pre	Document move	Pre	PathContains = /okm:root	EDX Catalog
  EDX Doc Move Post	Document move	Post	PathContains = /okm:root	EDX Catalog
  EDX Doc Delete	Document delete	Pre	PathContains = /okm:root	EDX Catalog
  EDX Doc Update	Document update	Post	PathContains = /okm:root	EDX Catalog

• Once the application is configured, you can log in to http://server.ip:8080/edx with the default administrator:
  • User: admin
  • Password: admin
• Remember to change this default password!!

Configuration properties

These are common EDX configuation properties:

Configuration for other databases

Pending...