erix

erix

Adapter Ecto.Adapters.Mariaex was not compiled

I am new to Elixir, so to learn I’m converting an existing NodeJS project into an Elixir one.

I intend to use plain Elixir (no frameworks), Poison (for JSON I/O), MySQL (database).

My mix dependencies:

[
  {:ecto_sql, "~> 3.2"},
  {:poison, "~> 5.0"},
  {:myxql, "~> 0.6.0"}
]

I followed instructions regarding PostgreSQL on StackOverflow and entered command mix deps.clean --all and then mix do deps.get, compile which results in:

** (ArgumentError) adapter Ecto.Adapters.Mariaex was not compiled, ensure it is correct and it is included as a project dependency
    (ecto 3.11.1) lib/ecto/repo/supervisor.ex:61: Ecto.Repo.Supervisor.compile_config/2
    lib/mysql.ex:2: (module)

I tried adding Mariaex to the dependencies:

[
  {:ecto_sql, "~> 3.2"},
  {:poison, "~> 5.0"},
  {:myxql, "~> 0.6.0"},
  {:mariaex, ">= 0.0.0"}
]

and the result was:

Because "mariaex >= 0.9.0-rc.0" depends on "decimal ~> 1.2" and "mariaex < 0.9.0-rc.0" depends on "decimal ~> 1.0", "mariaex" requires "decimal ~> 1.0".
And because "poison >= 5.0.0" depends on "decimal ~> 2.0", "poison >= 5.0.0" is incompatible with "mariaex".
And because "your app" depends on "mariaex >= 0.0.0", "poison >= 5.0.0" is forbidden.
So, because "your app" depends on "poison ~> 5.0", version solving failed.
** (Mix) Hex dependency resolution failed

I tried removing versions in dependencies:

[
  {:ecto_sql, ">= 0.0.0"},
  {:poison, ">= 0.0.0"},
  {:myxql, ">= 0.0.0"},
  {:mariaex, ">= 0.0.0"}
]

and got:

Because "mariaex >= 0.9.0-rc.0" depends on "decimal ~> 1.2" and "mariaex < 0.9.0-rc.0" depends on "decimal ~> 1.0", "mariaex" requires "decimal ~> 1.0".
And because "the lock" specifies "decimal 2.1.1", "the lock" is incompatible with "mariaex".
And because "your app" depends on "the lock", no version of "mariaex" is allowed.
So, because "your app" depends on "mariaex >= 0.0.0", version solving failed.
** (Mix) Hex dependency resolution failed

Is a connection between Ecto and MySQL even possible? What am I missing?

Marked As Solved

wojtekmach

wojtekmach

Hex Core Team

As you can see from the error message, MyXQL is trying to connect using UNIX socket at /tmp/mysql.sock. You probably want to connect over the network instead, either set protocol: :tcp or explicitly set the hostname: hostname: "localhost" (which implies protocol: :tcp)

Also Liked

erix

erix

Thanks @wojtekmach.

I modified the command to:
{:ok, pid} = MyXQL.start_link(username: "ecto", password: "ecto", protocol: :tcp)
and the connection was established.

Where Next?

Popular in Questions Top

dotdotdotPaul
Okay, I'm having a heck of a time trying to figure out how to best handle the validation of belongs_to associations in Ecto. I'm sure I'...
New
Tee
can someone please explain to me how Enum.reduce works with maps
New
bsollish-terakeet
Credo is smart enough to check for (something like) this: assert length(the_list) == 0 with this response: Checking if an enum is empt...
New
joaquinalcerro
Hi there, I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 record...
New
jerry
Good day to you all. I have been struggling to get a query involving like and ilike to work. Can anyone assist me on this, please? pro...
New
logicmason
Hi there, I'm working through my first release with elixir/phoenix. I've built a release with distillery and found that it crashes when I...
New
SoCreat
i’m a new one to elixir which editor can i use vs code? or atom? Thanks! :smiley:
New
hariharasudhan94
I would like to know what is the best IDE for elixir development?
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
vrod
I am using the Starship cross-shell prompt – it seems pretty nice, but I get some errors: [WARN] - (starship::utils): Executing command ...
New

Other popular topics Top

sorentwo
Hello! tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability. After spen...
977 41022 311
New
sergio
In Ruby, I can go: User.find_by(email: "foobar@email.com").update(email: "hello@email.com") How can I do something similar in Elixir? ...
New
nsuchy
Hi. I’ve noticed that Windows Powershell has it’s own IEX command and you cannot access Elixir’s IEX due to the conflict. This isn’t a cr...
New
lk-geimfari
What is most correct way to open, read and parse JSON file with poison? For example if we have example.json file in root of some projec...
New
lastday4you
I wanted to check elixir version in phoenix because i found that my elixir is 1.5 but when i use Enum.chunk_by it said the function is un...
New
chensan
I have a User schema with a :from_id field set to type :string: defmodule TweetBot.Repo.Migrations.CreateUsers do use Ecto.Migration ...
New
fayddelight
I tried installing elixir 1.11.2 erlang 23.3.4 via asdf in my zsh shell. Enabled the versions locally and globally. When I list them ...
New
electic
Hi, I am new to Elixir. I am trying to use the DateTime component to insert a date into MySQL however the there seems to be no way to fo...
New
TunkShif
This post is an instruction guide to help you setup your Neovim for Elixir development from scratch. It includes general information on h...
273 38985 115
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New

We're in Beta

About us Mission Statement