DB connection issues

Open rakesh-voiger opened this issue 10 months ago • 2 comments

With default configurations, i get the following error at ecs.

no pg_hba.conf entry for host "10.0.2.166", user "dbuser", database "core_dev", no encryption

Enabled ssl: true and I get the error

ssl connect: Options (or their values) can not be combined: [{verify,verify_peer}

I tried the ssl_opts: [verify: :verify_none] along with ssl: true i have this warning.

14:19:54.828 [warning] setting ssl: true on your database connection offers only limited protection, as the server's certificate is not verified. Set "ssl: [cacertfile: path/to/file]" instead

References: https://elixirforum.com/t/postgrex-doesnt-send-password-postgrex-error-fatal-28000-invalid-authorization-specification/61290 https://elixirforum.com/t/how-to-set-ssl-options-correctly-when-connecting-to-heroku-postgres-db/59426/2

Feb 15 '25 14:02 rakesh-voiger