This is to do with the permissions of the user running geoserver, it has nothing to do with what works when you are running qgis as you almost certainly have permissions to work on the shared drive. The user that is running the GeoServer service doesn't have permission to access that drive as it hasn't logged in.
Ian On Fri, 19 Apr 2024 at 15:34, Armando Forlani <armando.forl...@tfl.gov.uk> wrote: > QGIS is working fine with GeoServer services (with stores/layers that > work). I think the problem is related to this: > > > https://superuser.com/questions/1758898/service-is-not-able-to-access-a-network-drive-mapping-despite-running-under-the > > > > > > *From:* Andrea Aime <andrea.a...@geosolutionsgroup.com> > *Sent:* 19 April 2024 15:27 > *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 > > > > One way to find out quickly if it's related to the account used to run > GeoServer as a service, > > it's to get on the machine where QGIS is working fine, install GeoServer > but not let it run > > as a service... and start it manually, from the windows menu. That way it > works with the > > same rights. Does it work then? If yes, you have issues with the limits of > the service account. > > Otherwise, there is something likely to debug in the GeoServer code itself. > > > Regards, > > Andrea Aime > > > > == > GeoServer Professional Services from the experts! > > Visit http://bit.ly/gs-services-us > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicBcExEoIwEAXQ73AGb2DlyAYNBWOlhRR2HCFGxOiSdTYhM9ze91BhVwHDdgPltek-lLTQ7AJ7iVmFycuM1t5vQ7F9a0_HrsFVZxefQr0ouxgu-cU0SaHli3fOv7Mxj5CJVzOlOo1agh9TvSQA-wPwB3sVImM&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://webdefence.global.blackspider.com/urlwrap/?q=AXicFcy9DcIwEAbQL2IGNqBC6BxwiogKClLQZQQrgAk5-yL_iu0Rb4CHBrsNMG4bBP62_YdiKOTMzJP4FIRpEodO329j0UOnT8e-xTU44x9CgwQ2fr6kF5OVQnnBO6U1npWqtZJ9ShTOaRYfbZC8_i8FYH8AfnOYJVo&Z> > > http://twitter.com/geosolutions_it > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicFcsxDsIwDAXQX3EGbsCEkFNIh4oJBjqw9QQoKqWkODFK3CBuj3j7Q4XNCujXFRJ_63amnAoF53mQqEmYBglo7PXSF9s19rBva5xTcPEu1EliF_1JH0yTFFpeeKq-j8box6uO6Z_NNEoWXtRLzDevALY74AdvaSV2&Z> > > ------------------------------------------------------- > > > 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 4:17 PM Armando Forlani < > armando.forl...@tfl.gov.uk> wrote: > > 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://webdefence.global.blackspider.com/urlwrap/?q=AXicFcy9DcIwEAbQL2IGNqBC6BxwiogKClLQZQQrgAk5-yL_iu0Rb4CHBrsNMG4bBP62_YdiKOTMzJP4FIRpEodO329j0UOnT8e-xTU44x9CgwQ2fr6kF5OVQnnBO6U1npWqtZJ9ShTOaRYfbZC8_i8FYH8AfnOYJVo&Z> > > http://twitter.com/geosolutions_it > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicFcsxDsIwDAXQX3EGbsCEkFNIh4oJBjqw9QQoKqWkODFK3CBuj3j7Q4XNCujXFRJ_63amnAoF53mQqEmYBglo7PXSF9s19rBva5xTcPEu1EliF_1JH0yTFFpeeKq-j8box6uO6Z_NNEoWXtRLzDevALY74AdvaSV2&Z> > > ------------------------------------------------------- > > > 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> 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 > > ..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 > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicBcExEoIwEAXQz3gGb2DlOBsUCsZKCynsOAKDEdBNVjdLGG_veyiw2wDdtoDyr2xelDRT6GceJJoK0yABdXW_dblq6-p0bEpcNfTxIdSKch_niz2ZRsm0vDGZfdLZuXVdKX15Nk-io1uSl-w1eqPJAgPYH4A_D9gm0A&Z> > > > -- > > Jody Garnett > > > > > > On Thu, Apr 18, 2024 at 8:49 PM Armando Forlani < > 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> > *Sent:* 18 April 2024 18:50 > *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 > > > > 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> 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 > > 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 > > 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 > > 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 > > 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://webdefence.global.blackspider.com/urlwrap/?q=AXicFcyxDcIwEAXQHzEDG1AhdA44RUQFBSnoMoJlCJjYvug4bLE94g3w0GCzAsZ1A4nftn_RWwolF6LnrMKRPCd09noZix06e9j3Lc6SXL4xDSzR5XDSKdKDC31mPFWXozG1VppY_H3hkPV_GADbHfADODMhyA&Z> > > _______________________________________________ > 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#/ > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicFcxNDoIwEAbQj3gGT6ArY6YoLAgrXcjCHUdoMPzItGPaoY23N74DPBQ47oB-XyDwt2zeFEMiZxcexGsQpkEc6ur56FPV1dX10pS4B2f9S6iTwNYvNx2ZJkm0rZhVP60xOWdarNctqPh_YdTyGs0oMdYTzer4YACczsAPAuUoTA&Z> > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicDcwxEoIwEAXQ73gGb2Dl6AaFgrHSQgo7jsBADNFN1tmEzHh7aV_xsMF-C_S7DZR_VfumpIXC4HmUmFWYRglo6uejL3XX1JdzW-GuYYiTUCfKQ_S3_GJyUmj5YM75ezXGWUlWi1USdWYtgllWYJ_yyS1-suyjTTTnwAAOR-APFq4rZg&Z> > > 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 > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicTYxNEgExEIVbOYMbWCnJYCyUFQtU2SkniNGTCUmaTifK7f1t7N6r970PejDsAxwGPWD_nCwuOnHRwTjfUBQmrxsKMK_3m0Opt_N6Nl1MYM3BxDPpLbE30a2k9dpS0fkKncgtLavKOuny6XOuLFJCLsh_6eGurjrmpsGU2uz9UzHeMyZx0aq3W7koaNl8e8SHatFIZky_MdyYCgaMkt6k2iEdv14AGI0BXiL_SPU&Z> > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicJchBDoIwEEbhn3gGb-DK6IDCgrjShSzccQRSCxZLx8y0Tby9RjfvSx4KbFZAvy4g_l21M6lkWgbnDYco7Mnwgqa-Xftcd019PLQVLrIM4c7UsfghuHMcPU2cKT3xiPGlp7L0TqOSchJjR5bJUrDxf391YeRysqxWspV9-qoAtjvgAwCuL54&Z> > > _______________________________________________ > 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#/ > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicFcxNDoIwEAbQj3gGT6ArY6YoLAgrXcjCHUdoMPzItGPaoY23N74DPBQ47oB-XyDwt2zeFEMiZxcexGsQpkEc6ur56FPV1dX10pS4B2f9S6iTwNYvNx2ZJkm0rZhVP60xOWdarNctqPh_YdTyGs0oMdYTzer4YACczsAPAuUoTA&Z> > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicDcwxEoIwEAXQ73gGb2Dl6AaFgrHSQgo7jsBADNFN1tmEzHh7aV_xsMF-C_S7DZR_VfumpIXC4HmUmFWYRglo6uejL3XX1JdzW-GuYYiTUCfKQ_S3_GJyUmj5YM75ezXGWUlWi1USdWYtgllWYJ_yyS1-suyjTTTnwAAOR-APFq4rZg&Z> > > 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 > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicTYxNEgExEIVbOYMbWCnJYCyUFQtU2SkniNGTCUmaTifK7f1t7N6r970PejDsAxwGPWD_nCwuOnHRwTjfUBQmrxsKMK_3m0Opt_N6Nl1MYM3BxDPpLbE30a2k9dpS0fkKncgtLavKOuny6XOuLFJCLsh_6eGurjrmpsGU2uz9UzHeMyZx0aq3W7koaNl8e8SHatFIZky_MdyYCgaMkt6k2iEdv14AGI0BXiL_SPU&Z> > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > <http://webdefence.global.blackspider.com/urlwrap/?q=AXicJchBDoIwEEbhn3gGb-DK6IDCgrjShSzccQRSCxZLx8y0Tby9RjfvSx4KbFZAvy4g_l21M6lkWgbnDYco7Mnwgqa-Xftcd019PLQVLrIM4c7UsfghuHMcPU2cKT3xiPGlp7L0TqOSchJjR5bJUrDxf391YeRysqxWspV9-qoAtjvgAwCuL54&Z> > > _______________________________________________ > 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 > -- Ian Turton
_______________________________________________ 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
