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…
* Click ‘Browse’ and check only the ‘User’ box in the object type list
* Enter ‘<your domain>\<your username>’ in the ‘Enter the object name to
select’ and validate it by clicking ‘Check Names’
* OK
6. 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<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
_______________________________________________
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
