*First, version numbers:*
My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface,
Kernel 4.15.0-52 Generic x86_64
The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user
interface, Kernel 4.4.0-141 Generic x86_64
SQLite Version 3.22.0
DB Browser for SQLite Version 3.10.1
Python 3.6.8
*Second, never assume:*
It may not be 'recommended' to access a sqlite database file on a network
share but that makes a lot of assumptions.
*Problem:*
The target sqlite3 database file is on a samba network share and mounted on
desktop with the following command:
sudo mount -o username=[myname],password=[mypw] -t cifs //[ipaddress]/kwpvr
/mnt/kwpvr
The file is marked readwrite for owner, group and others: -rw-rw-rw- 1
[myname] [myname] 40960 Jul 3 19:25 kwpvr3.db
The samba share is marked to allow create, delete and guest access
In Caja I can create, copy, delete, rename any file on that share.
When I open the file in DB Browser for SQLite I can browse the tables but I
can not change anything.
The error is: "attempt to write a readonly database"
In python I use the following line to open a sqlite connection:
sql3conn = sqlite3.connect("file:" + cfg["dbfile"] + "?mode=rw", uri=True)
That opens and works on a local file but not on the mounted file system.
I get the same error as above when trying to update a record.
So I fell back to the lowest common denominator: the SQLite3 command line
utility
Works fine locally but on the mounted file system I get the same error.
sqlite3 "file:/mnt/kwpvr/kwpvr3.db?mode=rw" "UPDATE Configuration SET
KeyValue='test' WHERE key='Active';"
*Question:*
Is this the intended behavior of sqlite3 or is this something unique to the
linux platform?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
