How to make /opt/homeassistant/config/home-assistant_v2.db readable and writable for Sqlitebrowser

[Allinijhof]

Dear community,

I have just installed Sqlitebrowser through docker compose (see screenshot docker-compose.yaml file attached), unfortunately I am not able to access the home-assistant_v2.db file through Sqlitebrowser.

Would you be able to advise how to enable the folder and file for Sqlitebrowser?

With kind regards,

Allard

[justinclift]

Interesting. At a first guess, it's probably something like a user permissions problem.

You have the volume set to a persistent directory (/opt/homeassistant/config), which looks ok.

So the next thing you need to check is the ownership and permissions of that directory on your system,
then check if the user you are trying to access it from has permissions to get there.

Does that make sense? 😄

Also, how good are you with using the command line / terminal? If you're decently ok with it, that'll make it easier to give you potential commands to try out. 😄

[FriedrichFroebel]

The Docker image is not maintained by DB4S itself, but by a third-party. It might be better to sort this out with the actual maintainers: https://github.com/linuxserver/docker-sqlitebrowser

[justinclift]

Good idea. Looking at that page it has instructions for what looks like fixing this problem:

https://github.com/linuxserver/docker-sqlitebrowser#user--group-identifiers

[Allinijhof]

Hi Justin, Friedrich, thanks for your support! I have been able to direct the SQL to the right folder (volume). That is great thanks!

[justinclift]

Cool, sounds like a good result. 😄

[Allinijhof]

Issue has been resolved.