Facing Issue while running docker-compose.yml -Alfresco 6.2 V by config external postgres DB

Aswani_Juvva

Hi, After satrting the server for the below docker-compose file i'm getting error

below is my docker-compose file.

version: "2"

services:
alfresco:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/alfresco
args:
ACS_TAG: 6.2.1-A8
mem_limit: 1500m
environment:
CATALINA_OPTS : "-agentlib:jdwp=transport=dt_socket,address=*:7000,server=y,suspend=n"
JAVA_OPTS: "
-Ddb.driver=org.postgresql.Driver
-Ddb.username=postgres
-Ddb.password=postgres@123
-Ddb.url=jdbcostgresql://192.160.89.5:5432/postgres
-Dsolr.host=solr6
-Dsolr.port=9999
-Dsolr.secureComms=none
-Dsolr.base.url=/solr
-Dindex.subsystem.name=solr6
-Dshare.host=127.0.0.1
-Dshare.port=7080
-Dalfresco.host=localhost
-Dalfresco.port=7080
-Daos.baseUrlOverwrite=http://localhost:7080/alfresco/aos
-Dmessaging.broker.url=\"failovernio://activemq:61616)?timeout=3000&jms.useCompression=true\"
-Ddeployment.method=DOCKER_COMPOSE

-DlocalTransform.core-aio.url=http://transform-core-aio:8090/

-Dalfresco-pdf-renderer.url=http://transform-core-aio:8090/
-Djodconverter.url=http://transform-core-aio:8090/
-Dimg.url=http://transform-core-aio:8090/
-Dtika.url=http://transform-core-aio:8090/
-Dtransform.misc.url=http://transform-core-aio:8090/

-Dcsrf.filter.enabled=false
-Xms1500m -Xmx1500m
"
volumes:
- acs-volume:/usr/local/tomcat/alf_data
depends_on:
- postgres
- solr6

transform-core-aio:
image: alfresco/alfresco-transform-core-aio:2.3.2
mem_limit: 1536m
environment:
JAVA_OPTS: " -Xms256m -Xmx1536m"
ports:
- 8090:8090

share:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/share
args:
SHARE_TAG: 6.2.1
mem_limit: 1g
environment:
REPO_HOST: "alfresco"
REPO_PORT: "7080"
CATALINA_OPTS : "-agentlib:jdwp=transport=dt_socket,address=*:7000,server=y,suspend=n"
JAVA_OPTS: "
-Xms500m
-Xmx500m
-Dalfresco.host=localhost
-Dalfresco.port=7080
-Dalfresco.context=alfresco
-Dalfresco.protocol=http
"

postgres:
image: postgres:13.0
mem_limit: 512m
environment:
- POSTGRES_PASSWORD=postgres@123
- POSTGRES_USER=postgres
- POSTGRES_DB=postgres
command: postgres -c max_connections=300 -c log_min_messages=LOG -p 5432
ports:
- 5432:5432
volumes:
- db-volume:/var/lib/postgresql/data

solr6:
image: alfresco/alfresco-search-services:1.4.2.2
mem_limit: 2g
environment:
#Solr needs to know how to register itself with Alfresco
- SOLR_ALFRESCO_HOST=alfresco
- SOLR_ALFRESCO_PORT=7080
#Solr jetty port, to start solr6 on port 9999
- SOLR_PORT=9999
#Alfresco needs to know how to call solr
- SOLR_SOLR_HOST=solr6
- SOLR_SOLR_PORT=9999
#Create the default alfresco and archive cores
- SOLR_CREATE_ALFRESCO_DEFAULTS=alfresco,archive
#HTTP by default
- ALFRESCO_SECURE_COMMS=none
- "SOLR_JAVA_MEM=-Xms2g -Xmx2g"

ports:
- 8083:9999 #Browser port
volumes:
- ass-volume:/opt/alfresco-search-services/contentstore
- ass-volume:/opt/alfresco-search-services/data

activemq:
image: alfresco/alfresco-activemq:5.15.8
mem_limit: 1g
ports:
- 8161:8161 # Web Console
- 5672:5672 # AMQP
- 61616:61616 # OpenWire
- 61613:61613 # STOMP

proxy:
build:
dockerfile: ./Dockerfile
context: ./configs-to-override/proxy
args:
NGNIX_TAG: 1.0.0
mem_limit: 256m
depends_on:
- alfresco
ports:
- 7080:7080
links:
- alfresco
- share

volumes:
acs-volume:
external: true
db-volume:
external: true
ass-volume:
external: true

Aswani_Juvva

Hi Abhinav,

Thanks for your responce!

It is not pointing to the external database!

The issue got resolved, here mistake was in alfresco service I'm pointing to the external database and at the same time I'm trying to create the database by below config in docker-compose file 

postgres:
image: postgres:13.0
mem_limit: 512m
environment:
- POSTGRES_PASSWORD=postgres@123
- POSTGRES_USER=postgres
- POSTGRES_DB=postgres
command: postgres -c max_connections=300 -c log_min_messages=LOG -p 5432
ports:
- 5432:5432
volumes:
- db-volume:/var/lib/postgresql/data

it worked, after removing the postgres service!

And here I have one more doubt.. when we are pointing to external database and  how to ensure that whether we are pointing to the 'dir.root' property is pointing to the correct data location.