getting crazy with this issue. I googled, I searched in the forum, tried many things but nothing helped
Installed home assistant on debian on raspberry 4. I moved the file from the original location to the new location. Additionally I give the the following information
homeassistant@rpi4-20201112:/$ ls -lr /mnt/usbdisk_db/
-rw-r--r-- 1 root root 184320 Jan 1 22:37 home-assistant_v2.db
I tried several different number of / in the db_url as well, either I get nothing or I get the following error
" Logger: homeassistant.components.recorder
Source: components/recorder/__init__.py:279
Integration: Recorder ([documentation](https://www.home-assistant.io/integrations/recorder), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+recorder%22))
First occurred: 9:09:25 AM (9 occurrences)
Last logged: 9:09:49 AM
Error during connection setup: (sqlite3.OperationalError) unable to open database file (Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)"
I really appreciate your help - thanks. It seems it slowly goes beyond my know-how on this field . Well usually when I start raspberry everything already runs and I can login in homeassistant via web. I believe I need to stop the container and then to start it again adding the line you suggested. Do I get it right?
Sorry, but as I said, I don’t know how to do this with Home Assistant OS. Don‘t know your intention when moving the DB to another disk, but obviously you can also move the entire „data“ direction to another location.
Thanks. I’m still convinced it shoud be possible the solution you suggested. I played a bit with
sudo docker inspect container_name
removing the container and adding new ones with the additional arguments you suggested.
FYI I then decided to change approach and I installed HASSIO in a python environment on raspbian. This could give me the flexibility I expect, I already installed mqtt, samba and moved the db on the usb stick all just some hours work. As I said I’m still in the learning phase, it may change soon but it seems to be the most practicable. I never worked concretely with dockers and I’m afraid of it…
Hi Christoph!
May you tell me where I find the docker run command to “mount” the USB drive?
Background: I’m also using HA in docker on a Synology NAS,
but don’t succeed in shifting the database access to an external drive.
When using
I always get an cryptic error
"Error during connection setup: (sqlite3.OperationalError) unable to open database file (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation) "