Re: perl DBD::Oracle and external password store

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sun, 14 Dec 2008 19:07:20 +0100
Message-ID: <486b2b610812141007y75f59398yeff9c645d65d91a9@mail.gmail.com>


Did you try just passing an empty string (not undef) as username/password ? Not tested but might work, as DBI probably uses oracle net under the hood as well (?), and if it does, oracle net might just take care of opening the wallet to get the username/pass from there automatically. Worth a shot ?

Stefan

On Sun, Dec 14, 2008 at 4:47 PM, <scoles_at_pythian.com> wrote:

> > Wrong list.
>
> Well almost I hang out here lurking for questions like this.
>
> I maintain the DBD::Oracle and I can say I guess it does not presently
> support it that I know of.
>
> If there is an OCI method I can add it in quite easily but on first glace
> I cannot see any oci methods for it,
>
> Give me a few days to look at it.
>
> Cheers
> John Scoles
> >
> > 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> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Dec 14 2008 - 12:07:20 CST

Original text of this message