Please review your docker compose file, we usually use a basic docker compose like this one.
NOTE. use a .env file to setup the env variables instead of put this directly in the yml file
fineract-server:
image: org.mifos.backend:latest
restart: always
network_mode: host
extra_hosts:
- "fineractmysql:127.0.0.1"
ports:
- "8443:8443"
healthcheck:
test: "curl -kfsS
https://localhost:8443/fineract-provider/actuator/health | grep UP | wc -l"
timeout: 10s
retries: 10
environment:
- FINERACT_NODE_ID=1
- FINERACT_HIKARI_DRIVER_SOURCE_CLASS_NAME=com.mysql.cj.jdbc.Driver
- FINERACT_HIKARI_JDBC_URL=jdbc:mysql://fineractmysql:3306/fineract_tenants
- FINERACT_HIKARI_USERNAME=${DB_USER}
- FINERACT_HIKARI_PASSWORD=${DB_PASS}
- FINERACT_HIKARI_MINIMUM_IDLE=3
- FINERACT_HIKARI_MAXIMUM_POOL_SIZE=10
- FINERACT_HIKARI_IDLE_TIMEOUT=60000
- FINERACT_HIKARI_CONNECTION_TIMEOUT=20000
- FINERACT_HIKARI_TEST_QUERY=SELECT 1
- FINERACT_HIKARI_AUTO_COMMIT=true
- FINERACT_HIKARI_DS_PROPERTIES_CACHE_PREP_STMTS=true
- FINERACT_HIKARI_DS_PROPERTIES_PREP_STMT_CACHE_SIZE=250
- FINERACT_HIKARI_DS_PROPERTIES_PREP_STMT_CACHE_SQL_LIMIT=2048
- FINERACT_HIKARI_DS_PROPERTIES_USE_SERVER_PREP_STMTS=true
- FINERACT_HIKARI_DS_PROPERTIES_USE_LOCAL_SESSION_STATE=true
- FINERACT_HIKARI_DS_PROPERTIES_REWRITE_BATCHED_STATEMENTS=true
- FINERACT_HIKARI_DS_PROPERTIES_CACHE_RESULT_SET_METADATA=true
- FINERACT_HIKARI_DS_PROPERTIES_CACHE_SERVER_CONFIGURATION=true
- FINERACT_HIKARI_DS_PROPERTIES_ELIDE_SET_AUTO_COMMITS=true
- FINERACT_HIKARI_DS_PROPERTIES_MAINTAIN_TIME_STATS=false
- FINERACT_HIKARI_DS_PROPERTIES_LOG_SLOW_QUERIES=true
- FINERACT_HIKARI_DS_PROPERTIES_DUMP_QUERIES_IN_EXCEPTION=true
- FINERACT_DEFAULT_TENANTDB_HOSTNAME=fineractmysql
- FINERACT_DEFAULT_TENANTDB_PORT=3306
- FINERACT_DEFAULT_TENANTDB_UID=${DB_USER}
- FINERACT_DEFAULT_TENANTDB_PWD=${DB_PASS}
- FINERACT_DEFAULT_TENANTDB_CONN_PARAMS=serverTimezone=America/Mexico_City&useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&autoReconnect=true&useSSL=false
- FINERACT_DEFAULT_TENANTDB_TIMEZONE=America/Mexico_City
- FINERACT_DEFAULT_TENANTDB_IDENTIFIER=${TENANT_ID}
- FINERACT_DEFAULT_TENANTDB_NAME=fineract_${TENANT_ID}
- FINERACT_DEFAULT_TENANTDB_DESCRIPTION=Default Demo Tenant