[GH-ISSUE #431] A little help to setup the Docker container? #268

New issue

Closed

opened 2026-02-25 23:33:50 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 23:33:50 +03:00

Owner

Originally created by @romu70 on GitHub (May 29, 2022).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/431

Hi,
I'm trying to run Shiori through a Docker container, and to store the data on my server Postgres instance.

Here is the Docker command I run:

docker run --name shiori -e SHIORI_DBMS=postgres -e SHIORI_PG_USER=shiori -e SHIORI_PG_PASS=blablabla -e SHIORI_PG_NAME=shiori -e SHIORI_PG_HOST=my-psql-ip -e SHIORI_PG_PORT=my-psql-port -d -p 4900:8080 ghcr.io/go-shiori/shiori:latest

I get the access to the web interface, I can connect the first time with the shiori/gopher credentials. But the DB remains blank. The container log contains a lot of this trace:

2022/05/29 19:28:42 error during db.get: sql: no rows in result set

Weirdly, once I created a user account, I can't connect anymore neither with the default account, nor with the newly created one.

Any help would be great. Thanks.

Originally created by @romu70 on GitHub (May 29, 2022). Original GitHub issue: https://github.com/go-shiori/shiori/issues/431 Hi, I'm trying to run Shiori through a Docker container, and to store the data on my server Postgres instance. Here is the Docker command I run: ``` docker run --name shiori -e SHIORI_DBMS=postgres -e SHIORI_PG_USER=shiori -e SHIORI_PG_PASS=blablabla -e SHIORI_PG_NAME=shiori -e SHIORI_PG_HOST=my-psql-ip -e SHIORI_PG_PORT=my-psql-port -d -p 4900:8080 ghcr.io/go-shiori/shiori:latest ``` I get the access to the web interface, I can connect the first time with the shiori/gopher credentials. But the DB remains blank. The container log contains a lot of this trace: ``` 2022/05/29 19:28:42 error during db.get: sql: no rows in result set ``` Weirdly, once I created a user account, I can't connect anymore neither with the default account, nor with the newly created one. Any help would be great. Thanks.

kerem closed this issue

2026-02-25 23:33:50 +03:00

kerem commented

2026-02-25 23:33:50 +03:00

Author

Owner

@romu70 commented on GitHub (Jun 5, 2022):

Found the problem. Bad DB type value which should be postgresqland not postgres.

@romu70 commented on GitHub (Jun 5, 2022): Found the problem. Bad DB type value which should be ```postgresql```and not ```postgres```.