Getting the following error when hosted in a VM

[damithcl]

Getting the following error for the http://{IP}:2020/api/info call
500
{message: "Unexpected error occurred: d8f6add6-0b9d-443f-9b2b-fabdd8557d53"} message : "Unexpected error occurred: d8f6add6-0b9d-443f-9b2b-fabdd8557d53"

[ludeknovy]

Hi @damithcl was this happening rigth after you docker-composed' it up, or put differently, did it happen after you launched it?

[ludeknovy]

@damithcl Did you make it work?

[damithcl]

Not yet . it seems the SQL file has a permission issue in the container . When executed as a fresh copy it gives the SQL file permission denied error.

[ludeknovy]

@damithcl ah, ok, so this is not the application problem itself then. Have a look at docker volume permission issue - maybe here? https://mydeveloperplanet.com/2022/10/19/docker-files-and-volumes-permission-denied/

[damithcl]

Hi @ludeknovy , I have tried with adding the permission to Dockerfile but was not successful.Permission changes anre not persisting in the docker volume . For example I have tried like ,
FROM timescale/timescaledb:2.4.1-pg13 USER root ENV POSTGRES_DB jtl_report COPY --chown=user:user schema.sql /docker-entrypoint-initdb.d/ RUN chmod -R 765 /docker-entrypoint-initdb.d/

Finally I got it done via manually executing the sql within the container.
psql -U postgres -d jtl_report -a -f /docker-entrypoint-initdb.d/schema.sql

There may be a issue with Ubuntu 18.04 docker permissions but I m not sure . It all works fine in 20.04.

Thanks a lot for your tremendous support on this :)

[ludeknovy]

Hi @damithcl Glad you solved it after all!
If you happen to have any questions/ feedback, feel free to use the discussion section again.