RE: Problems with external password store.

I am rebuilding my DBD installation on server A  (the one
where Oracle Wallet didn't work)

I set my environment for oracle 10g, then did the
install again.

I have wallet working, but every time I run a script I
get two copies of a dld.sl error for libclntsh.sl.10.1

I think I can live with that for awhile and try to 
clean it up on a scheduled maintenance day.  I'll do
a $ORACLE_HOME/bin/genclntsh and see if that helps.

I have to tell you all, I love DBI/DBD and use it a lot.
But the installation has always seemed to be difficult,
and it keeps me from being enthusiastic to throw on the
latest releases.  When I get it working I just leave
it alone.  Not that I don't sympathize with the difficulty
of building an install that works against Oracle, particularly
in the pre-8 days.  And I'm on HP-UX which also has
it's quirks.



> -----Original Message-----
> From: John Scoles [mailto:[email protected]]
> Sent: Tuesday, April 20, 2010 8:38 AM
> To: Howard, Chris
> Cc: John Scoles; [email protected]
> Subject: Re: Problems with external password store.
> 
> >
> > Yes you can find out with ORA_OCI
> >
> >
> >
> >
> >
> >  use DBD::Oracle qw(:ora_types);
> >
> > print DBD::Oracle::ORA_OCI
> >
> >
> >
> > I think will work
> >
> > Cheers
> >
> > John
> >
> >
> >
> > Only one wallet is involved, and one connection.
> >
> > The Oracle Client issue might be in play.  I think
> > the case where wallet is not working right may
> > have been compiled against an Oracle 8 client.
> > It is a pretty old installation.
> >
> > Is there any way to tell which client is in use?
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: John Scoles [mailto:[email protected]]
> >> Sent: Tuesday, April 20, 2010 6:51 AM
> >> To: Howard, Chris; [email protected]
> >> Subject: RE: Problems with external password store.
> >>
> >> If you are trying to connect to both at the same time using two
> >> different wallets I am afraid you are out of luck.
> >>
> >> Seems once a SQLNET.ORA file is read it is 'READ' and cannot be
> >> reloaded so only one wallet can be used at a time.
> >>
> >> It will take the first valid one it finds and use that.
> >>
> >> Are you using two wallets and are you trying to connect to both at
> the
> >> same time??
> >>
> >> Your DBD::Oracle is rather old but there is no differance in the
way
> >> 1.24 and 1.16 connect using wallet.
> >>
> >> That being said your DBD::Oracle might of been compiled against or
> is
> >> using an older Oracle client.  Do you know which Oracle client you
> are
> >> using??
> >>
> >>
> >> Cheers
> >> John Scoles
> >>
> >>
> >>
> >>> Subject: Problems with external password store.
> >>> Date: Mon, 19 Apr 2010 10:42:16 -0600
> >>> From: [email protected]
> >>> To: [email protected]
> >>>
> >>> I have two database servers, there are some differences
> >>> between the way that perl dbd/dbi is installed on these
> >>> machines, but both are running HP-UX and Oracle 10g.
> >>>
> >>> I am trying to use external password store (oracle wallet)
> >>> to change scripts with embedded login information to be
> >>> more secure.
> >>>
> >>> On server B, I configured oracle wallet to use the
> >>> $HOME/.sqlnet.ora file. It work fine with sqlplus
> >>> and with a very simple perl script.
> >>>
> >>> On server A, I configured oracle wallet the same way
> >>> and it works fine with sqlplus, but the same
> >>> simple perl script gives me "invalid username/password"
> >>> errors.
> >>>
> >>> I have some version differences between the two machines.
> >>>
> >>> Server B is using DBI 1.601, DBD 1.16, Perl 5.8.8
> >>> Server A is using DBI 1.43, DBD 1.16, Perl 5.8.5
> >>>
> >>> I may be able to get them eventually on exactly parallel versions
> >>> but that will take quite a bit of time and effort.
> >>>
> >>> Any hope for forward progress otherwise?
> >>>
> >>> Chris Howard
> >>>
> >>>
> >> ________________________________
> >>
> >> Videos that have everyone talking! Now also in HD! MSN.ca Video.
> >> <http://go.microsoft.com/?linkid=9724460>
> >>