Hello,
I'm devolping a mall tool in python which uses several sqlitedatabases for storing the data. At the moment the tool ist importing regular during the night data into the database, so that I can use the data during the day. The Problem is, that my data is always round about 12 hours behind live which now is getting sometime a problem. Thats why I want to migrate my data to sqlite db server. First of all I installed the vserver on my kali linux desktop pc and stored the databases on a Synology NAS and mounted the folder. That works perfect, that mean I can access the databases from Valentin Studio Pro from the same computer. For thee future I want to migrate the server to a Raspberry PI 4 with 4GB RAM. I allready did that and did the same configuration. When I now try to connect to the sqliteserver from my KALI-Linux PC using Valentin Studio it works and I also can see the sqlite databases, which still are stored on the Synology NAS. The Problem is, that I can't open the databases, because already give me the message ERROR 0x68500: Sqlite db "block_000000_200000.db": Error : "unable to open database file".
That are the same files I can open when I run the server on the KaliLinux and connect withe Valentin Studio Pro to localhost. Attached you can find a screenshot of the error message and the two server logfiles. I added in the logfilename a hint to the system (Kali or RPI4). I already search for a solutions since 3 days now but I do not have any other idea.
Can somebody help me with this problem?
Thank you very much in advance.
Fabian