I am creating a Docker container for my umbrella app that so far contains just one phoenix API app. This application has simply one DB table that is made of political parties, called “parties”. when I run docker-compose up and visit http://localhost:4001/api/v1/parties I get the following error: E…

No, use the hostname postgres to connect to the database rather than an IP that you’ll never know if it will be correct after the next restart of the database. Never rely on IPs inside of your composed network, only ever use the service names, docker provides a DNS under the hood that will let them…

When you build the container, the database does not run. The build of your container should fail. You need to move creating and migrating the database to your entrypoint.

Hi @NobbZ , thank you very much for your help ! Indeed I was silencing the postgres’ container logs, I just realised I get [error] Postgrex.Protocol (#PID<0.279.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (172.18.0.2:5432): connection refused - :econnrefused I manually crea…

Entrypoint in this context, is what docker runs as ENTRYPOINT. You are using CMD though. I never really got the difference of these 2, but started to use ENTRYPOINT only, about 2 years back, and never had any issues because of this. Basically, you need to run a script which as CMD or ENTRYPOINT th…

I just realise, you are using two CMD, this is not allowed, only the last CMD specified will be used, it overwrites any previous set CMD. On my first read I saw this as a RUN.

Thank you very much !! I think I’m almost there :slight_smile: I created entrypoint.sh at the root of my project, then ran chmod +x /Users/juliencorbin/political_project/entrypoint.sh but got elixir_1 | /bin/sh: 1: entrypoint.sh: not found :frowning: did I run the chmod command wrong ?

Ok it worked ! :smiley: but it couldn’t migrate the DB :frowning: here are the logs : postgres_1 | 2019-03-21 11:07:55.419 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 postgres_1 | 2019-03-21 11:07:55.419 UTC [1] LOG: listening on IPv6 address "::", port 5432 postgres_1 | 2019…

oh @NobbZ you are my man, thank you so much ! You just turned my bad day into a dream day :heart: Now I’m on my way to build a kickass umbrella app ! :smiley:

Elixir Programming Language Forum

ERROR 42P01 (undefined_table) relation "myrelation" does not exist

Questions & Help Questions

NobbZ March 21, 2019, 11:02am 7

Try using /app/entrypoint.sh just to be sure.