This should be a simple problem but I just can’t seem to figure it out. I have a standalone Elixir app that won’t find the database. Dependencies {:comeonin, "~> 5.1"}, {:postgrex, "~> 0.14.1"}, {:ecto_sql, "~> 3.0"}, Repo defmodule AccountService.Repo do use Ecto.Repo, otp_app: :ac…

Ensure the below and give it a re-try. STEP 1. Define the dependencies required, mix.exs defp deps do [ {:ecto_sql, "~> 3.1"}, {:postgrex, "~> 0.14.3"} ] end STEP 2. Get the dependencies defined above mix deps.get STEP 3. Configure the Repo the application config :helloapp…

Hi folks, I facing the following error with heroku. in local the app connects with db and running fine, only with heroku its throwing the following error. I am unable to execute mix ecto.setup, :worried: i do have another app running fine in heroku, i followed the same setups but its not connectin…

Post your entire prod.exs (without the secrets)? Seems like a straightforward case of not having the :database configuration key in the file.

Heroku uses url which has database, host, user, and password. which worked fine in elixir 1.8 phoenix app but not in 1.9 phoenix app config :MyApp, MyApp.Repo, adapter: Ecto.Adapters.Postgres, pool_size: String.to_integer(System.get_env("POOL_SIZE") || "5"), ssl: true, url: System.get_env("…

Are you sure your app’s atom name is :MyApp and not :myapp? Can you also show your MyAppRepo.ex file?

yeah its “config :myapp, MyApp.Repo” its a typo. defmodule MyApp.Repo do use Ecto.Repo, otp_app: :myapp, adapter: Ecto.Adapters.Postgres use Scrivener, page_size: 10 end This works fine in dev env (local ), but it gets deployed in heroku as well, but just not getting connected with da…

I am assuming you have a DATABASE_URL environment variable in your Heroku configuration?

yes, i do have. dont know why its not connecting :worried:

Can you invoke a remote shell into your Heroku dyno? heroku run -a your_app iex -S mix, I think. From there, you can try this: System.get_env("DATABASE_URL") And see what’s wrong.

I got this when i ran above command, this error " (RuntimeError) connect raised KeyError exception:" was raised 20 + times before terminating the process. 18:09:36.334 [error] GenServer #PID<0.458.0> terminating ** (RuntimeError) connect raised KeyError exception: key :database not found. The excep…

Elixir Programming Language Forum

Ecto :database Not Found

Questions & Help Questions

tenzil December 27, 2019, 5:44pm 11

yes, i do have. dont know why its not connecting