Ecto create a repo error

Can you please provide the exact output of the mix ecto.create run? Also the content of your mix.exs might help us.

Hy NobbZ, thanks for your answer.
This is the exact output :

And this is the Mix.exs file :

11564×531 25.3 KB

Dont use sudo!

root will probably see a different version of elixir than theo does in his current environment.

Why do You need sudo to run mix ecto.create?

Running with sudo change your identity, it changes also asdf setup because it is on a per user setup I think.

You could try to really check this.

$ sudo asdf current elixir

Usually asdf is installed “per user”, so I assume that root won’t even see the asdf script/function (however its implemented).

PS: Please do not post screenshots of code or your shell, use proper copy and paste to get the content in the post and then use either 4 spaces indentation per line or wrap it into triple backticks (```) to mark the code block as such as you are used to it from your favorite markdown dialect.

This makes reading and especially copying them a lot easier (and uses less bandwith of my mobile dataplan).

Oh, and you will probably need to sudo rm -rf _build deps before using mix without sudo again to “repair” ownerships and permissions.

Thanks guy, you were right it was a problem at sudo. However, I have another error at the same stage and I do not know what to do.
Error message :
(Mix) The database for Farmbot.Repo couldn’t be created: an exception was raised:
** (RuntimeError) Connect raised a KeyError error. The exception details are hidden, as
they may contain sensitive data such as database credentials.

    (elixir) lib/keyword.ex:377: Keyword.fetch!/2
    (postgrex) lib/postgrex/protocol.ex:610: Postgrex.Protocol.auth_md5/4
    (postgrex) lib/postgrex/protocol.ex:504: Postgrex.Protocol.handshake/2
    (db_connection) lib/db_connection/connection.ex:135: DBConnection.Connection.connect/2
    (connection) lib/connection.ex:622: Connection.enter_connect/5
    (stdlib) proc_lib.erl:247: :proc_lib.init_p_do_apply/3

Have you an idea of what can I do ?

You should check your credentials. It is located in the config folder of your farmbot application.

You should match that the user specified is allowed to use database.

In case not… You might look at PostgreSQL: Documentation: 9.5: CREATE USER