SSL is required

Question

SSL is required

nikita-davydov opened this issue 7 months ago · 11 comments

I'm trying to connect using ConnectonPool and getting an error
psqlpy.exceptions.RustPSQLDriverPyBaseError: Database engine pool exception: Error occurred while creating a new object: db error: ERROR: odyssey: c1fc39c4c6d6c: SSL is required

My connection string works for all of the other existing drivers

Do you have any workaround?

Answer 1 · 2024-05-14T08:41:32.000Z

@nikita-davydov Hello!
Thanks for the question.

Could you please provide your connection string?
Do you specify any SSL configuration in other drivers?

Answer 2 · 2024-05-14T09:09:28.000Z

The connection string is default postgres://log:pass@host:5432/db_name as usual

I'm using cloud managed database, if I use sslmode=verfiy-full, it says that it's invalid connection string: invalid value for option sslmode.

Answer 3 · 2024-05-14T09:14:07.000Z

@nikita-davydov Could you please try to specify sslmode=require? And send error message here if any

Answer 4 · 2024-05-14T09:15:29.000Z

The result is Database engine pool exception: Error occurred while creating a new object: error performing TLS handshake: no TLS implementation configured

Answer 5 · 2024-05-14T09:23:12.000Z

The documentation says that I should use sslmode=verify-full

reference

Answer 6 · 2024-05-14T09:26:35.000Z

Will it be ok if you try a new version of the driver from the branch?
I'm gonna make some changes in the new branch and you'll try, ok?

I haven't had any production experience with cloud-managed databases, so we'll have to figure out the problem together)

Answer 7 · 2024-05-14T09:29:28.000Z

Sure, looking forward your updates

Answer 8 · 2024-05-14T10:20:13.000Z

@nikita-davydov Could you, please, try to install the library from this branch https://github.com/qaspen-python/psqlpy/tree/feature/ssl_mode_problems and try again?
I added the ability to set sslmode=verify-full and made other changes. I'm not sure it will help, we need to try tho.

Answer 9 · 2024-05-14T11:02:13.000Z

@nikita-davydov
Btw. I haven't described anywhere how to work on this project and install it.

You need to:

Install rust (https://www.rust-lang.org/tools/install)
Install maturin (https://www.maturin.rs/installation)
Create new venv for maturin

> python3 -m venv .venv
> source .venv/bin/activate
> pip install -U pip maturin

Then you can run maturin develop and try to connect to your database within your new virtual env created on the third step (create any py file _test.py, as an example, and use PSQLPy like you installed it).

Answer 10 · 2024-05-20T10:32:03.000Z

@nikita-davydov Hello! Hope u a doing great!
Did you have any time to test my solution?

Answer 11 · 2024-07-04T07:47:56.000Z

Closing this issue due to the latest release https://github.com/qaspen-python/psqlpy/releases/tag/0.7.1