[PR #404] [MERGED] allow postgres connections, that require ssl mode #1011

New Issue

OVERLORD · 2026-02-04T21:44:00+03:00

OVERLORD commented

2026-02-04 21:44:00 +03:00

📋 Pull Request Information

Original PR: https://github.com/plankanban/planka/pull/404
Author: @orbatschow
Created: 2/24/2023
Status: ✅ Merged
Merged: 2/27/2023
Merged by: @meltyshev

Base: master ← Head: master

📝 Commits (2)

3e5f43e provide a fix and documentation for postgres connections, that require ssl mode
6188a71 fix spelling mistake

📊 Changes

3 files changed (+16 additions, -1 deletions)

View changed files

📝 docker-compose.yml (+5 -0)
📝 server/.env.sample (+5 -0)
📝 server/db/knexfile.js (+6 -1)

📄 Description

At the moment knex.js does not pass down connection query parameters to build the connection.
Related: https://github.com/knex/knex/issues/2354

This can be bypassed by setting the corresponding environment variable PGSSLMODE.

This PR provides the corresponding documentation. I couldn't find the source code for the official website, so I put this into two places:

server/.env.sample
docker-compose.yml

So far there is a ticket open to allow connections to Postgres databases, that offer a self-signed certificate: https://github.com/plankanban/planka/issues/261

This PR will make a change on how the connection string is build, that should be backwards compatible and allows the usage of self-signed certificates.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/plankanban/planka/pull/404 **Author:** [@orbatschow](https://github.com/orbatschow) **Created:** 2/24/2023 **Status:** ✅ Merged **Merged:** 2/27/2023 **Merged by:** [@meltyshev](https://github.com/meltyshev) **Base:** `master` ← **Head:** `master` --- ### 📝 Commits (2) - [`3e5f43e`](https://github.com/plankanban/planka/commit/3e5f43ebeda7e37de623aba89fe7076cf638a104) provide a fix and documentation for postgres connections, that require ssl mode - [`6188a71`](https://github.com/plankanban/planka/commit/6188a716ccadc9a7ae8ca431edd08057aadf0f7c) fix spelling mistake ### 📊 Changes **3 files changed** (+16 additions, -1 deletions) <details> <summary>View changed files</summary> 📝 `docker-compose.yml` (+5 -0) 📝 `server/.env.sample` (+5 -0) 📝 `server/db/knexfile.js` (+6 -1) </details> ### 📄 Description At the moment knex.js does not pass down connection query parameters to build the connection. Related: https://github.com/knex/knex/issues/2354 This can be bypassed by setting the corresponding environment variable `PGSSLMODE`. This PR provides the corresponding documentation. I couldn't find the source code for the official website, so I put this into two places: - server/.env.sample - docker-compose.yml So far there is a ticket open to allow connections to Postgres databases, that offer a self-signed certificate: https://github.com/plankanban/planka/issues/261 This PR will make a change on how the connection string is build, that should be backwards compatible and allows the usage of self-signed certificates. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

OVERLORD added the pull-request label 2026-02-04 21:44:00 +03:00

OVERLORD closed this issue

2026-02-04 21:44:01 +03:00

OVERLORD referenced this issue

2026-02-04 21:54:29 +03:00

[PR #1011] [MERGED] chore(deps): Bump nanoid in /client #1164

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/planka#1011