diesel does not connection to postgres database with sslmode required

[ghost]

Setup

Versions

• Rust: stable 11 sept 2022
• Diesel: 2.0.0
• Database: postgres
• Operating System mac m1

Feature Flags

• diesel:
• ["postgres","numeric","chrono"]

Problem Description

diesel-cli runs migrations successfully with sslmode=require attached to database url
but when performing diesel_insert in program, it says error performing TLS handshake: no TLS implementation configured"

What are you trying to accomplish?

Connect to postgres database with sslmode required.

What is the expected output?

Successful database insert

What is the actual output?

error performing TLS handshake: no TLS implementation configured"

Are you seeing any additional errors?

N/A

Steps to reproduce

Setup postgres 14 database with encryption only connection.
Create insert query using diesel with sslmode required

Checklist

• I have already looked over the issue tracker and the disussion forum for similar possible closed issues.

sgrif/pq-sys#25

• This issue can be reproduced on Rust's stable channel. (Your issue will be
  closed if this is not the case)
• This issue can be reproduced without requiring a third party crate

[ghost]

Also adding allow to sslmode url query results in

UnableToSendCommand, "invalid connection string: invalid value for option sslmode

[weiznich]

This sounds like an issue with your environment. Can you verify that psql postgres://your/db_url works for you. If not that indicates that your database url does just not match your setup.