How to point to the external database while installing Alfresco 6.2 V with docker-compose file

[Aswani_Juvva]

Hi,

I need to install the alfresco 6.2 V with docker-compose.yml file and needs to config with external db which is installed in another host machine.

Eg: I need to install the alfresco in 192.160.3.4 and my postgres db is hosted in 192.160.5.19.

and I need to point to this database instead of -Ddb.url=jdbcostgresql://postgres:5555/alfresco

Instead of

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=alfresco
-Ddb.password=alfresco
-Ddb.url=jdbcostgresql://postgres:5555/alfresco

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

can anyone help me out how to do this.

Thanks in adavance!

[sanjaybandhniya]

Please check refer this thread : https://hub.alfresco.com/t5/alfresco-content-services-forum/deploy-alfresco-with-docker-and-mysql/td...

[abhinavmishra14]

---

@Aswani_Juvva wrote:

Hi,

I need to install the alfresco 6.2 V with docker-compose.yml file and needs to config with external db which is installed in another host machine.

Eg: I need to install the alfresco in 192.160.3.4 and my postgres db is hosted in 192.160.5.19.

and I need to point to this database instead of -Ddb.url=jdbcostgresql://postgres:5555/alfresco

Instead of

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=alfresco
-Ddb.password=alfresco
-Ddb.url=jdbcostgresql://postgres:5555/alfresco

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

can anyone help me out how to do this.

Thanks in adavance!

---

Check this thread: https://hub.alfresco.com/t5/alfresco-content-services-forum/facing-issue-while-running-docker-compos...