Nginx proxy manager does not handle postgresql clusters enforcing the use of ssl

[gsalingu]

Checklist

• Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
  • Yes
• Are you sure you're not using someone else's docker image?
  • Yes
• Have you searched for similar issues (both open and closed)?
  • Yes

Describe the bug The nginx proxy manager currently does not support connecting to postgresql database enforcing the use of SSL certificates

Nginx Proxy Manager Version v2.12.6

To Reproduce Steps to reproduce the behavior:

1. Deploy a postgresql database enforcing the use of ssl
2. Try and follow your setup guide for postgresql
3. The app enters a crashloop

    at Parser.parseErrorMessage (/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:191:23) {
  length: 33,
  severity: 'FATAL',
  code: '08P01',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: undefined,
  line: undefined,
  routine: undefined

Expected behavior nginx proxy manager starting up when I try to use a database with ssl enforced

Operating System

cat /etc/os-release
PRETTY_NAME="Debian GNU/Linux 13 (trixie)"
NAME="Debian GNU/Linux"
VERSION_ID="13"
VERSION="13 (trixie)"
VERSION_CODENAME=trixie
DEBIAN_VERSION_FULL=13.2
ID=debian
HOME_URL="https://www.debian.org/"
SUPPORT_URL="https://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"

Additional context

Nothing Just thanks for your work, this product is amazing :) pull request incoming

[gsalingu]

I opened https://github.com/NginxProxyManager/nginx-proxy-manager/pull/4992 to address this issue

[7heMech]

Did you try at the latest version?

[7heMech]

Aha, it has not changed it would seem.

[gsalingu]

Yeah and unfortunately my patch got mixed up into local changes, it wouldn't fix the issue... I did not have access to the built docker image, and resorted to patching the image locally but was pointed at a non enforced SSL DB when I tested After further testing it seems like the "knex" library just does not play nice with sslmode on postgresql :(