Re: DBD::Oracle - credentials

On Fri, 14 Jan 2011 14:56:46 +0000, "Martin J. Evans"
<[email protected]> wrote:

> On 14/01/11 14:30, H.Merijn Brand wrote:
> > Maybe this is a feature request, but if I have
> > 
> >   ORACLE_USERID=john/sekrit
> >   DBI_USER=pablo
> >   DBI_PASS=neruda
> > 
> > I *do* expect that DBD::Oracle uses DBI_USER and DBI_PASS *instead of*
> > the ORACLE_USERID. Anyone can come up with a good reason why this os
> > not happening at the moment?
> > 
> > How do other DBD's set precedence if environment variable are allowed
> > for login credentials?
> > 
> 
> Just a minor point (not saying it stops the discussion) but I don't
> think ORACLE_USERID is something DBD::Oracle defines (other than in
> test code in t/*). So is your point to do with running tests in t/* or
> in general?

I ran into this in the test suite indeed. Your findings below just
confirm my expectation :)

I posted it here because I saw no generic docs about this

> $ export ORACLE_USERID=wrong/wrong
> $ export DBI_USER=real_user
> $ export DBI_PASS=valid_password
> $ export DBI_DSN='dbi:Oracle:host=betoracle.easysoft.local;sid=devel'
> $ perl -le 'use DBI; my $h = DBI->connect();'
> 
> works for me. i.e., ORACLE_USERID contains invalid username/password
> and DBI_USER/DBI_PASS contain valid username/password and it connects
> fine.
> 
> Perhaps I misunderstood you Merijn.
> 
> Martin


-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00,
11.11, 11.23 and 11.31, OpenSuSE 10.1, 11.0 .. 11.3 and AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/