jakob / jakob/Postico

[Question] SSL error when connecting to AWS RDS

Open
#772 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

This maybe not be a bug, but Postico complains SSL error when connecting to AWS RDS servers even though I registered AWS RDS root CA to my system keychain.
Is there any workaround other than registering each certificates for every AWS RDS server?
Or am I missing something?

## What did you do?

- Add AWS RDS Root CA to system.
- Connect to AWS RDS via Postico.

## What did you expect to happen?

- Connection opens without an error.

## What actually happened?

- Postico complains that certificate is not standard compliant.
-
Screen Shot 2021-06-08 at 11 39 01 AM

## What software versions are you using?

Postico version: 1.5.18

macOS version: 11.2.3

PostgreSQL version: PostgreSQL 11.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit

Contributor guide

No contributing guide indexed for this repository

Research direction

No source files, tests, or entry points are named. Start by reproducing the connection from Postico 1.5.18 on macOS 11.2.3 against PostgreSQL 11.10 on AWS RDS, using the reported system-keychain setup. Done means determining whether the AWS RDS root CA is accepted and whether a connection can open without the certificate error.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, macos, postgresql
Domain
databases, 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.