sybperl-l Archive

From: "Douglas A dot Taylor" <doug-taylor+ at osu dot edu>
Subject: 'make test' fails on DBD::Sybase .94
Date: Aug 27 2002 8:15PM

I'm having trouble getting DBD::Sybase to work.  I'm working on SunOS
5.8 using perl 5.6.1, FreeTDS (not sure of the version; it was the
latest snapshot as of August 18), DBI 1.30, and DBD:Sybase 0.94.

I've installed FreeTDS under my home directory.  It seems to work OK,
at least well enough that I can use it with sqsh (v. 2.1) to sign onto
my Sybase database.  DBD::Sybase makes OK, but when I run 'make test',
I get the following output on stdout:

PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/autocommit........ok
t/base..............ok
t/exec..............dubious
	Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 4-9
	Failed 6/9 tests, 33.33% okay
t/fail..............dubious
	Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 6-13
	Failed 8/13 tests, 38.46% okay
t/login.............ok
t/main..............FAILED tests 13-14
	Failed 2/14 tests, 85.71% okay
t/nsql..............ok
t/place.............dubious
	Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 3-11
	Failed 9/11 tests, 18.18% okay
t/xblob.............dubious
	Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 3, 5-6
	Failed 3/6 tests, 50.00% okay
Failed Test Status Wstat Total Fail  Failed  List of Failed
--------------------------------------------------------------------------------
t/exec.t   	   0    11     9    6  66.67%  4-9
t/fail.t   	   2   512    13    8  61.54%  6-13
t/main.t   	              14    2  14.29%  13-14
t/place.t  	   2   512    11    9  81.82%  3-11
t/xblob.t  	   0    11     6    3  50.00%  3, 5-6

Also, stderr gives me:

Can't call method "execute" on an undefined value at t/fail.t line 66.
Can't call method "execute" on an undefined value at t/place.t line 64.
DBD::Sybase::db do failed: Server message number=2714 severity=16 state=1 line=1 server=TEST text=There is already an object named 'blob_test' in the database.
Failed 5/9 test scripts, 44.44% okay. 28/69 subtests failed, 59.42% okay.
make: *** [test_dynamic] Error 2

Umm, let's see, in my environment I have 
SYBASE=/home/taylor/freetds
LD_LIBRARY_PATH=/usr/local/lib:/home/taylor/freetds/lib

(I've also tried
LD_LIBRARY_PATH=/home/taylor/freetds/lib:/usr/local/lib with the
same result.)

I wonder whether I have a library conflict with my build of perl.
Running 'perl -V:libs' gives me:

libs='-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc';

and if I were trying to install sybperl, it's my understanding
that the db lib would be causing conflicts.  Is it the same deal
with Sybase::DBD?  I'd rather not rebuild perl if I don't have to,
but I kinda need to get this thing working if I can.

So, anybody have any helpful suggestions?
-- 
Doug Taylor         doug-taylor+@osu.edu         The Ohio State University
This is the .sig that doesn't end.  Yes, it goes on and on, my friend.
Some people started reading it, not knowing what it was,
And they'll continue reading it forever just because this is the ...