File permissions error on app boot

[somethingGoneWrong]

Hi, i just try to run this software via docker but i get error with some db table i think.
The docker image i launch is this:

docker create --name CTX_pinchflat --restart unless-stopped -e PUID=1000 -e PGID=1000 -e TZ=Europe/Rome --network net -h pinchflat -p 8945:8945 -v /share_docker/pf_config:/config --mount type=bind,source=/mnt/misc/TEMP_YT/,target=/downloads --log-driver syslog --log-opt tag=DOCKER_pinchflat --log-opt syslog-address=udp://IP_LOCAL:514 keglin/pinchflat:latest

these below are the error i get:

!! - Edited by admin - !!

This was a database error that was actually a file permissions error. 
The error was improved in #114 and the original error here is no longer relevant

i need to fix something? thx

[gelof2022]

I'm getting the same error when trying to start the container:

!! - Edited by admin - !!

This was a database error that was actually a file permissions error. 
The error was improved in #114 and the original error here is no longer relevant

[joshuapeterson]

I'm seeing the same error on startup

!! - Edited by admin - !!

This was a database error that was actually a file permissions error. 
The error was improved in #114 and the original error here is no longer relevant

[Tiritibambix]

Same same

[kieraneglin]

This reads to me like the app doesn't have permission to write the database file to the config location. I'll see if I can replicate this later today, but what happens if you use --user=99:100 and remove the current PUID/PGID options?

This will help me confirm the issue

[kieraneglin]

Also, can you tell me a little bit about your environment? Is it x86 or arm? Are you using WSL? Stuff like that

[Tiritibambix]

I'm running docker on an amd64 machine. Nothing less, nothing more.
I set permission to 777 and tried with no puid/pgid specified, with 99:100 and with 0:0.
Still get the same error.

[kieraneglin]

@Tiritibambix that helps, thanks! Would you mind posting your full Docker command? And if you look at your specified config location, is there a sqlite database file written to disk?

[kieraneglin]

Just checked and I was able to repro this issue by making the config folder not writable by the Docker user. Here's the output of the config dir from ls -la when everything is working: drwxr-xr-x 1 nobody users 28 Mar 1 16:55 pinchflat-dev/ and I'm running the user as 99:100.

What's the output of ls -la in regards to the config directory for you?

[Tiritibambix]

For the record, I don't know much about all this, so please bare with me.
I converted the docker command to docker-compose because I use portainer:

version: "3.3"
services:
  pinchflat:
    environment:
      - BASIC_AUTH_USERNAME=username
      - BASIC_AUTH_PASSWORD=password
      - PUID=998
      - PGID=100
    ports:
      - 8945:8945
    volumes:
      - /path/Pinchflat/config:/config
      - /path/Pinchflat/downloads:/downloads
    image: keglin/pinchflat:latest

998:100 is my docker user:group. As mentioned above, I also tried none, 99:100 and 0:0
path/Pinchflat/config remains empty after each attempt no matter the config.

ls -la in path/Pinchflat/config outputs this:

drwxr-sr-x 2 root users 4096 Mar 23 16:08 .
drwxrwsrwx 4 root users 4096 Mar 23 16:08 ..

edit: I also tried chown -R 99:100 and chown -R 998:100 with their respective config with no luck.

[Tiritibambix]

Ok, I got it to work.
I previously set permissions to /config and /downloads to 777, but I had do do it to the parent directory /Pinchflat and set it recursively. I then chown -R 998:100 /Pinchflat and use 998:100 in my config.

Thanks for your assistance, it help me figure it out.

Now I can try Pinchflat :D

[kieraneglin]

Glad to hear you got it sorted! You may want to see if 755 works instead of 777 - it's not much, but it's a little safer.

Thanks for the help! I'll keep this issue open for a bit longer while I add a preflight check for permissions that's easier to read + improve the docs 🤙

[Tiritibambix]

It won't work with 755 or 775 :(

[kieraneglin]

Hmm. One last thing to try - does it work if you first run chown -R nobody /path/Pinchflat then chmod -R 755 /path/Pinchflat?

I'll be the first to say that I'm not a docker/linux admin expert so thanks for bearing with me!

[somethingGoneWrong]

Also, can you tell me a little bit about your environment? Is it x86 or arm? Are you using WSL? Stuff like that

x86 on LXC container

[Tiritibambix]

Hmm. One last thing to try - does it work if you first run chown -R nobody /path/Pinchflat then chmod -R 755 /path/Pinchflat?

If chown -R nobody /path/Pinchflat that means you want me to try with 99:100 ?

Edit: yes, tried that and it works