Re: Problems with external password store.

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:[email protected]]
>> Sent: Wednesday, April 21, 2010 12:39 PM
>> To: John Scoles
>> Cc: John Scoles; [email protected]
>> 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:[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>
>>>>>
>>>>>