[gdal-dev] OCI vector driver - could support be added for Oracle Wallet? (simple change?)

[Even Rouault]

Steve,

I believe https://github.com/OSGeo/gdal/pull/3784 has fixed that (in the 
master branch)

Even

Le 14/06/2021 à 17:18, Steve Pritchard a écrit :
> Oracle Wallet provides secure storage for usernames and passwords on 
> client devices. We use this to avoid having usernames and passwords in 
> scripts, etc. For details see "Using The Secure External Password 
> Store (Doc ID 340559.1)" on the Oracle Support website.
>
> I have tried using Oracle Wallet with ogrinfo and the OCI driver, e.g.:
>
>     ogrinfo OCI:/@db_name:table_name
>
>
> however I always get:
>
>     ERROR 1: ORA-01017: invalid username/password; logon denied
>      in <unnamed>
>     ERROR 1: ORA-01017: invalid username/password; logon denied
>      in <unnamed>
>     FAILURE:
>     Unable to open datasource `OCI:..' with the following drivers.
>
>
> I have tried this both with the bundled Oracle Instant Client and with 
> the latest Instant Client from the Oracle website. I've also tested 
> Oracle Wallet with other open source software (e.g. Perl DBI), and 
> that works fine.
>
> Having looked at the source code for ogrocisession.cpp, it looks as 
> though a simple change might be sufficient to make this work...
>
> I think that the reason it doesn't work is because the "eCred" 
> parameter needs to be OCI_CRED_EXT for Oracle Wallet. But eCred is set 
> to OCI_CRED_RDBMS, except where OS authentication is being used.
>
> So if pszUseridIn = "" and pszPasswordIn = "", can eCred be set to 
> OCI_CRED_EXT?
>
> (Notes on using Oracle Wallet with Oracle OCI can be found in the 
> answer tothis stackoverflow question 
> <https://stackoverflow.com/questions/21762885/using-oracle-wallet-authentication-from-oci>)
>
> Steve
> -- 
> Steve Pritchard
> Database Developer
>
> British Trust for Ornithology, The Nunnery, Thetford, Norfolk IP24 
> 2PU, UK
> Tel: +44 (0)1842 750050, fax: +44 (0)1842 750030
> Registered Charity No 216652 (England & Wales) No SC039193 (Scotland)
> Company Limited by Guarantee No 357284 (England & Wales)
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210614/832938dc/attachment.html>