Hi Andrea, Thank you for your input. I did play around with a Ubuntu server on AWS years ago and know exactly what you mean. The best I can do here (hopefully) is deploying GS as a TomCat webapp. I’m not convinced by the readonly explanation though. I was editing a local (to GS) gpkg file with QGIS (both directly and as a GS WFS) and changes were reflected by GeoServer immediately (after panning the map)… so that’s not the problem. I’ve got to identify the issue before raising it as one. As you said, it would be great finding someone who has experienced the same issue, even better, someone who resolved it. Armando
From: Andrea Aime <andrea.a...@geosolutionsgroup.com> Sent: 19 April 2024 14:24 To: Armando Forlani <armando.forl...@tfl.gov.uk> Cc: Jody Garnett <jody.garn...@gmail.com>; geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] invisible mapped/share drives in Store creation Armando, the problem is not using SQLite remotely (it works fine as long as the file is read only and not modified by other applications), but that you're on Windows, which is not the common way to deploy GeoServer (Linux deploys are, anecdotally, 30% faster on the same hardware, so they are the more common choice). The issue you're seeing needs some debugging, I'm confident they can be solved, but hardly on a mailing list, unless you find someone that already stumbled into the same issue. Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://bit.ly/gs-services-us<http://webdefence.global.blackspider.com/urlwrap/?q=AXicBcFNCsIwEAbQTzyDN3AldmJbRXGlKF24EDxC7J_BSUYmaaC39z3csF4Cr9UCyvOu6ihqJm8dtxKSClMrHvv6cX9y3ZTH8nCqcFVvQyfUiLIN7pIGplEyTV98UvqdjXm7RDybMRax1-zaPhZTBLDZAn-QfCKP&Z> for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions Group phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 https://www.geosolutionsgroup.com/ http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail On Fri, Apr 19, 2024 at 12:50 PM Armando Forlani <armando.forl...@tfl.gov.uk<mailto:armando.forl...@tfl.gov.uk>> wrote: 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<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<file://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<mailto:jody.garn...@gmail.com>> Sent: 18 April 2024 22:06 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 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<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
