As I suspected the one that doesn't work with wallet is using Oracle 8.1.7.0 client.
I have some preparatory work to do before I can change that, but I suspect it is the problem. Chris > -----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> > >>
