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

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

Aswani_Juvva — Tue, 24 Nov 2020 14:59:16 GMT

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!

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

sp2 — Wed, 25 Nov 2020 05:02:08 GMT

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

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

abhinavmishra14 — Wed, 25 Nov 2020 15:11:39 GMT

@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-compose-yml-alfresco-6-2-v-by/m-p/303376/highlight/true#M22194