jakob / jakob/Postico

Improve connection string parsing for TLS certificates

Open
#859 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

## What did you do?

When creating a new server from a postgres connection string, Postico does not seem to parse the `sslcert/sslkey/sslrootcert` query parameters properly, and does not fill the path for the `Server CA/Client Cert/Client Key` inputs.

My connection string looks like this:

```
postgres://username:password@127.0.0.1:15432/database?sslcert=/tmp/tmp.DSb7o56gRA&sslkey=/tmp/tmp.h2J1LhJtt4&sslrootcert=/tmp/tmp.IWNE6enikG
```

## What did you expect to happen?

I expected Postico to fill all the inputs from the parameters I specify in my connection string.

## What actually happened?

The paths are not parsed and the inputs are not filled.

## What software versions are you using?

Postico version: 2.0.5 (9661)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start at the new-server flow that parses PostgreSQL connection strings, focusing on the sslcert, sslkey, and sslrootcert parameters. Verify that the Server CA, Client Cert, and Client Key inputs are populated from those paths, and confirm the example connection string works.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.