Introduce & verify tls/ssl support

[affejunge]

Hi all,

We observed that using the Client with connection parameters like this
Client.open(f"dbname='stac' user='{username}' password='{password}' host='{host}' port=5432 sslmode='require'")

on a database with ssl enabled, the connection is not established. The error message is

PgstacError: postgres: error performing TLS handshake: no TLS implementation configured

Using psycopg2 with the same connection parameters works fine. The connection is established and a query is executed successfully.
We tested with this 4976448
against db running pgstac:v0.9.1

[gadomski]

Thanks for the report ... can you again after reinstalling? pip install --force git+https://github.com/stac-utils/pgstacrs. I've got a fix in #18 but haven't yet cooked up an easy way to test it.

[affejunge]

Hi @gadomski thanks for the update.
I just reinstalled and tested with the same settings as mentioned above and still get the same error

PgstacError: postgres: error performing TLS handshake: no TLS implementation configured

using the sslmode 'require'.

[gadomski]

Ok thanks for checking, I'll take another look this morning.

[gadomski]

🤔 I'm wondering if you picked up the latest changes, as that error comes from NoTls: https://github.com/sfackler/rust-postgres/blob/d7ccc7e398755addf13096b55bdab49c2cc96156/tokio-postgres/src/tls.rs#L160. I've released v0.1.1, so can you do the following and try again?

pip install pgstacrs=0.1.1

[affejunge]

thanks @gadomski just quickly tested and got the same error but I need to verify my env. Will get back to you.

[gadomski]

Ok, if this doesn't work for you I'll put some time into standing up an SSL-enabled pgstac and trying to reproduce myself. Appreciate your patience 🙇🏼

[gadomski]

You could also try setting https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNECT-SSLROOTCERT in your connection string? There's a chance that pyscopg2 sets some default that I'm not setting, so you could try to set the root cert yourself (maybe to system)?