Installation

Configurar Smart Forms

Pasos para instalar y configurar Smart Forms en OpenKM v8.2:

Descomprima el ZIP de Smart Forms.
Cree la base de datos:

CREATE DATABASE smartforms DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER 'smartforms'@'%' IDENTIFIED BY 'choose-any-pass';
GRANT ALL ON smartforms.* TO 'smartforms'@'%' WITH GRANT OPTION;

Cree el fichero de configuración $TOMCAT_HOME/smart-forms.properties

# DataSource - MariaDB
spring.datasource.url=jdbc:mariadb://localhost:3306/smartforms?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
spring.datasource.username=smartforms
spring.datasource.password=smartforms
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver

spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MariaDBDialect

# OpenKM integration
openkm.rest.url=http://localhost:8080/openkm
openkm.rest.user=okmAdmin
openkm.rest.password=choose-any-pass

Pare Tomcat, copie el fichero smart-forms.war en $TOMCAT_HOME/webapps (en el mismo Tomcat donde está desplegado OpenKM v8.2) y vuelva a iniciar Tomcat.

Configurar la base de datos

Configurar MariaDB

Cree la base de datos:

CREATE DATABASE smartforms DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER 'smartforms'@'%' IDENTIFIED BY 'choose-any-pass';
GRANT ALL ON smartforms.* TO 'smartforms'@'%' WITH GRANT OPTION;

Cree el fichero de configuración $TOMCAT_HOME/smart-forms.properties

# DataSource - MariaDB
spring.datasource.url=jdbc:mariadb://localhost:3306/smartforms?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
spring.datasource.username=smartforms
spring.datasource.password=smartforms
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver

spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MariaDBDialect

# OpenKM integration
openkm.rest.url=http://localhost:8080/openkm
openkm.rest.user=okmAdmin
openkm.rest.password=choose-any-pass

Configurar PostgreSQL

Cree una base de datos

DROP DATABASE IF EXISTS smartforms;
CREATE USER smartforms WITH PASSWORD 'choose-any-pass';
CREATE DATABASE smartforms WITH OWNER smartforms ENCODING 'UTF8';

O use la línea de comandos.

$ createuser --pwprompt smartforms
$ createdb --owner=smartforms --encoding=UTF8 smartforms

Cree el fichero de configuración $TOMCAT_HOME/smart-forms.properties

# DataSource - PostgreSQL
spring.datasource.url=jdbc:postgresql://localhost:5432/smartforms
spring.datasource.username=smartforms
spring.datasource.password=smartforms
spring.datasource.driver-class-name=org.postgresql.Driver

spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

# OpenKM integration
openkm.rest.url=http://localhost:8080/openkm
openkm.rest.user=okmAdmin
openkm.rest.password=choose-any-pass