Hi, I understand the limitation of querying a sqlite file remotely, but this works just fine on clients such as QGIS (that’s likely because Client Application and SQLite Database Engine sit together? Unlike GeoServer? As your link suggest).
It is not possible for me to move all GeoPackage files on the same machine with GeoServer. I’m not interfering in how various teams manage and store their data. It simply not going to happen. Yes, we do have the usual suspect “enterprise” GIS stack. Here I’m attempting to also have a full open source stack e.g. postgres/postgis+geoserver(+geonetwork) initially for particular case scenarios and purposes. The addition of GeoPackage as a Store in GS is brilliant and, in theory, makes it easier to set up not just a demo, but a fully working, if not a little bit simplistic, open source GIS stack. There is no warnings in the GS docs that it’s not possible to connect to sqlite remotely. The interface lets me happily attempt such connection. In which case it should only be a performance issue rather than the outright inability to connect: Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file). So, does this file:////DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg ..return Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file) ..because there is something wrong in the path, shared folder permission (even if visible in the file explorer on the same machine where GS is installed), etc.. OR is it simply not allowed (either by GS or the sqlite driver)? I tried setting up a shapefile store (I believe GS won’t attempt a connection just yet, it did not complain), then create a layer from the only shp file in the store (a path to the file really), it returns a java error output…: Caused by: java.io.FileNotFoundException: \\DOMAIN.LOCAL\SHARED\shared_folder\folder\layer.shp (Access is denied) That ‘Access is denied’ suggests that it’s not the type of store but something to do with GS accessing remote locations. From: Jody Garnett <jody.garn...@gmail.com> Sent: 18 April 2024 22:06 To: Armando Forlani <armando.forl...@tfl.gov.uk> Cc: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] invisible mapped/share drives in Store creation Here: https://www.sqlite.org/useovernet.html -- Jody Garnett On Thu, Apr 18, 2024 at 8:49 PM Armando Forlani <armando.forl...@tfl.gov.uk<mailto:armando.forl...@tfl.gov.uk>> wrote: Hi Jody, I’m not sure I understand this. I regularly use these files (usually gpkg) with QGIS doing read/write. All these files are on network file system (in a shared folder somewhere on the network) and have no problems at all. Even views I created within sqlite/gpkg files work fine. What I’m really looking for first is the answer on whether GeoServer has such limitation i.e. cannot see shared drives. If no such limitation exists then how do I fix this? From: Jody Garnett <jody.garn...@gmail.com<mailto:jody.garn...@gmail.com>> Sent: 18 April 2024 18:50 To: Armando Forlani <armando.forl...@tfl.gov.uk<mailto:armando.forl...@tfl.gov.uk>> Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net> Subject: Re: [Geoserver-users] invisible mapped/share drives in Store creation This is a limitation of the SQLite database, remember the driver is a full database, which places performance and reliability requirements on the file system that a network file system cannot meet. -- Jody Garnett On Thu, Apr 18, 2024 at 1:45 PM Armando Forlani <armando.forl...@tfl.gov.uk<mailto:armando.forl...@tfl.gov.uk>> wrote: Hi, I’m creating a new Store using a GeoPackage file as data source (database). It works fine with a gpkg file saved locally i.e. anywhere on the C: drive. I’m unable to make it work with files stored on a share drive, either the full path or a logical drive letter. file://J:/folder/data.gpkg<file:///J:/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: path to 'J:\folder\data.gpkg': 'J:\' does not exist file:\\J:\folder\data.gpkg<file:///J:/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: path to 'J:\folder\data.gpkg': 'J:\' does not exist file:////DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg<file://DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file) file:\\\\DOMAIN.LOCAL\SHARED\shared_folder\folder\data.gpkg<file://DOMAIN.LOCAL/SHARED/shared_folder/folder/data.gpkg> Error creating data store, check the parameters. Error message: Unable to obtain connection: [SQLITE_CANTOPEN] Unable to open the database file (unable to open database file) It is also impossible making use of the ‘Browse…’ link next to the ‘database’ edit box. It won’t list any mapped drives in the drop down list. Only ‘Data directory’, ‘Home directory’, A:\, ‘OS Disk (C:)’, D:\ are shown. Moving data locally is not an option. Running: Windows 10 Enterprise VMware Virtual Platform Eclipse Adoptium: 17.0.10 (OpenJDK 64-Bit Server VM) GeoServer 2.24.2 as a Windows service Any help would be really appreciated. Thanks, Armando This message has been scanned for malware by Forcepoint. www.forcepoint.com<http://www.forcepoint.com/> _______________________________________________ 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<mailto:Geoserver-users@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/geoserver-users
_______________________________________________ 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
