Error : "Error: Error opening SQLite3 database: unable to open database file"

[reza]

hi guys
version 2024.4
raspberry pi 4

some times when i unplug/plug power supply of raspberry , domoticz go to offline , when i want run this manually with this command "./domoticz" i have this error :

Error opening SQLite3 database: unable to open database file

Of course, I have made a change in Raspberry. After all the settings in domoticz, I put my sd card in read-only mode. Could it be because of this or is the problem from somewhere else?

[willemd]

hi guys
version 2024.4
raspberry pi 4

some times when i unplug/plug power supply of raspberry , domoticz go to offline , when i want run this manually with this command "./domoticz" i have this error :

Error opening SQLite3 database: unable to open database file

Of course, I have made a change in Raspberry. After all the settings in domoticz, I put my sd card in read-only mode. Could it be because of this or is the problem from somewhere else?

I don't think "./domoticz" is the way to start domoticz.
Try "sudo service domoticz start"
(not sure of the sudo is needed)

[reza]

[/quote]

I don't think "./domoticz" is the way to start domoticz.
Try "sudo service domoticz start"
(not sure of the sudo is needed)
[/quote]

my domoticz is in startup and always auto start. but some time with unplug/plug or reboot can not auto start and i check with ./domoticz for see errors. i see i have this error . after several reboot or several unplug/plug again auto startup domoticz and worked. but this is not true and Annoying

[waltervl]

hi guys
version 2024.4
raspberry pi 4

some times when i unplug/plug power supply of raspberry , domoticz go to offline , when i want run this manually with this command "./domoticz" i have this error :

Error opening SQLite3 database: unable to open database file

Of course, I have made a change in Raspberry. After all the settings in domoticz, I put my sd card in read-only mode. Could it be because of this or is the problem from somewhere else?

If your Domoticz database is also on that read-only sd card than this probably is the reason your Domoticz will not work....

[reza]

If your Domoticz database is also on that read-only sd card than this probably is the reason your Domoticz will not work....
[/quote]

I do read-only for protect sd card (stop crash SD)
so are there any solution for protect sd card?

[waltervl]

The database needs to be updated somehow on a disk. So you need a writable disk. You could invest in adding an SSD to your Pi. Or use an high quality SD