Domoticz

jake wrote: ↑Tuesday 21 April 2020 21:13 Would it be worthwhile to mv the whole backup folder to another folder name? Maybe this gives domoticz the possibiliy to build the data set again.

waaren wrote: ↑Tuesday 21 April 2020 21:44

jake wrote: ↑Tuesday 21 April 2020 21:13 Would it be worthwhile to mv the whole backup folder to another folder name? Maybe this gives domoticz the possibiliy to build the data set again.

It certainly looks like a access rights related issue so it's worth a try. I don't know when domoticz looks for the directory structure so to be sure it picks up the absence of the backup directory I would:

deactivate automatic backup and apply changes in settings page
stop domoticz
cd <domoticz dir>
mv backups/ backups_keep/
start domoticz
activate automatic backup and apply changes in settings page

jake wrote: ↑Tuesday 21 April 2020 21:48

waaren wrote: ↑Tuesday 21 April 2020 21:44

jake wrote: ↑Tuesday 21 April 2020 21:13 Would it be worthwhile to mv the whole backup folder to another folder name? Maybe this gives domoticz the possibiliy to build the data set again.

It certainly looks like a access rights related issue so it's worth a try. I don't know when domoticz looks for the directory structure so to be sure it picks up the absence of the backup directory I would:

deactivate automatic backup and apply changes in settings page
stop domoticz
cd <domoticz dir>
mv backups/ backups_keep/
start domoticz
activate automatic backup and apply changes in settings page

Yes, that sound like the safest plan to me too. I will try it, within 12 minutes I am supposed to know if it workd (21:48 at the moment of writing)

drwxr-x---   5 root root     4096 Apr 21 22:00 backups
drwxr-xr-x   5 pi   pi       4096 Apr 21 21:08 backups_keep

jake wrote: ↑Tuesday 21 April 2020 22:02

Code: Select all

drwxr-x---   5 root root     4096 Apr 21 22:00 backups

waaren wrote: ↑Tuesday 21 April 2020 22:14

jake wrote: ↑Tuesday 21 April 2020 22:02

Code: Select all

drwxr-x---   5 root root     4096 Apr 21 22:00 backups

So All good now?

jvdz wrote: ↑Saturday 05 January 2019 14:26 You could try this approach by dumping the current database and loading the dumpfile into a new database like this bash file:

Code: Select all

#! /bin/sh
sudo service domoticz stop
cd /home/pi/domoticz
rm -f dump.sql
echo Dump domoticz.db to dump.sql
sudo sqlite3 domoticz.db  <<EOF
.mode insert
.output dump.sql
.dump
.exit
EOF

rm -f domoticz.fixed.db
echo create new domoticz.fixed.db loading dump.sql
sudo sqlite3 domoticz.fixed.db  <<EOF
.read dump.sql
.exit
EOF

After this you only need to rename the old domoticz.db file to something else and the new domoticz.fixed.db to domoticz.db.
Worth try?

Jos