Hi,
Thank for answer and suggestions, I found solution to this particular problem as I didn’t put on my mount cifs setup an parameter *nolock* as it is described in this article. https://support.shotgunsoftware.com/hc/en-us/community/posts/209491808-Getting-database-is-locked-on-NFS-and-CIFS-setup Cheers, Miroslav Hrcan On Tue, Feb 4, 2020 at 7:46 PM Rahkonen Jukka (MML) < jukka.rahko...@maanmittauslaitos.fi> wrote: > Hi, > > > > Maybe unrelated to the problem that you have just now, but it is not > recommended by SQLite developers to use SQLite databases from network > drives. See for example > https://stackoverflow.com/questions/788517/sqlite-over-a-network-share/27457688 > . > > > > The risk of corrupting the database should not be so big if Geoserver just > reads the GPKG database and Geoserver is the only user, but poor > performance that is also mentioned is not what you want. If the GPKG > database is not huge if might be just better to copy it into local disk. > > > > That said, I do sometimes read GPKG databases through http connection over > the net with GDAL and its vsicurl mechanism and is does work quite well. So > you are free to play with Samba but you are warned. > > > > Maybe some troubles with locking could be avoided if Geoserver opened the > connection to SQLite as read-only. I am not sure if it happens already or > if is configurable. It might be a safe and useful option also with local > files. > > > > You sent the message through the geoserver-security mailing list. Thank > you for your responsibility but I do not see any security risk with just > this issue and I think that geoserver-users list is good place to continue > the discussion. > > > > -Jukka Rahkonen- > > > > *Lähettäjä:* Miroslav Hrćan <miro.hr...@gmail.com> > *Lähetetty:* tiistai 4. helmikuuta 2020 17.51 > *Vastaanottaja:* geoserver-secur...@lists.osgeo.org; Rahkonen Jukka (MML) > <jukka.rahko...@maanmittauslaitos.fi> > *Aihe:* geoserver gpkg on samba share issue > > > > Hi, > > Does someone have experience with GPKG stored on samba share and problem > with creating Store on GS? > > I have GS on apache tomcat on Linux Red Hat, and samba shared store > remotely on different network, mounted on tomcat user (as GS is running > with that user). > > There is no problem creating store from Linux host, but there is an error > on mounted samba share: “Unable to obtain connection: [SQLITE_IOERR] Some > kind of disk I/O error occurred (disk I/O error)”. > > Does anyone have a clue what is problem? > > Best regards, > > Miroslav Hrcan >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
