FreeTDS Development Group

[Justin Zygmont <justin AT cityfone.net>]

Trying to install DBD::Sybase through CPAN, I can only get this far. 
Yet I can connect with tsql just fine.



cpan[1]> install DBD::Sybase
CPAN: Storable loaded ok (v2.16)
Going to read /root/.cpan/Metadata
  Database was generated on Fri, 04 May 2007 18:10:15 GMT
Running install for module 'DBD::Sybase'
Running make for M/ME/MEWP/DBD-Sybase-1.08.tar.gz
CPAN: Digest::SHA loaded ok (v5.44)
CPAN: Compress::Zlib loaded ok (v2.004)
Checksum for 
/root/.cpan/sources/authors/id/M/ME/MEWP/DBD-Sybase-1.08.tar.gz ok
Scanning cache /root/.cpan/build for sizes
...................................................................---------DONE
DEL(1/2): /root/.cpan/build/DBD-Sybase-1.08-rvhabO
CPAN: YAML loaded ok (v0.62)
DEL(2/2): /root/.cpan/build/DBD-Sybase-1.08-rvhabO.yml
DBD-Sybase-1.08/
DBD-Sybase-1.08/dbivport.h
DBD-Sybase-1.08/dbdimp.c
DBD-Sybase-1.08/t/
DBD-Sybase-1.08/t/main.t
DBD-Sybase-1.08/t/exec.t
DBD-Sybase-1.08/t/autocommit.t
DBD-Sybase-1.08/t/place.t
DBD-Sybase-1.08/t/base.t
DBD-Sybase-1.08/t/fail.t
DBD-Sybase-1.08/t/nsql.t
DBD-Sybase-1.08/t/xblk.t
DBD-Sybase-1.08/t/screen.jpg
DBD-Sybase-1.08/t/xblob.t
DBD-Sybase-1.08/t/_test.pm
DBD-Sybase-1.08/t/multi_sth.t
DBD-Sybase-1.08/t/login.t
DBD-Sybase-1.08/t/thread.t
DBD-Sybase-1.08/Sybase.h
DBD-Sybase-1.08/PWD.factory
DBD-Sybase-1.08/README.vms
DBD-Sybase-1.08/README
DBD-Sybase-1.08/eg/
DBD-Sybase-1.08/eg/check-space.pl
DBD-Sybase-1.08/eg/dbschema.pl
DBD-Sybase-1.08/eg/README
DBD-Sybase-1.08/eg/Show.cgi
DBD-Sybase-1.08/dbdimp.h
DBD-Sybase-1.08/Sybase.pm
DBD-Sybase-1.08/Sybase.xs
DBD-Sybase-1.08/CHANGES
DBD-Sybase-1.08/META.yml
DBD-Sybase-1.08/dbd-sybase.pod
DBD-Sybase-1.08/BUGS
DBD-Sybase-1.08/README.freetds
DBD-Sybase-1.08/Makefile.PL
DBD-Sybase-1.08/MANIFEST
DBD-Sybase-1.08/CONFIG
CPAN: File::Temp loaded ok (v0.18)

  CPAN.pm: Going to build M/ME/MEWP/DBD-Sybase-1.08.tar.gz

Unknown Client Library version - assuming FreeTDS.

By default DBD::Sybase 1.05 and later use the 'CHAINED' mode (where 
available)
when 'AutoCommit' is turned off. Versions 1.04 and older instead managed
the transactions explicitly with a 'BEGIN TRAN' before the first DML
statement. Using the 'CHAINED' mode is preferable as it is the way that
Sybase implements AutoCommit handling for both its ODBC and JDBC drivers.

Use 'CHAINED' mode by default (Y/N) [Y]:

Running in threaded mode - looking for _r libraries...

***NOTE***
There is an incompatibility between perl (5.8.x) built in threaded mode and
Sybase's threaded libraries, which means that signals delivered to the perl
process result in a segment violation.

I suggest building DBD::Sybase with the normal libraries in this case to get
reasonable behavior for signal handling.

Use the threaded (lib..._r) libraries [N]:

OK - I'll use the normal libs

Running in 64bit mode - looking for '64' libraries...
BLK api NOT available.
The DBD::Sybase module need access to a Sybase server to run the tests.
To clear an entry please enter 'undef'
Sybase server to use (default: SYBASE):
User ID to log in to Sybase (default: sa): jim
Password (default: undef):
Sybase database to use on SYBASE (default: undef): prairiefyre

* Writing login information, including password, to file PWD.

Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lcs
Note (probably harmless): No library found for -lsybtcl
Note (probably harmless): No library found for -lcomn
Note (probably harmless): No library found for -lintl
Note (probably harmless): No library found for -lblk
Multiple copies of Driver.xst found in: 
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ 
/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ 
at Makefile.PL line 64
Using DBI 1.54 (for perl 5.008005 on x86_64-linux-thread-multi) 
installed in 
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::Sybase
cp dbd-sybase.pod blib/lib/DBD/dbd-sybase.pod
cp Sybase.pm blib/lib/DBD/Sybase.pm
/usr/bin/perl -p -e "s/~DRIVER~/Sybase/g" 
/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/Driver.xst 
> Sybase.xsi
/usr/bin/perl /usr/lib/perl5/5.8.5/ExtUtils/xsubpp  -typemap 
/usr/lib/perl5/5.8.5/ExtUtils/typemap  Sybase.xs > Sybase.xsc && mv 
Sybase.xsc Sybase.c
gcc -c  -I/usr/local/include -DSYB_LP64 -DNO_BLK=1 
-I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI 
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe 
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 
-I/usr/include/gdbm -O2 -g -pipe -m64   -DVERSION=\"1.08\" 
-DXS_VERSION=\"1.08\" -fPIC 
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE"   Sybase.c
gcc -c  -I/usr/local/include -DSYB_LP64 -DNO_BLK=1 
-I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI 
-D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe 
-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 
-I/usr/include/gdbm -O2 -g -pipe -m64   -DVERSION=\"1.08\" 
-DXS_VERSION=\"1.08\" -fPIC 
"-I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE"   dbdimp.c
Running Mkbootstrap for DBD::Sybase ()
chmod 644 Sybase.bs
rm -f blib/arch/auto/DBD/Sybase/Sybase.so
gcc  -L/usr/local/lib -shared Sybase.o dbdimp.o  -o 
blib/arch/auto/DBD/Sybase/Sybase.so   -L/usr/local/lib -lct -ltds -ldl -lm
chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so
cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs
chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs
Manifying blib/man3/DBD::Sybase.3
  MEWP/DBD-Sybase-1.08.tar.gz
  /usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" 
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/autocommit....ok
t/base..........ok
t/exec..........ok 1/22
#   Failed test ' (create proc)
# '
#   at t/exec.t line 66.
t/exec..........NOK 6/22
#   Failed test 'execute dbitest 1'
t/exec..........NOK 8/22#   at t/exec.t line 77.

#   Failed test 'exec dbitest 2'
#   at t/exec.t line 82.
t/exec..........NOK 10/22
#   Failed test 'exec dbitest 3'
#   at t/exec.t line 86.

#   Failed test 'out param 1'
#   at t/exec.t line 88.
t/exec..........NOK 11/22
#   Failed test 'execute fail mode 1'
#   at t/exec.t line 104.
t/exec..........NOK 12/22
#   Failed test 'execute fail mode 2'
#   at t/exec.t line 108.
t/exec..........NOK 13/22
#   Failed test 'execute fail mode 3'
t/exec..........NOK 14/22#   at t/exec.t line 112.

#   Failed test 'execute fail mode 4'
t/exec..........NOK 15/22#   at t/exec.t line 117.

#   Failed test 'execute fail mode 5'
t/exec..........NOK 16/22#   at t/exec.t line 121.

#   Failed test 'execute fail mode 6'
t/exec..........NOK 17/22#   at t/exec.t line 125.

#   Failed test ' (create proc)
# '
t/exec..........NOK 18/22#   at t/exec.t line 139.




And it just hangs there.  I'm trying to connect to a MS-SQL 8.0 
database, so I don't think compatibility should be an issue, this is on 
RHEL 4.4, with freetds 0.64.


Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT
5.2 (Build 3790: Service Pack 1)


My freeTDS.conf file:

# A typical Microsoft SQL Server 2000 configuration
[SYBASE]
        host = mitel6110.cityfone.local
        port = 1433
        tds version = 8.0


Your help is much appreciated, thanks!