DB connection issues

[rakesh-voiger]

• 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

[danschultzer]

It depends how you set it up, I'm not sure if things have changed since I made this repo. For SSL you need to use the the AWS RDS CA cert. Nowadays I use RDS IAM and wrote a blog post on it including the RDS CA cert: https://danschultzer.com/posts/setup-rds-iam-auth-with-ecto

You can use this dep for the castore: https://hex.pm/packages/aws_rds_castore

[rakesh-voiger]

Sure, I will try it out and update here. Thanks.