I find the problem of this.
If i change the pragma journal mode from Wall to Off there is no error anymore.

Now is my question how can i change this on a command line in linux ???

I don,t tink it has to do with permissions. Gif both directory and file full permision.

Looks like the plugin can not handle read only databases

error checking db: error checking for valid SQLite file: attempt to write a readonly database (1544)

When i put the databse on the root the plugin can find it but when i put it in the tmp dir is does not .

/backup.db all is ok
/tmp/backup.db error checking db: no file exists at the file path

That might be a solution. My main goal is to have the data available for a longer period of time, preferably in an sql database. I hear you say Influxdb, but that has a number of limitations for me. I would prefer to transfer the data from different sensors and meters every day from the domoticz ...

Read this thread with attention but I wonder if this is what I'm looking for. I would like my domoticz data in a different database than what I do now Influxdb. And then you can keep the date for a longer period of time. I've also looked at the author's sites, but I'm dizzy with the many scripts for ...

No i do not have a file like that in my backup directory.
But i find the variable $ftpsite nowhere in the scrip.
Maby thats the problem ?

Hi, I am using the backup script below which I found on domoticz wiki site. The backup part works great but I can't get the last part where folders older than xx days have to be deleted. #!/bin/bash # Sript to automatic backup some stuff from Domoticz # Run script every day from crontab. # Example ...

Correct I use a backup of the database which is updated every night. I don't have the data of the current day, but that's no problem for me. And so I stay on the safe side.

It works ....
I have change the journal_mode from wall to delete and now i can acces the domoticz.db without any problem..
Find info here
https://www.sqlite.org/pragma.html#pragma_journal_mode

Hello, I still get a error when i wnt to install datasource error checking db: error checking for valid SQLite file: attempt to write a readonly database (1544) I have make a backup of the database and store it . The ownerschip is root with all rights 755 Is this plugin still working with beta of ...

It would be nice if you could indicate within the script on which date you want to start. As it is now a year is known from the present day as far as the annual calculations are concerned I think.. So it starts when my energie contract starts

I have read this topic with great interest and as a newbie to Dzvents scripting. I've tried to run the script discussed here, but it doesn't work. What I want to do with the script is the following. I have a script for 'Gas per Degree Day' that I want to send the value to influx. The value appears ...

hello,
I wondering if i can switch programs in my Isense thermo with domoticz.
Swithc between Program-A , Program-B , Continius Day or Continius night ??

Recently I replaced my old raspberry with a raspberry pi4. I only run Domoticz on this. On another raspberry pi3b+ I have Influxdb and Grafana running. I have Domoticz send data to Influxdb. Previously this went without any problems. Even now it seems to be going fine. However, every now and then I ...