OK. Thank you
I have replicated your setup and file and folder ownership on the share and can't replicate the problem.
What sort of share is it? I have tested it with a Samba share on another linux machine.
What version of node-red-node-sqlite are you using?
It is a windows share (mounted CIFS) I'm using version 0.3.6.
I just tried it on on a different pi with new installed nodered:
I also created with user pi a new subfolder and moved the database into it.
Result: Error: SQLITE_BUSY: database is locked
Don’t move the database. Try with a new one.
I made it with a trick:
It is unclean but it works til a real solution is found.
I made a share on mi pi with SMB. I share now '/mnt/NVR/e to the second pi that is in use. I mounted the share on the second pi. I linked the Database to a Sqlite-node in the new installed nodered and could write data from there. So I wrote from Pi2 through the share on p1 to the share on a windows-system. that way works.
I didn't make a new database. It's same file.
I hope I expressed myself clearly.
So now I try to send the SQL via mqqt to nodered on pi2 and write it with a sqlite-node
Which shows that it IS a permissions issue I think.
To me it seems to be a CIFS - or a node(sqllite)issue
