I wasn't too clear. The scripts give error message complaints, but they actually do work.
Chris > -----Original Message----- > From: Howard, Chris [mailto:howa...@prpa.org] > Sent: Wednesday, April 21, 2010 12:39 PM > To: John Scoles > Cc: John Scoles; dbi-users@perl.org > Subject: 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:sco...@pythian.com] > > Sent: Tuesday, April 20, 2010 8:38 AM > > To: Howard, Chris > > Cc: John Scoles; dbi-users@perl.org > > 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:byter...@hotmail.com] > > >> Sent: Tuesday, April 20, 2010 6:51 AM > > >> To: Howard, Chris; dbi-users@perl.org > > >> 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: howa...@prpa.org > > >>> To: dbi-users@perl.org > > >>> > > >>> 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> > > >>