DBD::Sybase success, build errors


The good news is with:

Perl : 5.008007 (i686-linux)
OS : linux (2.4.21-243-default)
DBI : 1.48
DBD::Sybase : 1.06
freetds v0.63
(./configure --prefix=/usr/local/freetds --with-tdsver=7.0)

I can connect to and query the following MS-SQL servers:

Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: )

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

So everything looks like its working fine.

I did get quite a few build errors though, and only half of them (or so) are listed in

DBD-Sybase-1.06/README.freetds

so I thought I'd post my build dialogue here. I'm ignoring all the errors below unless someone slaps me.

Cheers,

j



-----------------------
force install DBD::Sybase

Removing previously used /root/.cpan/build/DBD-Sybase-1.06

CPAN.pm: Going to build M/ME/MEWP/DBD-Sybase-1.06.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]: Y

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): omares-pms
User ID to log in to Sybase (default: sa):
Password (default: undef): Sybase database to use on omares-pms (default: undef): hotel

* 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
Using DBI 1.48 (for perl 5.008007 on i686-linux) installed in /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/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/local/bin/perl5.8.7 -p -e "s/~DRIVER~/Sybase/g" /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI//Driver.xst > Sybase.xsi
/usr/local/bin/perl5.8.7 /usr/local/lib/perl5/5.8.7/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.7/ExtUtils/typemap Sybase.xs > Sybase.xsc && mv Sybase.xsc Sybase.c
cc -c -I/usr/local/freetds/include -I/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic "-I/usr/local/lib/perl5/5.8.7/i686-linux/CORE" Sybase.c
cc -c -I/usr/local/freetds/include -I/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBI -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" -fpic "-I/usr/local/lib/perl5/5.8.7/i686-linux/CORE" dbdimp.c
Running Mkbootstrap for DBD::Sybase ()
chmod 644 Sybase.bs
rm -f blib/arch/auto/DBD/Sybase/Sybase.so
LD_RUN_PATH="/usr/local/freetds/lib" cc -L/usr/local/freetds/lib -shared -L/usr/local/lib Sybase.o dbdimp.o -o blib/arch/auto/DBD/Sybase/Sybase.so -L/usr/local/freetds/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
/usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl5.8.7 "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/autocommit....ok
t/base..........ok
t/exec..........NOK 5
# Failed test (t/exec.t at line 41)
t/exec..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5, 8-22
Failed 16/22 tests, 27.27% okay
t/fail..........NOK 4
# Failed test (t/fail.t at line 35)
t/fail..........NOK 6
# Failed test (t/fail.t at line 47)
ct_send(CS_DESCRIBE_INPUT) returned 0 at blib/lib/DBD/Sybase.pm line 133.
t/fail..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 4, 6-12
Failed 8/12 tests, 33.33% okay
t/login.........ok
t/main..........ok 16/33Setting of CS_OPT_TEXTSIZE failed. at t/main.t line 95.
t/main..........NOK 18
# Failed test (t/main.t at line 100)
t/main..........NOK 19
# Failed test (t/main.t at line 103)
t/main..........NOK 21
# Failed test (t/main.t at line 114)
type_info_all result has 19 keys but 20 fields at t/main.t line 140
# Looks like you planned 33 tests but only ran 22.
# Looks like your test died just after 22.
t/main..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 18-19, 21, 23-33
Failed 14/33 tests, 57.58% okay
t/multi_sth.....ok 1/43ct_send(CS_DESCRIBE_INPUT) returned 0 at /root/.cpan/build/DBD-Sybase-1.06/blib/lib/DBD/Sybase.pm line 133.
t/multi_sth.....dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 10-43
Failed 34/43 tests, 20.93% okay
t/nsql..........ok
t/place.........ok 1/13ct_send(CS_DESCRIBE_INPUT) returned 0 at /root/.cpan/build/DBD-Sybase-1.06/blib/lib/DBD/Sybase.pm line 133.
t/place.........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 5-13
Failed 9/13 tests, 30.77% okay
t/thread........skipped
all skipped: this perl 5.008007 not configured to support iThreads
t/xblk..........NOK 6
# Failed test (t/xblk.t at line 84)
t/xblk..........NOK 7
# Failed test (t/xblk.t at line 84)
t/xblk..........dubious
Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 6-62
Failed 57/62 tests, 8.06% okay
t/xblob.........ok 1/11Use of uninitialized value in print at t/xblob.t line 49.
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 56.
t/xblob.........NOK 6
# Failed test (t/xblob.t at line 79)
Use of uninitialized value in print at t/xblob.t line 121.
DBD::Sybase::st syb_ct_send_data failed: Server message number=170 severity=15 state=1 line=1 server=OMARES-PMS text=Line 1: Incorrect syntax near '0x00000000000000000000000000000000'. at t/xblob.t line 125.
Setting of CS_OPT_TEXTSIZE failed. at t/xblob.t line 129.
t/xblob.........NOK 10
# Failed test (t/xblob.t at line 153)
# Looks like you failed 2 tests of 11.
t/xblob.........dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 6, 10
Failed 2/11 tests, 81.82% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/exec.t 0 11 22 31 140.91% 5 8-22
t/fail.t 0 11 12 14 116.67% 4 6-12
t/main.t 255 65280 33 25 75.76% 18-19 21 23-33
t/multi_sth.t 0 11 43 68 158.14% 10-43
t/place.t 0 11 13 18 138.46% 5-13
t/xblk.t 0 11 62 112 180.65% 6-62
t/xblob.t 2 512 11 2 18.18% 6 10
1 test skipped.
Failed 7/12 test scripts, 41.67% okay. 140/221 subtests failed, 36.65% okay.
make: *** [test_dynamic] Error 2
/usr/bin/make test -- NOT OK
Running make install
Installing /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBD/Sybase/Sybase.so
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBD/Sybase.pm
Installing /usr/local/man/man3/DBD::Sybase.3
Writing /usr/local/lib/perl5/site_perl/5.8.7/i686-linux/auto/DBD/Sybase/.packlist
Appending installation info to /usr/local/lib/perl5/5.8.7/i686-linux/perllocal.pod
/usr/bin/make install -- OK


.

Relevant Pages

  • Re: adding 64-bit R2 DC to existing domain
    ... Server 2003 standard edition 32-bit domain controllers. ... The schema master did not complete a replication cycle ..." ... server1 failed test KnowsOfRoleHolders ... ForestDnsZones failed test CrossRefValidation ...
    (microsoft.public.windows.server.setup)
  • Re: Event ID 13508
    ... DNS Client does need to be running on all clients and servers that use dns ... failed test services - Dnscache Service is stopped on server - services ... If you don't have the tools installed, install them from your server ... Run dcdiag, netdiag and repadmin in verbose mode. ...
    (microsoft.public.windows.server.active_directory)
  • Re: 2003 Server Domain Controller Problems
    ... Additionally when trying to dcpromo the 2000 server to demote it, ... > failed test knowsofroleholders ... for a short while it will be the only domain controller. ...
    (microsoft.public.windows.server.general)
  • Re: Operations Master Replication Issue Event ID 13562
    ... leave it as a member server, ... >I have a Windows 2000 Server which is the Operations Master for the domain. ... >This server and others are having problems with replication. ... > I have run a DCDIAG from one of the other servers and get a failed test on ...
    (microsoft.public.win2000.active_directory)
  • DBD Sybase make test errors
    ... Sybase ASE XE select @@ version returns: 'Adaptive Server ... Sybase is up and running and seems fine. ... # Failed test ... Failed 6/62 tests, 90.32% okay ...
    (perl.dbi.users)