Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 48500
Status: rejected
Priority: 0/
Queue: DBD-Oracle
People
Owner: Nobody in particular
Requestors: brian.nelson [...] utdallas.edu
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Thu Aug 06 15:00:29 2009 brian.nelson [...] utdallas.edu - Ticket created
Subject: External auth failure
Date: Thu, 06 Aug 2009 14:00:01 -0500
To: bug-DBD-Oracle [...] rt.cpan.org
From: Brian Nelson <brian.nelson [...] utdallas.edu>
Importance: Not important -- just annoying
Previous build of DBD 1.16 with Oracle 11.1.0.1 on i386 functioned normally
--------------
Error:
DBI connect('','',...) failed: ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin) at /usr/local/bin/oam.pl line 25

-rwsr-xr-x 1 oaccount dba 3664 Aug  4 17:57 oam.pl

----------------
BEGIN {
        push @INC,"/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/";
}

use strict;
use DBI qw(:sql_types);
use Term::ReadKey;
use DBD::Oracle qw(:ora_types);

BEGIN {
        delete @ENV{qw(IFS CDPATH ENV BASH_ENV)}; # Make %ENV safer
        $ENV{ORACLE_SID} = 'student';
}

Show quoted text
# Swap UID/EUID
($<, $>) = ($>, $<);

Show quoted text
# Connects to a local database with a user which has been setup to
# authenticate via the OS (that is EXTERNALLY)
# NOTE: We can't pass the sid on the schema.  We have to set the SID
# environment variable.
my $dbh = DBI->connect("dbi:Oracle:","",""
                        , {
                                RaiseError => 1
                                , AutoCommit => 0
                        }) || die "Unable to connect to $ENV{ORACLE_SID}: $DBI::errstr\n";
my $user = uc($ENV{USER}) || die "Unable to determine user account\n";

-----------------------

DBD::Oracle version 1.23 compiled without errors or burps on [CentOS 5.2]
ls -al /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/
drwxr-xr-x  4 root root   4096 Aug  4 17:18 DBD
drwxr-xr-x  8 root root   4096 Aug  4 16:57 DBI

Show quoted text
cpan> m DBD::Oracle
Module id = DBD::Oracle
    DESCRIPTION  Oracle Driver for DBI
    CPAN_USERID  DBIML (DBI Mailing Lists <dbi-users@perl.org>)
    CPAN_VERSION 1.23
    CPAN_FILE    P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz
    DSLI_STATUS  MmcO (mature,mailing-list,C,object-oriented)
    MANPAGE      DBD::Oracle - Oracle database driver for the DBI module
    INST_FILE    /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/DBD/Oracle.pm
    INST_VERSION 1.23

Linux csoraclebuild.utdallas.edu 2.6.18-92.el5 #1 SMP Tue Jun 10 18:51:06 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux

 Oracle Database 11g software, version 11.1.0.6.0,plus
 the addition of the fix for bug 7389110.

----------------------
Oracle account "OACCOUNTS" configured to use External authentication. Oracle audit logs show username passing in correctly
OP$OACCOUNTS
assuming logon failure is password error. Not quite sure how to capture password field passed by DBD.

Standard Oracle username password authentication functions normally.
my $dbh = DBI->connect("dbi:Oracle:","oaccounts","password"


Thanks for your time
Brian Nelson
Dept of CS
UTD

  Mon May 26 14:41:56 2014 champoux [...] pythian.com - Status changed from 'new' to 'rejected'
  Mon May 26 14:42:47 2014 champoux [...] pythian.com - Correspondence added
The ticket is over 5 years old, and from the description it's not clear what is failing. I'll take the easy road and close it. `/anick On Thu Aug 06 15:00:29 2009, brian.nelson@utdallas.edu wrote: Show quoted text
> Importance: Not important -- just annoying > Previous build of DBD 1.16 with Oracle 11.1.0.1 on i386 functioned > normally > -------------- > Error: > DBI connect('','',...) failed: ORA-01017: invalid username/password; > logon > denied (DBD ERROR: OCISessionBegin) at /usr/local/bin/oam.pl line 25 > > -rwsr-xr-x 1 oaccount dba 3664 Aug 4 17:57 oam.pl > > ---------------- > BEGIN { > push @INC,"/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread- > multi/"; > } > > use strict; > use DBI qw(:sql_types); > use Term::ReadKey; > use DBD::Oracle qw(:ora_types); > > BEGIN { > delete @ENV{qw(IFS CDPATH ENV BASH_ENV)}; # Make %ENV safer > $ENV{ORACLE_SID} = 'student'; > } > > # Swap UID/EUID > ($<, $>) = ($>, $<); > > # Connects to a local database with a user which has been setup to > # authenticate via the OS (that is EXTERNALLY) > # NOTE: We can't pass the sid on the schema. We have to set the SID > # environment variable. > my $dbh = DBI->connect("dbi:Oracle:","","" > , { > RaiseError => 1 > , AutoCommit => 0 > }) || die "Unable to connect to $ENV{ORACLE_SID}: $DBI::errstr\n"; > my $user = uc($ENV{USER}) || die "Unable to determine user account\n"; > > ----------------------- > > DBD::Oracle version 1.23 compiled without errors or burps on [CentOS > 5.2] > ls -al /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/ > drwxr-xr-x 4 root root 4096 Aug 4 17:18 DBD > drwxr-xr-x 8 root root 4096 Aug 4 16:57 DBI >
> cpan> m DBD::Oracle
> Module id = DBD::Oracle > DESCRIPTION Oracle Driver for DBI > CPAN_USERID DBIML (DBI Mailing Lists <dbi-users@perl.org>) > CPAN_VERSION 1.23 > CPAN_FILE P/PY/PYTHIAN/DBD-Oracle-1.23.tar.gz > DSLI_STATUS MmcO (mature,mailing-list,C,object-oriented) > MANPAGE DBD::Oracle - Oracle database driver for the DBI module > INST_FILE > /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread- > multi/DBD/Oracle.pm > INST_VERSION 1.23 > > Linux csoraclebuild.utdallas.edu 2.6.18-92.el5 #1 SMP Tue Jun 10 > 18:51:06 EDT > 2008 x86_64 x86_64 x86_64 GNU/Linux > > Oracle Database 11g software, version 11.1.0.6.0,plus > the addition of the fix for bug 7389110. > > ---------------------- > Oracle account "OACCOUNTS" configured to use External authentication. > Oracle > audit logs show username passing in correctly > OP$OACCOUNTS > assuming logon failure is password error. Not quite sure how to > capture > password field passed by DBD. > > Standard Oracle username password authentication functions normally. > my $dbh = DBI->connect("dbi:Oracle:","oaccounts","password" > > > Thanks for your time > Brian Nelson > Dept of CS > UTD