Discussion :

[tibal]

Salut,

J'ai tenté d'installer la package 'DBD::Oracle' sur un Linux OpenSuSe 10.2 avec un Oracle 10G. Il finit en erreur avec les messages suivants :
**********************************************************
14 tests and 9 subtests skipped.
Failed 4/20 test scripts. 525/540 subtests failed.
Files=20, Tests=540, 3 wallclock secs ( 2.50 cusr + 0.31 csys = 2.81 CPU)
Failed 4/20 test programs. 525/540 subtests failed.
make: *** [test_dynamic] Error 255
PYTHIAN/DBD-Oracle-1.19.tar.gz
/usr/bin/make test -- NOT OK
//hint// To get more information about failing tests, try:
reports PYTHIAN/DBD-Oracle-1.19.tar.gz
Running make install
make test had returned bad status, won't install without force
Failed during this command:
PYTHIAN/DBD-Oracle-1.19.tar.gz : make_test NO
**********************************************************

Quelqu'un à t'il une idée ?

Merci d'avance.

[Jedai]

Il y a plusieurs possibilités, en tout cas ça aiderait de savoir quels tests ont échoué.

--
Jedaï

[tibal]

Jedai,

Voici les tests en erreur :
************************************************************
t/10general.............DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/10general.t line 18
Undefined subroutine &main::BAILOUT called at t/10general.t line 21.
# Looks like your test died before it could output anything.
t/10general.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-33
Failed 33/33 tests, 0.00% okay
t/15nls.................DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/15nls.t line 19
t/15nls.................ok
9/9 skipped: various reasons
t/20select..............Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/21nchar...............DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_al32utf8......DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/22nchar_utf8..........DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db.............DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_8bit........DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/23wide_db_al32utf8....DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/24implicit_utf8.......DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
skipped
all skipped: Not connected to oracle
t/25plsql...............Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skiped.
skipped
all skipped: no reason given
t/26exe_array...........ok 1/14DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/26exe_array.t line 28
# Looks like you planned 14 tests but only ran 1.
# Looks like your test died just after 1.
t/26exe_array...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-14
Failed 13/14 tests, 7.14% okay
t/30long................DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
Can't connect to database: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
# Looks like your test died before it could output anything.
t/30long................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-470
Failed 470/470 tests, 0.00% okay
t/31lob.................DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/nchar_test_lib.pl line 156
You tried to plan twice at t/31lob.t line 16.
# Looks like your test died before it could output anything.
t/31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/40ph_type.t line 29
Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/55nested..............Unable to connect to Oracle as scott/tiger (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger (ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
**********************************************************

Tibal

[Jedai]

Ok, alors j'aime pas trop faire ça, mais a priori le problème c'est que les tests n'ont pas réussi à se connecter à la base (leur avais-tu fourni des login et mot de passe correct ?) donc tu pourrais essayer de forcer l'install, ou mieux de faire ton propre test dans le répertoire d'install du module, si ça se trouve, ça marchera parfaitement (vu que le problème n'a pas l'air de provenir directement du module).

--
Jedaï

[tibal]

Jedaï,

J'effectue l'install via cpan qui utilise lelogin SCOTT/TIGER d'oracle. Je l'ai testé sia SQL*Plus et il se connecte sans erreur. Je vais l'installer avec FORCE et voir demain si l'application fonctionne.

Merci de ton aide.

Tibal