jakob / jakob/Postico

Trying to connect to RDS with SSL and getting stumped

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

Description

You can use this template for reporting bugs.
Feel free to remove parts that are not relevant, or just write something free-form if you prefer.

## What did you do?

Followed instructions here on how to get a trusted certificate from AWS for RDS.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL

Downloaded this cert...
https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

Imported on macos to keychain and made it trusted.

## What did you expect to happen?

Expected to be able connect.

## What actually happened?

When I select the .pem file within client SSL option in Postico connection settings it fails to connect indicating it can't find a start line.

I don't think it's a bug, I think I'm missing a step or something...

## What software versions are you using?

Postico version: 1.5.4
(select "About Postico" from the Postico menu)

macOS version: 10.13.6
(selecting "About this Mac" from the Apple menu)

PostgreSQL version: AWS RDS (not sure of the version as I don't want to connect w/oSSL from hotel)...
(execute the command "SELECT VERSION();" to find out)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the AWS RDS PostgreSQL SSL instructions and the rds-combined-ca-bundle.pem file, then reproduce the failure using Postico 1.5.4 on macOS with the client SSL setting. Done means determining whether the certificate format or the SSL setting is unsupported and documenting or correcting the connection path.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, macos, postgresql
Domain
databases, desktop, security
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.