<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>