8.1.7.0 is a later version of the 8 client I would have to check the change
logs to see if wallet mad it in by there.
Seems a pretty good bet that this is your problem. I checked DBD::Oracle
codebase and the change need to do Wallet type authentication was added in
version 1.15 so your DBD::oracle should be ok but rather dated.
Cheers
John Scoles
Howard, Chris wrote:
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>
