Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Greg Earle <earle at isolar dot DynDNS dot ORG>
Subject: DBD::Sybase 1.07 install on Solaris 8 - failing t/exec.t test #11
Date: Nov 2 2005 2:38AM

[Apologies if this shows up twice - first one accidentally got out
  without a Subject: field, and I didn't see it come back to me yet.]


I'm having problems getting the current DBD::Sybase 1.07 to
install on a Solaris 8 system (via CPAN).  The particulars:

     - Perl built on Solaris 7 (first with 5.6.1, now with 5.8.7)
     - "make install" run on Solaris 8
     - Installed newer CPAN (with all pre-reqs) and then DBI (1.48)
       via CPAN as well
     - Sybase/$SYBASE is in /usr/local/sybase; using Sybase 12.5.1

When I go to install DBD::Sybase, it builds OK and then gets
to the tests, and that's where I hit this:

Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"  
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/exec..........NOK 11
#     Failed test (t/exec.t at line 88)
t/exec..........ok 12/22# Looks like you failed 1 test of 22.

Ran it manually, and I get the same thing (not surprisingly)

solaris8:1:273 [/.cpan/build/DBD-Sybase-1.07] # perl t/exec.t
ok 1 - use DBI;
ok 2 - use DBD::Sybase;
ok 3 - Connect
ok 4 - Prepare sp_helpindex
ok 5 - exec sysusers
ok 6 - -1 (create proc)
ok 7 - prepare dbitest
ok 8 - execute dbitest 1
ok 9 - exec dbitest 2
ok 10 - exec dbitest 3
not ok 11 - out param 1
#     Failed test (t/exec.t at line 88)
[... other tests OK ...]

This happens with both Perl 5.6.1 and 5.8.7, same exact thing.

I thought at first perhaps my Sybase server/login/password/database
information was incorrect, but I don't think I would've gotten this
far if it hadn't been.

That part of t/exec.t is

$rc = $sth->execute(undef, 25, 3.2234, "jan 3 2001", 5.4);
ok(defined($rc), "exec dbitest 3");
my @out = $sth->func('syb_output_params');
ok($out[0] == 5.4, "out param 1");

Neither my Perl nor my (non-existent) Sybase knowledge are good
enough to tell what's going on here.  Any ideas, Mike?


     - Greg