Breadcrumbs

EABC Configurations

Follow these steps to configure EABC:

  1. Navigate to <installation-dir>\hybrid-chat\core\tomcat\apache-tomcat-8.5.47\webapps\eabc\WEB-INF\classes\ 

  2. Open application.groovy  file with any text editor

  3. 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