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.forl...@tfl.gov.uk> 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… > 1. Click ‘Browse’ and check only the ‘User’ box in the object type > list > 2. Enter ‘<your domain>\<your username>’ in the ‘Enter the object > name to select’ and validate it by clicking ‘Check Names’ > 3. 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 > > 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: - 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