You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by ph...@non.agilent.com on 2000/08/25 01:30:01 UTC
Recordset Installation error - DB Login problem
Hi Gerald and all,
I need help installing DBIx::Recordset.
the make test failed at:
DBIx::Database setup...
Test terminated with fatal error! Look at test.log
*** Error exit code 2
The test.log shows:
DBIx::Database setup...
--------------------
DB: Successfull connect to dbi:Oracle:ruby_tsoc
WARN: DBD::Oracle::db prepare failed: ORA-00942: table or view does not
exist (DBD ERROR: OCIStmtExecute/Describe) at blib/lib/DBIx/Compat.pm line
30.
Can't call method "execute" without a package or object reference at
blib/lib/DBIx/Compat.pm line 31.
DB: Row::DESTROY
DB: Row::DESTROY
DB: Row::DESTROY
DB: Row::DESTROY
DB: Row::DESTROY
--------------------------------------------------------------
As most of the tests passed, I did a make install anyway to see what would
happen. I can call DBIx::Recordset methods
but Recordset will not connect to my Oracle database
This Embperl page WILL connect to the database :
------------------------------
[-
$DSN = "dbi:Oracle:ruby_tsoc";
$dbh = DBI->connect($DSN, "emerald", "swordfish")
|| die $DBI::errstr;
-]
<html>
<head>
<title>Connection Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p>Connection Test</p>
</body>
</html>
--------------------------------------------
This Recordset Page will NOT connect;
[-
use DBIx::Recordset ;
%setup = (
'!DataSource' => "dbi:Oracle:ruby_tsoc",
'!Username' => "emerald",
'!Password' => "swordfish"
) ;
*set = DBIx::Recordset -> Setup(\%setup) ;
-]
<html>
<head>
<title>RS Connection Test</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p>RS Connection Test</p>
</body>
</html>
----------------------------------------------------------
The error log message is:
ERR: 32: Line 1: Warning in Perl code: DBI->connect(ruby_tsoc) failed:
ORA-01017: invalid username/password; logon denied (DBD ERROR:
OCISessionBegin) at
/opt/perl5.004.04/lib/site_perl/DBIx/Recordset.pm line 1039
----------------------------------------------------------
Here is the relevant make test output:
PERL_DL_NONLAZY=1 /usr/bin/perl -I./blib/arch -I./blib/lib
-I/opt/perl5.004.04/lib/PA-RISC1.1/5.00404 -I/opt/perl5.004.04/lib test.pl
Loading... ok
Using the following parameters for testing:
DBD-Driver: Oracle
Database: dbi:Oracle:ruby_tsoc
User: emerald
Password: swordfish
Table: dbixrs1
Table: dbixrs2
Table: dbixrs3
Table: dbixrs4
Table: dbix_rs5
Table: dbix_rs6
Table: dbixseq
DBI-Version: 1.14
DBD-Version: 1.06
Creating the testtables... ok
Setup Object for dbixrs1... ok
SQLSelect All... ok
Setup Object for dbixrs2... ok
SQLSelect All... ok
Setup Object for dbixrs1, dbixrs2... ok
SQLSelect All... ok
Setup Object for dbixrs1, dbixrs3... ok
SQLSelect All... ok
... snip ...
Clear hash... ok
Assign hash... ok
Input Filter... ok
Output Filter... ok
- 2 ... ok
I/O Filter on type... ok
DBIx::Database setup...
Test terminated with fatal error! Look at test.log
*** Error exit code 2
Thanks,
Phil Hersh
Re: Recordset Installation error - DB Login problem
Posted by Gerald Richter <ri...@ecos.de>.
Hi ,
>
> I need help installing DBIx::Recordset.
>
> the make test failed at:
> DBIx::Database setup...
> Test terminated with fatal error! Look at test.log
> *** Error exit code 2
>
This normaly occurs when in the database that you are using for the test
other tables exists. Normaly this isn't a problem and it should be safe to
ignore this test problem.
>
> This Recordset Page will NOT connect;
>
> [-
> use DBIx::Recordset ;
> %setup = (
> '!DataSource' => "dbi:Oracle:ruby_tsoc",
> '!Username' => "emerald",
> '!Password' => "swordfish"
You need a
'!Table' => 'foo'
to setup a recordset. I am not sure if this has anything to do with error,
but let's give it a try
> ) ;
> *set = DBIx::Recordset -> Setup(\%setup) ;
> -]
Gerald