I am trying to build my phoenix app on my server and facing a nightmarish issue because of the major platform differences with my dev machine.
Server:
mysqld Ver 5.7.33-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))
Error:
23:01:12.690 [error] MyXQL.Connection (#PID<0.382.0>) failed to connect: ** (DBConnection.ConnectionError) connection refused
very helpful! I know.
tried with ecto:// or mysql:// no luck. I have hardcoded the values into the config files still refused!
I know for a fact that MySQL is up and running, the user credentials are correct and verified several times. Scratching my head found this gem in the source code.
defmodule Ecto.Adapters.MyXQL do
@moduledoc """
Adapter module for MySQL.
It uses `MyXQL` for communicating to the database.
## Options
MySQL options split in different categories described
below. All options can be given via the repository
configuration:
### Connection options
* `:protocol` - Set to `:socket` for using UNIX domain socket, or `:tcp` for TCP
(default: `:socket`)
* `:socket` - Connect to MySQL via UNIX sockets in the given path.
Would be useful if this was published in the hex docs but I can raise an issue for it later.
Although I am on unix for my dev machine and setup is completely different, it works with no problems.
so now I have hope! I pass in actual socket path with ecto://.....?socket=PATH still refused or mysql:// still refused
I have set the protocol still no luck
protocol: :tcp
I can’t really use iex -S because of the constant spamming of connection refused.
I see in the documentation about starting with the supervisor…
It's recommended to start MyXQL under supervision tree:
defmodule MyApp.Application do
use Application
def start(_type, _args) do
children = [
{MyXQL, username: "root", name: :myxql}
]
Supervisor.start_link(children, opts)
end
end
which made me go WTF! Because everything worked till now I didn’t realise this required a ‘boot’ config till now.
This is beyond F’ed level up of configuration at this point but let me try.
Oh connection refused for my user, it did work and have an affect.
change to protocol to tcp… nope
it expects a goddamn socket and then I realized I have two different errors from different processes.
23:29:45.463 [error] MyXQL.Connection (#PID<0.404.0>) failed to connect: ** (MyXQL.Error) (1045) (ER_ACCESS_DENIED_ERROR) Access denied for user 'test'@'localhost' (using password: NO)
23:29:45.520 [error] MyXQL.Connection (#PID<0.379.0>) failed to connect: ** (DBConnection.ConnectionError) connection refused
I hardcode the password and still, shoddy shit won’t connect.
{MyXQL, username: "user", name: :myxql, socket: "/var/run/mysqld/mysqld.sock", password: "test", database: "test"}
I put all the values into the shoddy MyXQL supervisor tree and drop from config still refused.
Does anyone have any advice? Which bit am I missing here?
The only reason I am not using Postgres is the bigger footprint on the xxx-small server I have.
