<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Steve,</p>
<p>thanks for confirming. I've just backported the fix to the 3.3
branch for the 3.3.1 release</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 23/06/2021 à 15:28, Steve Pritchard
a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAF7Aqmyg9i51PwtfDM74iB0VVdENwhNoCLvQTMDTh1XxtSkjpA@mail.gmail.com">
<div dir="ltr">
<div class="gmail_quote">
<div>Many thanks Even.</div>
<div><br>
</div>
<div>This fix doesn't seem to be in a release yet, but I've
managed to build GDAL from master, and this works correctly
with Oracle Wallet.</div>
<div><br>
</div>
<div>Steve</div>
<div>-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div><span>Steve Pritchard</span></div>
<div><span>Database Developer</span></div>
<div dir="ltr"><span><br>
</span></div>
<div dir="ltr"><span>British Trust for
Ornithology, The Nunnery, Thetford, Norfolk
IP24 2PU, UK </span><br>
<span>Tel: </span><a value="+441842750050"
moz-do-not-send="true">+44 (0)1842 750050</a><span>,
fax: </span><a value="+441842750030"
moz-do-not-send="true">+44 (0)1842 750030</a><br>
<span>Registered Charity No 216652 (England
& Wales) No SC039193 (Scotland)</span><br>
<span>Company Limited by Guarantee No 357284
(England & Wales)</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<div> </div>
<blockquote class="gmail_quote">Date: Mon, 14 Jun 2021
17:23:34 +0200<br>
From: Even Rouault <<a
href="mailto:even.rouault@spatialys.com" target="_blank"
moz-do-not-send="true">even.rouault@spatialys.com</a>><br>
To: <a href="mailto:gdal-dev@lists.osgeo.org"
target="_blank" moz-do-not-send="true">gdal-dev@lists.osgeo.org</a><br>
Subject: Re: [gdal-dev] OCI vector driver - could support be
added for<br>
Oracle Wallet? (simple change?)<br>
Message-ID: <<a
href="mailto:402aeda2-9b94-c1d8-0788-ac7187bacffe@spatialys.com"
target="_blank" moz-do-not-send="true">402aeda2-9b94-c1d8-0788-ac7187bacffe@spatialys.com</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Steve,<br>
<br>
I believe <a href="https://github.com/OSGeo/gdal/pull/3784"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://github.com/OSGeo/gdal/pull/3784</a>
has fixed that (in the <br>
master branch)<br>
<br>
Even<br>
<br>
Le 14/06/2021 ? 17:18, Steve Pritchard a ?crit?:<br>
> Oracle Wallet provides secure storage for usernames and
passwords on <br>
> client devices. We use this to avoid having usernames
and passwords in <br>
> scripts, etc. For details see "Using The Secure
External Password <br>
> Store (Doc ID 340559.1)" on the Oracle Support website.<br>
><br>
> I have tried using Oracle Wallet with ogrinfo and the
OCI driver, e.g.:<br>
><br>
> ogrinfo OCI:/@db_name:table_name<br>
><br>
><br>
> however I always get:<br>
><br>
> ERROR 1: ORA-01017: invalid username/password;
logon denied<br>
> ?in <unnamed><br>
> ERROR 1: ORA-01017: invalid username/password;
logon denied<br>
> ?in <unnamed><br>
> FAILURE:<br>
> Unable to open datasource `OCI:..' with the
following drivers.<br>
><br>
><br>
> I have tried this both with the bundled Oracle Instant
Client and with <br>
> the latest Instant Client from the Oracle website. I've
also tested <br>
> Oracle Wallet with other open source software (e.g.
Perl DBI), and <br>
> that works fine.<br>
><br>
> Having looked at the source?code for?ogrocisession.cpp,
it looks as <br>
> though a simple change might be sufficient to make this
work...<br>
><br>
> I think that the reason it doesn't work is because the
"eCred" <br>
> parameter needs to be OCI_CRED_EXT for Oracle Wallet.
But eCred is set <br>
> to?OCI_CRED_RDBMS, except where OS authentication is
being used.<br>
><br>
> So if?pszUseridIn = "" and?pszPasswordIn = "", can
eCred be set to <br>
> OCI_CRED_EXT?<br>
><br>
> (Notes on using Oracle Wallet with Oracle OCI can be
found in the <br>
> answer tothis stackoverflow question <br>
> <<a
href="https://stackoverflow.com/questions/21762885/using-oracle-wallet-authentication-from-oci"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://stackoverflow.com/questions/21762885/using-oracle-wallet-authentication-from-oci</a>>)<br>
><br>
> Steve<br>
</blockquote>
</div>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><span></span><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>