Docker

9 readers

1 users here now

founded 1 year ago

MODERATORS

erlingur@programming.dev

ProgramPhoenix@programming.dev

Ategon@programming.dev

unable to open the database file (SQLITE_CANTOPEN) (programming.dev)

submitted 7 months ago by jadero@programming.dev to c/docker@programming.dev

6 comments fedilink hide all child comments

I have a Bluesky PDS running successfully. Now I'm trying to set up GoToSocial, an ActivityPub server that also uses sqlite. When I run

sudo docker compose up -d

I get the following error in the docker log for GoToSocial:

Error executing command: error creating dbservice: sqlite ping: Unable to open the database file (SQLITE_CANTOPEN)

Is this more likely to be a conflict between the two docker applications or something specific to GoToSocial? (I've gone through the sqlite issues I've been able to find in GoToSocial's GitHub.)

If something to do with running sqlite in two containers, do you have any tips to resolve the issue?

you are viewing a single comment's thread
view the rest of the comments

[–] nickwitha_k@lemmy.sdf.org 3 points 7 months ago (1 children)

This is the most likely. You need to ensure that the volume is mounted AND that permissions are set correctly. Docker doesn't care about username. It cares about user ID. So, if the dir/file ownership and mode does not give sufficient permissions to the UID/GID of the user in the container, you'll need to correct that.

[–] jadero@programming.dev 2 points 7 months ago

Oh, that user ID must be the answer. I was wondering what those numbers were ☺️

More digging to figure out what the appropriate user id is...