03-21-2022 11:31 AM
Good afternoon.
I recently joined a company where there is a department that uses Alfresco.
I have a problem doing the "run.bat build_start" of the project that is running, everything goes well until almost the end when it must create the "alfresco" and "activiti" databases in Docker, it just doesn't create them and it gives me the error "FATAL: database "alfresco" does not exist".
I must point out that the Alfresco colleagues who have been working for longer are doing well and have been working on this for months and years, but in my case it doesn't work for me, I don't know if it's because of the ports or configuration.
I attached an image of the error in question, there are times when instead of saying "FATAL: database "alfresco" does not exist" it says "FATAL: database "activiti" does not exist".
I emphasize that I am doing the "run.bat build_start" of the main repository of the project in which other people are working and everything works correctly, but neither those people nor the team leader know why this happens to me.
Just in case, the Postgres part of the "docker-compose.yml" file is as follows:
acs-postgres: image: postgres:9.6 mem_limit: 2g environment: POSTGRES_MULTIPLE_DATABASES: alfresco,activiti POSTGRES_USER: postgres POSTGRES_PASSWORD: postgres command: postgres -c max_connections=300 -c log_min_messages=LOG ports: - "${postgres.port}:5432" volumes: - acs-db-volume:/var/lib/postgresql/data - ./pg-init-scripts:/docker-entrypoint-initdb.d
We have tried a thousand things, port issues, etc. and there is no way. If someone can know what happens I would greatly appreciate it because there are many things to do with the projects. I am available to give more information if necessary to solve my problem.
03-22-2022 12:25 AM
You database creation is not happening properly. Permission might be the issue.
03-22-2022 05:25 AM
I would start from checking the initialisation scripts in this folder:
./pg-init-scripts
It's not Alfresco, it's your project scripts. Check how it works.
To do so, you can run only postgres service separately
docker-compose up -d acs-postgres
And check it logs
docker-compose logs -f
Share the scripts and resoults here.
Explore our Alfresco products with the links below. Use labels to filter content by product module.