[Geoserver-users] invisible mapped/share drives in Store creation

Hi Andrea and Jody,

I RESOLVED my issue taking clues from this

https://superuser.com/questions/1758898/service-is-not-able-to-access-a-network-drive-mapping-despite-running-under-the

…which led to this:

https://learn.microsoft.com/en-us/answers/questions/1168194/how-run-windows-services-as-the-current-user-when

…and tried a few things but essentially the Windows service has to be started as the user logging in the machine and has access to the shared folders (default is ‘Network Service’):

···
  1. Go to the Service console via services.msc
  2. Locate the GeoServer service
  3. Set manual start/stop and stop the service
  4. Properties à Log On
  5. Change ‘This account’ value…
  6. Click ‘Browse’ and check only the ‘User’ box in the object type list
  7. Enter ‘<your username>’ in the ‘Enter the object name to select’ and validate it by clicking ‘Check Names’
  8. OK1. Start service

Hopefully I was the only one experiencing this issue, but if there are others… this should be of some use.

Thanks,

Armando

Original issue:

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

Hi Armando,
yes that’s what we were expecting, thanks for sharing step by step instructions on how to get it fixed

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us 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

So it was an operating system permission issue? if you have guidance to add to the docs it would be appreciated …

···


Jody Garnett

Hi Jody,

I’ll have a look at how I can contribute to the doc. This is however a temporary solution as the Windows service method was the easiest way to get this up and running quickly.

Having a user to start the service so that GeoServer has access to the network folders shared with this one user… it’s not really a solution. There must be a way in Windows to somewhat allow folders access to the service itself rather than a particular user (security may be an issue with this).

Having said that, we’ll likely deploy GeoServer as a TomCat servlet (I believe this is the preferred options suggested in the documentation) and setup LDAP logins (as authentication provider) making use of existing AD groups and all that. Am I right to assume GeoServer would see the folders/mapped drives of the user logged into it? Even if GeoServer was started as a service (TomCat webapp)? In other words, does GeoServer delegate shared folder access to Windows through LDAP?

Please note that, although the intention is to couple a database with GeoServer (either Oracle or PostgreSQL), I find the use of GeoPackage files on network folder a really good addition to GeoServer and invaluable to visualise the output of small projects/analyses.

Thanks,

Armando

···

From: Jody Garnett <jody.garnett@…84…>
Sent: 24 April 2024 18:07
To: Armando Forlani <Armando.Forlani@…11978…>
Cc: Andrea Aime <andrea.aime@…10949…>; geoserver-users@lists.sourceforge.net
Subject: Re: invisible mapped/share drives in Store creation

So it was an operating system permission issue? if you have guidance to add to the docs it would be appreciated …

Jody Garnett

On Fri, Apr 19, 2024 at 8:20 AM Armando Forlani <Armando.Forlani@…11978…> wrote:

Hi Andrea and Jody,

I RESOLVED my issue taking clues from this

https://superuser.com/questions/1758898/service-is-not-able-to-access-a-network-drive-mapping-despite-running-under-the

…which led to this:

https://learn.microsoft.com/en-us/answers/questions/1168194/how-run-windows-services-as-the-current-user-when

…and tried a few things but essentially the Windows service has to be started as the user logging in the machine and has access to the shared folders (default is ‘Network Service’):

  1. Go to the Service console via services.msc

  2. Locate the GeoServer service

  3. Set manual start/stop and stop the service

  4. Properties à Log On

  5. Change ‘This account’ value…

  6. Click ‘Browse’ and check only the ‘User’ box in the object type list

  7. Enter ‘<your username>’ in the ‘Enter the object name to select’ and validate it by clicking ‘Check Names’

  8. OK

  9. Start service

Hopefully I was the only one experiencing this issue, but if there are others… this should be of some use.

Thanks,

Armando

Original issue:

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

這樣 算我剛好有血腥照 不算個懶叫臉

d1grfy39ztai4o.cloudfront.net/sites/default/files/images/membership/benefits/acp-email-sig-master-rgb.png

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4WvVpxjs39JiWs0DlQpEDVPkVE8zWQ_yXGWqg_yEb6vXZ24BowbRPs17KvXc9aKbwA2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4R628Y5kGJdc_10NW9GpxbnhgdGNZ5xMbT1jQXXNPJtTfWjtvy3ThXWoYVLCI27w4w2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4cCq_IplesTWlVAxoy-Qwa-HNYukWA6f5lglWxqhjzsLN40nJWtXRp7PtdrYsRjrJA2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4VkVFopYiUkfc_mv8OKLoAoR909AjIzeIUx9625jzV_yoXv6146rjwe1lJJVLk5wLw2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4R84IGhhWCaLLvo-yKkiNIzGZKZJrKlz1iH2RqD8QWbQLyiBBx7HsvfqPFv1KM9HYw2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4btk7hYWQg1z2kX5nceTBeZl0CLQkuqczRh2CGMVyUH-4i4SvXVCXqKsa-Sqund4EA2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4bKB9i5JcPA7K-SjEXcuPVVVrXzaRGTMZefhtJAvGOh_zYa1TCmaxzxu3qmE3tiZUg2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4accNHXz-lYTJ0NRgvdwv3rDVqRv_U1pjJYM7_07_QhiIWx0Zp-n-gfXbi5Y0t6Lfw2

https://membersuite.aala.org.au/Sys/Profile/PhotoGallery/43401/0/226431?memberId=57474101&dh=24&cppr=0

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4XveGEGMqpC9PNldWuG5ANmeZvBlYhDALnTvm6iu4LT-ulT1E8T_YB2KqDhbT4JycA2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4SzN0476R5hPkVEPdTqOAxxFFbFR4EgPlN7QOlUJPjATmSA-zBgdW12y7WlxWjYZ8w2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4UDQ-nLw95DqsZJ7pTPY6Aq0i-7l-_Su8wILhkl6AgsfQLe5fdN8OQsPzD4bPp9EWQ2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4bXgChfdh9AR9OAygHxsGgXdxfZCPNqwdaL_9of_lRbiPcTwkJMRd4ZG-CCW7Ewh4Q2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4amezH8y5IVXnoHqq2yY0mfBMRVjI6PXuWJyGoPinVNxhy_JWn2aLpz1HmrHwA3EeQ2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4dwBgTDB2jyXS_kePhssCzESNnQRrQh_sjZzo2sVjCwAg5zg-ZiqKieioz_Uog545Q2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4dwBgTDB2jyXS_kePhssCzESNnQRrQh_sjZzo2sVjCwAg5zg-ZiqKieioz_Uog545Q2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4SqvOZfWLrRfNy_78c_wIcXrn5ZuRQpiM2nx_mNeBfUcYciShWD06cT2fO6wCY_MkA2

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4SqvOZfWLrRfNy_78c_wIcXrn5ZuRQpiM2nx_mNeBfUcYciShWD06cT2fO6wCY_MkA2

https:royalairforcesassociation.my.site.comcommunitysmy-details ID:00597651

https://membersuite.aala.org.au/resources/photo/uTljNHN_T9II2VPclRSi4eNGxo-iDlx56HJskPvqiCgSwf09BXS9R6u9s_iz4HlVFpFNCS2VqbU4CKumISoOHA2

在 2024年4月25日 星期四 下午06:13:20 [GMT+8], Armando Forlaniarmando.forlani@anonymised.com 寫道:

Hi Jody,

I’ll have a look at how I can contribute to the doc. This is however a temporary solution as the Windows service method was the easiest way to get this up and running quickly.

Having a user to start the service so that GeoServer has access to the network folders shared with this one user… it’s not really a solution. There must be a way in Windows to somewhat allow folders access to the service itself rather than a particular user (security may be an issue with this).

Having said that, we’ll likely deploy GeoServer as a TomCat servlet (I believe this is the preferred options suggested in the documentation) and setup LDAP logins (as authentication provider) making use of existing AD groups and all that. Am I right to assume GeoServer would see the folders/mapped drives of the user logged into it? Even if GeoServer was started as a service (TomCat webapp)? In other words, does GeoServer delegate shared folder access to Windows through LDAP?

Please note that, although the intention is to couple a database with GeoServer (either Oracle or PostgreSQL), I find the use of GeoPackage files on network folder a really good addition to GeoServer and invaluable to visualise the output of small projects/analyses.

Thanks,

Armando

From: Jody Garnett jody.garnett@anonymised.com
Sent: 24 April 2024 18:07
To: Armando Forlani Armando.Forlani@anonymised.com
Cc: Andrea Aime andrea.aime@anonymised.com; geoserver-users@anonymised.comts.sourceforge.net
Subject: Re: invisible mapped/share drives in Store creation

So it was an operating system permission issue? if you have guidance to add to the docs it would be appreciated …

Jody Garnett

On Fri, Apr 19, 2024 at 8:20 AM Armando Forlani <Armando.Forlani@anonymised.com978…> wrote:

Hi Andrea and Jody,

I RESOLVED my issue taking clues from this

https://superuser.com/questions/1758898/service-is-not-able-to-access-a-network-drive-mapping-despite-running-under-the

…which led to this:

https://learn.microsoft.com/en-us/answers/questions/1168194/how-run-windows-services-as-the-current-user-when

…and tried a few things but essentially the Windows service has to be started as the user logging in the machine and has access to the shared folders (default is ‘Network Service’):

  1. Go to the Service console via services.msc

  2. Locate the GeoServer service

  3. Set manual start/stop and stop the service

  4. Properties à Log On

  5. Change ‘This account’ value…

  6. Click ‘Browse’ and check only the ‘User’ box in the object type list

  7. Enter ‘<your username>’ in the ‘Enter the object name to select’ and validate it by clicking ‘Check Names’

  8. OK

  9. Start service

Hopefully I was the only one experiencing this issue, but if there are others… this should be of some use.

Thanks,

Armando

Original issue:

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


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

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

images - 2024-04-25T174711.370.jpeg