#459

New issue

Open

opened 2026-02-25 23:34:16 +03:00 by kerem · 0 comments

kerem commented

2026-02-25 23:34:16 +03:00

Owner

Originally created by @RogerSik on GitHub (Apr 19, 2025).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/1098

Data

Shiori version: ghcr.io/go-shiori/shiori:v1.7.3-25-g6fbaecb
Database Engine: Postgres
Operating system: Talos Linux / Kubernetes v1.32.3

Describe the bug / actual behavior

I'm using cloudnative-pg for the creation of databases. cloudnative-pg is creating secrets in multiple formats:

dbname: app
host: shiori-db-rw
jdbc-uri: jdbc:postgresql://shiori-db-rw.shiori:5432/app?password=REDACTED&user=app
password: REDACTED
pgpass: shiori-db-rw:5432:app:app:REDACTED

port: 5432
uri: postgresql://app:REDACTED@shiori-db-rw.shiori:5432/app
user: app
username: app

I used this secret and referenced uri: to shiori Container. The container is crashing because it is not accpeint

uri: postgresql://app:REDACTED@shiori-db-rw.shiori:5432/app

Its working fine when im hardcoding:

- name: SHIORI_DATABASE_URL
  value: 'postgres://app:REDACTED@shiori-db-rw.shiori:5432/app'

Expected behavior

It would be nice if postgresql:// also would be accepted.

Notes

I reported it as bug because it's the first time when I'm running into such issue. Have deployed 18 postgres container iny my homelab kubernetes and there was always the option to apply username+password or the full postgresql:// string.

Originally created by @RogerSik on GitHub (Apr 19, 2025). Original GitHub issue: https://github.com/go-shiori/shiori/issues/1098 ## Data - **Shiori version**: ghcr.io/go-shiori/shiori:v1.7.3-25-g6fbaecb - **Database Engine**: Postgres - **Operating system**: Talos Linux / Kubernetes v1.32.3 ## Describe the bug / actual behavior I'm using cloudnative-pg for the creation of databases. cloudnative-pg is creating secrets in multiple formats: ``` dbname: app host: shiori-db-rw jdbc-uri: jdbc:postgresql://shiori-db-rw.shiori:5432/app?password=REDACTED&user=app password: REDACTED pgpass: shiori-db-rw:5432:app:app:REDACTED port: 5432 uri: postgresql://app:REDACTED@shiori-db-rw.shiori:5432/app user: app username: app ``` I used this secret and referenced uri: to shiori Container. The container is crashing because it is not accpeint ``` uri: postgresql://app:REDACTED@shiori-db-rw.shiori:5432/app ``` Its working fine when im hardcoding: ``` - name: SHIORI_DATABASE_URL value: 'postgres://app:REDACTED@shiori-db-rw.shiori:5432/app' ``` ## Expected behavior It would be nice if postgresql:// also would be accepted. ## Notes I reported it as bug because it's the first time when I'm running into such issue. Have deployed 18 postgres container iny my homelab kubernetes and there was always the option to apply username+password or the full postgresql:// string.