ECM Environment Variables

Following are the environment variables used in the ecm service. ECM can is compatible with MSSQL and MySql as well. Please change the variables according to the database used. 

If MSSQL is used, create The database first with the name of "ecm" on the database server.


Config Parameter

Expected Value

Notes

ECM_DB_DIALECT



For MySQL: org.hibernate.dialect.MySQL5InnoDBDialect

For MSSQL: org.hibernate.dialect.SQLServer2008Dialect

Dilect for MySQL and MSSQL


ECM_DB_DRIVER



For MySQL: com.mysql.jdbc.Driver

For MSSQL: net.sourceforge.jtds.jdbc.Driver

Driver used for MySQL and MSSQL

ECM_DB_PASS

root

Database user. If you are using MSSQL, set the user who have permission on the database

ECM_DB_URL

for MySQL: jdbc:mysql://mysql:3306/ecm

for MSSQL: jdbc:jtds:sqlserver://<FDQN>:<Port>/ecm


ECM_DB_USER

root


TZ

Time zone where solution is being deployed.

e.g. "Europe/Zurich" if solution is deployed in Switzerland. See what is your time zone.

CHAT_API_URLhttp://<fqdn>/chat/api/external/message
GAT_URLhttps://<fqdn>/umm
ECM_URLhttp://<fqdn>/ecm/prompt
PROMPT_URLhttps://<fqdn>/ecm
DATABASE_ENGINE12.3
ECM_MODE

for MySql: mysql

For MSSQL: mssql


IMPORT_ENABLEDNO
SYNC_ENABLEDNO
SYNC_SCHEDULE0 0/1 * 1/1 * ? *
IMPORT_SCHEDULE0 0/3 * 1/1 * ? *
FEED_SCHEDULE0 0/1 * 1/1 * ? *
CISCO_DB_URLjdbc:jtds:sqlserver://<host-ip>:1433/ucce_awdb
CISCO_DB_USERsa
CISCO_DB_PASSWORD

MIN_IDLE

MAX_IDLE

MAX_ACTIVE

ACTIVE_MQ_ENABLED

ACTIVEMQ_BROKER_URL

ACTIVEMQ_BROKER_USER

ACTIVEMQ_BROKER_PASSWORD

UCCE_SHARED_PATH_DOMAIN

UCCE_SHARED_PATH_USER

UCCE_SHARED_PATH_PASSWORD

UCCE_SHARED_PATH_IP