FreeTDS Development Group

[richard pijlgroms <richard AT home.pijlgroms.nl>]

Hello,

can anyone help me out with the following problem.

I update my perfectly running Suse linux 7.1 system to Suse 8.1, with this 
upgrade the new perl 5.8 was installed and 5.6 was removed. all my perl 
modules are now out of date and have to be installed. Also the sybperl module 
with freetds.

i downloaded freetds again (latest) and compiled and installed it. The tests 
of make check where running OK. I also installed the latest sybperl module 
2.15 (for perl 5.8) but i don't get it compiled OK. perl makefile.PL runs OK, 
make runs also OK, but all the tests with make test fails.
also after make install in does not run.(ofcourse)

then i installed the original sybase libs in /opt/sybase and try to compile 
with this and this workes fine. I can connect and query to our old MS SQL 6.5 
server. But we have now a new SQL 2000 server and we want to connect to it. 
With to sybase libs it is not possible because of a TDS version conflict.
Under perl 5.6 was this solved by using freetds.

maybe one of you can help me out, here are the results of make test and alo 
my CONFIG file:

make test:

make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/BCP'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/BCP'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/BLK'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/BLK'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/CTlib'
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/CTlib'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/DBlib'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/DBlib'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/Sybperl'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/Sybperl'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/BCP'
make[1]: Nothing to be done for `test'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/BCP'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/BLK'
make[1]: Nothing to be done for `test'.
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/BLK'
make[1]: Entering directory `/usr/local/src/perl/sybperl-2.15/CTlib'
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" 
"test_harness(0, '../blib/lib', '../blib/arch')" t/*.t
t/ctlib......Can't load 
'/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so'
 for module Sybase::CTlib: 
/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so:
 undefined symbol: ct_poll at /usr/lib/perl5/5.8.0/i686-linux/DynaLoader.pm 
line 229.
 at t/ctlib.t line 11
Compilation failed in require at t/ctlib.t line 11.
BEGIN failed--compilation aborted at t/ctlib.t line 11.
t/ctlib......dubious                                                         
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
        Failed 30/30 tests, 0.00% okay
t/cursor.....Can't load 
'/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so'
 for module Sybase::CTlib: 
/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so:
 undefined symbol: ct_poll at /usr/lib/perl5/5.8.0/i686-linux/DynaLoader.pm 
line 229.
 at t/cursor.t line 14
Compilation failed in require at t/cursor.t line 14.
BEGIN failed--compilation aborted at t/cursor.t line 14.
t/cursor.....dubious                                                         
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-22
        Failed 22/22 tests, 0.00% okay
t/nsql.......Can't load 
'/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so'
 for module Sybase::CTlib: 
/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so:
 undefined symbol: ct_poll at /usr/lib/perl5/5.8.0/i686-linux/DynaLoader.pm 
line 229.
 at t/nsql.t line 9
Compilation failed in require at t/nsql.t line 9.
BEGIN failed--compilation aborted at t/nsql.t line 9.
t/nsql.......dubious                                                         
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-4
        Failed 4/4 tests, 0.00% okay
t/prepare....Can't load 
'/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so'
 for module Sybase::CTlib: 
/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so:
 undefined symbol: ct_poll at /usr/lib/perl5/5.8.0/i686-linux/DynaLoader.pm 
line 229.
 at t/prepare.t line 9
Compilation failed in require at t/prepare.t line 9.
BEGIN failed--compilation aborted at t/prepare.t line 9.
t/prepare....dubious                                                         
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-15
        Failed 15/15 tests, 0.00% okay
t/xblk.......Can't load 
'/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so'
 for module Sybase::CTlib: 
/usr/local/src/perl/sybperl-2.15/CTlib/../blib/arch/auto/Sybase/CTlib/CTlib.so:
 undefined symbol: ct_poll at /usr/lib/perl5/5.8.0/i686-linux/DynaLoader.pm 
line 229.
 at t/xblk.t line 11
Compilation failed in require at t/xblk.t line 11.
BEGIN failed--compilation aborted at t/xblk.t line 11.
t/xblk.......dubious                                                         
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-14
        Failed 14/14 tests, 0.00% okay
Failed Test Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/ctlib.t    255 65280    30   30 100.00%  1-30
t/cursor.t   255 65280    22   22 100.00%  1-22
t/nsql.t     255 65280     4    4 100.00%  1-4
t/prepare.t  255 65280    15   15 100.00%  1-15
t/xblk.t     255 65280    14   14 100.00%  1-14
Failed 5/5 test scripts, 0.00% okay. 85/85 subtests failed, 0.00% okay.
make[1]: *** [test_dynamic] Error 2
make[1]: Leaving directory `/usr/local/src/perl/sybperl-2.15/CTlib'
make: *** [test] Error 2

CONFIG file:

#
# Configuration file for Sybperl
#
# DBlibrary version. Set to 1000 (or higher) if you have System 10
# Set to 0 if you do not want to build DBlib or if DBlib is not available.
DBLIBVS=0


# CTlib version. Set to 0 if Client Library is not available on your
# system, or if you don't want to build the CTlib module. The Client
# Library started shipping with System 10.
# Set to 100 if you have OpenClient 10.x or later.
CTLIBVS=100

# Where is the Sybase directory on your system (include files &
# libraries are expected to be found at SYBASE/include & SYBASE/lib
SYBASE=/usr/local/freetds

# If EMBED_SYBASE is TRUE (1), then we add BEGIN { $ENV{SYBASE} = $SYBASE}
# at the top of both Sybase::DBlib and Sybase::CTlib. This ensures that
# the correct value for the SYBASE environment variable is always set.
# The downside is that if you install a new version of Sybase (OpenClient
# in particular) in a different location (say /opt/sybase/11.9.2 instead of
# /opt/sybase/11.5.1) then you need to rebuild sybperl with the new value - 
# setting the SYBASE environment variable will have no effect.
#EMBED_SYBASE = 0

# If EMBED_SYBASE is set, then if EMBED_SYBASE_USE_HOME is also set
# then, if the SYBASE env. variable is not set at run-time we look
# for the "sybase" user's home directory first, and then for the 
# build-time Sybase directory.
#EMBED_SYBASE_USE_HOME = 0

# Additional libraries.
# Some systems require -lnsl or -lBSD.
# Solaris 2.x needs -ltli
# DEC OSF/1 needs -ldnet_stub and may need -lsdna
#   (Note: Under Dec 3.2 you need to *remove* -lsdna from the DBlib/Makefile
#    for things to work. *sigh*)
# SunOS 4.x needs -linsck
# HP-UX 10.x needs -linsck
# AIX 3.2.5 needs -linsck
# Linux needs -linsck
# See the Sybase OpenClient Supplement for your OS/Hardware
# combination.
EXTRA_LIBS=-lsybtcl -linsck

# Library directory. Under Windows/NT, if you are using the Borland
# compilers, then uncomment the line below:
# BORLAND_LIBS=blib

# Additional #defines.
# With Perl 5.001m, you will need -DUNDEF_BUG.
# With Perl 5.002, none are normally needed, but you may wish to
# use -DDO_TIE to get the benefit of stricter checking on the
# Sybase::DBlib and Sybase::CTlib attributes.
# Use -DNCR_BUG if you are on NCR 3.0 and OpenClient 10.0.x
# Add -DMSSQL if you want to use the Sybase::DBlib portion of sybperl
# to connect to an MS-SQL 7 server.
# Add -DTDS_DBOPEN_HACK if you are building with the FreeTDS libraries, and
# you have configured freetds with --enable-dbm-conflict-fix.
# Add -DNOBLK if you don't have the libblk.a library available (e.g. FreeTDS)
EXTRA_DEFS=-DDO_TIE -DNOBLK 

#
# Uncomment this if you are building sybperl in 64bit mode
# with the 12.5 (or later) OpenClient on a 64 bit OS.
#
#BUILD_TYPE=64

# LINKTYPE
# If you wish to link Sybase::DBlib and/or Sybase::CTlib statically
# into perl uncomment the line below and run the make normally. Then,
# when you run 'make test' a new perl binary will be built.
#LINKTYPE=static


-- 
Richard Pijlgroms