Re: perl DBD::Oracle and external password store

From: John Scoles <scoles_at_pythian.com>
Date: Mon, 15 Dec 2008 09:32:46 -0500
Message-ID: <49466A8E.1090707@pythian.com>


I checked the OCI docs and there is noting special DBD::Oracle has to do to use this store. It just has to be properly configured and you have to use a version of DBD:ORacle over 1.17 and a 10 client.

Looking into the code a little more DBD::ORacle before 1.17 uses the old deprecated Proc connection methods to set up the environment. Later versions use the newer OCIEnvNlsCreate methods which should be compatible with the store

Cheers
John Scoles

Jared Still wrote:
> Wrong list.
>
> You need to go to http://lists.cpan.org/, find the dbi-users list, and
> sign up for that.
>
> No idea if the external password store works with it.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
> On Fri, Dec 12, 2008 at 2:34 PM, Wang, Tao <twang_at_iso-ne.com
> <mailto:twang_at_iso-ne.com>> wrote:
>
> I am trying to use perl DBI to connect oracle databases using the
> secure external password store introduced in oracle 10gR2. It
> works great when I use sqlplus connect after setting up the wallet
> and sqlnet.ora. And jdbc thick driver [jdbc:oracle:oci8] seems to
> be working fine with external password store as well. but I can
> not get it to work using perl DBI module, and I keep getting
> invalid username/password, or invalid names Does anyone know if
> the perl DBI/DBD module work with external password store? Anyone
> has some experience with it? Any suggestion is great appreciated!
>
>
>
>
>
> I tried it on DBD:ORACLE version: 1.15 DBI version: 1.42 with
> oracle 10g2 client installed.
>
>
>
>
>
> Thanks,
>
> Tao
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 15 2008 - 08:32:46 CST

Original text of this message