Howard, Chris wrote:
Can you send the error message just for fun.
Cheers
John
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>
