Re: Problems with external password store.

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:[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>
>>>>
>>>>