EABC Configurations

Follow these steps to configure EABC:

Navigate to <installation-dir>\hybrid-chat\core\tomcat\apache-tomcat-8.5.47\webapps\eabc\WEB-INF\classes\
Open application.groovy file with any text editor
Update configurations and save the file. There is no need to restart any service for it

Configuration

Sample application.groovy file

GROOVY

dataSource {
    logSql=System.getenv("LOG_SQL")
    pooled = true
    dbCreate = "update"
    url = System.getenv("DB_URL")?:"jdbc:jtds:sqlserver://192.168.2.238;instance=BNPTEST;DatabaseName=ChatServerQA"
    driverClassName = System.getenv("DB_DRIVER")?:"net.sourceforge.jtds.jdbc.Driver"
    dialect = System.getenv("DB_DIALECT")?:"org.hibernate.dialect.SQLServer2008Dialect"
    username = System.getenv("DB_USER")?:"sa"
    password = System.getenv("DB_PASS")?:"Expertflow464"
    properties {
        jmxEnabled = true
        initialSize = 5
        maxActive = 50
        minIdle = 5
        maxIdle = 25
        maxWait = 10000
        maxAge = 0
        timeBetweenEvictionRunsMillis = 5000
        minEvictableIdleTimeMillis = 60000
        validationQuery = "SELECT 1"
        validationQueryTimeout = 3
        validationInterval = 15000
        testOnBorrow = true
        testWhileIdle = true
        testOnReturn = false
        jdbcInterceptors = "ConnectionState;StatementCache(max=200)"
        defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
    }
}


primaryIP=System.getenv("PRIM_IP")?:"127.0.0.1"
secondaryIP=System.getenv("SEC_IP")?:"127.0.0.1"

tamPort=System.getenv("TAM_PORT")

Following table explains these parameters:

	Configuration Variable	Line Number	Default Value	Expected Value	Limitations	Description
1	DB_URL	5	jdbc:jtds:sqlserver://192.168.1.35:1433/eabc for default instance, Use following DB_URL value for named instance of MSSQL Server jdbc:jtds:sqlserver://serverurl;instance=INSTANCE_NAME;DatabaseName=eabc	String	/eabc at the end of string is the database name you created. Write host path in place of 192.168.1.35:1433 of default value	MSSQL database for EABC
2	DB_USER	8	sa	String		MSSQL Server Username
3	DB_PASS	9	Expertflow464	String		MSSQL Server Password
4	PRIM_IP	32	127.0.0.1	String		Primary IP of host machine
5	SEC_IP	33	127.0.0.1	String		Secondary IP of host machine