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
