hasura / hasura/graphql-engine

Cannot add SSL configuration for read replicas

Open
#9,289 2 comments 0 reactions 1 assignee Claimed by @vijayprasanna13 View on GitHub
k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: 2.16.0-cloud.1 (and many previous versions)

### Environment

Cloud

### What is the current behaviour?

Trying to connect a read replica with SSL configuration ignores the SSL configuration. Therefore, if the database requires an SSL configuration, it results in the error "FATAL: connection requires a valid client certificate".

### What is the expected behaviour?

Connecting read replica with SSL configuration should work correctly since it is an option provided by Hasura in the UI.

### How to reproduce the issue?

1. Navigate to Data -> Data Manager and edit an existing data source
2. Add read replica configuration with SSL certificates
3. Click on 'Update Connection'

### Any possible solutions/workarounds you're aware of?

The issue here is with the UI not sending the SSL configuration to the backend. Here is the relevant part of the metadata sent to the backend -

```json
"read_replicas": [
{
"database_url": {
"from_env": "DATABASE_URL"
},
"pool_settings": {}
}
]
```
As can be seen above, there is no information about the SSL configuration.

Since this is a UI issue, adding the configuration manually through the metadata works.

### Keywords

ssl configuration, read replica

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.