PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: michael dot peppler at bnpparibas dot com
Subject: Re: sybperl make test fails for Sybase 12.5.3 on RHEL3
Date: Mar 10 2006 7:27AM

The problem is that the BLK API can't work between clients and servers that
use fundementally different charsets (different sizes, for example). This
is the case between iso_1 and eucjis, which is what you have.

You can set your client charset by setting the locale in your shell and
then re-run the tests, or you can ignore the problem. The main
functionality (query/update the database) will work fine.

Michael




Internet
george.crum@irisfinancialsolutions.com@peppler.org - 09/03/2006 20:47


Sent by:    owner-sybperl-l@peppler.org

To:    sybperl-l

cc:


Subject:    sybperl make test fails for Sybase 12.5.3 on RHEL3


Hello,
Having a problem getting sybperl installed here.

Have Sybase 12.5.3 installed on a RHEL3 system.  Everything looks good
until I run "make test".  I have tried with with default perl from RH
and a compiled version as suggested in README.linux.  Both fail same way
in make test.  Any help would be greatly appreciated.

[sybase@seth sybperl-2.18]$ perl Makefile.PL
/usr/sybase
Sybase OpenClient 12.5.1 found.
The sybperl modules need access to a Sybase server to run the tests.
To clear an entry please enter 'undef'
Sybase server to use (default: SYBASE): SETH
User ID to log in to Sybase (default: sa):
Password (default: undef):
Sybase database to use on SETH (default: undef):

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

Checking if your kit is complete...
Looks good
/usr/sybase
Sybase OpenClient 12.5.1 found.
Writing Makefile for Sybase::BCP
Writing Makefile for Sybase::BLK
/usr/sybase
Sybase OpenClient 12.5.1 found.
Writing Makefile for Sybase::CTlib
/usr/sybase
Sybase OpenClient 12.5.1 found.
Writing Makefile for Sybase::DBlib
/usr/sybase
Sybase OpenClient 12.5.1 found.
Writing Makefile for Sybase::Sybperl
Writing Makefile for Sybase
[sybase@seth sybperl-2.18]$ make
cp lib/ctutil.pl blib/lib/ctutil.pl
cp lib/sql.pl blib/lib/sql.pl
cp lib/sybutil.pl blib/lib/sybutil.pl
cp lib/sybperl.pl blib/lib/sybperl.pl
make[1]: Entering directory `/tmp/sybperl-2.18/BCP'
cp BCP.pm ../blib/lib/Sybase/BCP.pm
Manifying ../blib/man3/Sybase::BCP.3
make[1]: Leaving directory `/tmp/sybperl-2.18/BCP'
make[1]: Entering directory `/tmp/sybperl-2.18/BLK'
cp BLK.pm ../blib/lib/Sybase/BLK.pm
Manifying ../blib/man3/Sybase::BLK.3
make[1]: Leaving directory `/tmp/sybperl-2.18/BLK'
make[1]: Entering directory `/tmp/sybperl-2.18/CTlib'
cp CTlib.pm ../blib/lib/Sybase/CTlib.pm
AutoSplitting ../blib/lib/Sybase/CTlib.pm (../blib/lib/auto/Sybase/CTlib)
/usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp
-prototypes -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap
CTlib.xs > CTlib.xsc && mv CTlib.xsc CTlib.c
cc -c  -I/usr/sybase/OCS-12_5/include -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2   -DVERSION=\"2.18\"
-DXS_VERSION=\"2.18\" -fpic
"-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE"  -DCTLIBVS=100
-DSYBPLVER='"2.18"' -DDO_TIE CTlib.c
Running Mkbootstrap for Sybase::CTlib ()
chmod 644 CTlib.bs
rm -f ../blib/arch/auto/Sybase/CTlib/CTlib.so
LD_RUN_PATH="/usr/sybase/OCS-12_5/lib" cc  -L/usr/sybase/OCS-12_5/lib
-shared -L/usr/local/lib CTlib.o  -o
.../blib/arch/auto/Sybase/CTlib/CTlib.so      \
   -L/usr/sybase/OCS-12_5/lib -lct -lcs -lsybtcl -lcomn -lintl -lblk
-lm        \

chmod 755 ../blib/arch/auto/Sybase/CTlib/CTlib.so
cp CTlib.bs ../blib/arch/auto/Sybase/CTlib/CTlib.bs
chmod 644 ../blib/arch/auto/Sybase/CTlib/CTlib.bs
Manifying ../blib/man3/Sybase::CTlib.3
make[1]: Leaving directory `/tmp/sybperl-2.18/CTlib'
make[1]: Entering directory `/tmp/sybperl-2.18/DBlib'
cp DBlib.pm ../blib/lib/Sybase/DBlib.pm
AutoSplitting ../blib/lib/Sybase/DBlib.pm (../blib/lib/auto/Sybase/DBlib)
/usr/local/bin/perl /usr/local/lib/perl5/5.8.8/ExtUtils/xsubpp
-prototypes -typemap /usr/local/lib/perl5/5.8.8/ExtUtils/typemap
DBlib.xs > DBlib.xsc && mv DBlib.xsc DBlib.c
cc -c  -I/usr/sybase/OCS-12_5/include -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2   -DVERSION=\"2.18\"
-DXS_VERSION=\"2.18\" -fpic
"-I/usr/local/lib/perl5/5.8.8/i686-linux/CORE"  -DDBLIBVS=1000
-DSYBPLVER='"2.18"' -DDO_TIE DBlib.c
Running Mkbootstrap for Sybase::DBlib ()
chmod 644 DBlib.bs
rm -f ../blib/arch/auto/Sybase/DBlib/DBlib.so
LD_RUN_PATH="/usr/sybase/OCS-12_5/lib" cc  -L/usr/sybase/OCS-12_5/lib
-shared -L/usr/local/lib DBlib.o  -o
.../blib/arch/auto/Sybase/DBlib/DBlib.so      \
   -L/usr/sybase/OCS-12_5/lib -lsybdb -lm       \

chmod 755 ../blib/arch/auto/Sybase/DBlib/DBlib.so
cp DBlib.bs ../blib/arch/auto/Sybase/DBlib/DBlib.bs
chmod 644 ../blib/arch/auto/Sybase/DBlib/DBlib.bs
Manifying ../blib/man3/Sybase::DBlib.3
make[1]: Leaving directory `/tmp/sybperl-2.18/DBlib'
make[1]: Entering directory `/tmp/sybperl-2.18/Sybperl'
cp Sybperl.pm ../blib/lib/Sybase/Sybperl.pm
AutoSplitting ../blib/lib/Sybase/Sybperl.pm
(../blib/lib/auto/Sybase/Sybperl)
Manifying ../blib/man3/Sybase::Sybperl.3
make[1]: Leaving directory `/tmp/sybperl-2.18/Sybperl'
Manifying blib/man3/sybperl.3
[sybase@seth sybperl-2.18]$ make test
make[1]: Entering directory `/tmp/sybperl-2.18/BCP'
make[1]: Leaving directory `/tmp/sybperl-2.18/BCP'
make[1]: Entering directory `/tmp/sybperl-2.18/BLK'
make[1]: Leaving directory `/tmp/sybperl-2.18/BLK'
make[1]: Entering directory `/tmp/sybperl-2.18/CTlib'
make[1]: Leaving directory `/tmp/sybperl-2.18/CTlib'
make[1]: Entering directory `/tmp/sybperl-2.18/DBlib'
make[1]: Leaving directory `/tmp/sybperl-2.18/DBlib'
make[1]: Entering directory `/tmp/sybperl-2.18/Sybperl'
make[1]: Leaving directory `/tmp/sybperl-2.18/Sybperl'
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/1_db_dblib...........Sybase message 2401, Severity 11, state 2
Server `SETH'
Line 0
    Character set conversion is not available between client character
set 'iso_1' and server character set 'eucjis'.

t/1_db_dblib...........ok

t/1_db_money...........Msg 2401, Level 11, State 2
Server 'SETH',
        Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.
t/1_db_money...........ok

t/2_ct_ctlib...........Message number: 2401, Severity 11, State 2, Line 0
Server 'SETH'
Message String: Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.

t/2_ct_ctlib...........ok

t/2_ct_cursor..........Message number: 2401, Severity 11, State 2, Line 0
Server 'SETH'
Message String: Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.

t/2_ct_cursor..........ok

t/2_ct_nsql............ok

t/2_ct_prepare.........
Server message:
Message number: 2401, Severity 11, State 2, Line 0
Server 'SETH'
Message String: Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.

t/2_ct_prepare.........ok

t/2_ct_xblk............
Server message:
Message number: 2401, Severity 11, State 2, Line 0
Server 'SETH'
Message String: Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.

t/2_ct_xblk............ok

t/3_bcp................Sybase message 2401, Severity 11, state 2
Server `SETH'
Line 0
    Character set conversion is not available between client character
set 'iso_1' and server character set 'eucjis'.

t/3_bcp................ok

t/4_blk................ok
1/19
Server message:
Message number: 2401, Severity 11, State 2, Line 0
Server 'SETH'
Message String: Character set conversion is not available between client
character set 'iso_1' and server character set 'eucjis'.


Open Client Message:
Message number: LAYER = (5) ORIGIN = (2) SEVERITY = (7) NUMBER = (12)
Message String: ct_send(): network packet layer: internal Client Library
error: State error: trying to write when connection is expecting a read.
blk_init failed. at t/4_blk.t line 38

Open Client Message:
Message number: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50)
Message String: ct_cmd_drop(): user api layer: external error: The
connection has been marked dead.
t/4_blk................dubious

        Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 5-19
        Failed 15/19 tests, 21.05% okay
t/5_sybperl............Sybase message 2401, Severity 11, state 2
Server `SETH'
Line 0
    Character set conversion is not available between client character
set 'iso_1' and server character set 'eucjis'.

Sybase message 2401, Severity 11, state 2
Server `SETH'
Line 0
    Character set conversion is not available between client character
set 'iso_1' and server character set 'eucjis'.

t/5_sybperl............ok

t/5_sybperl_dbmoney....Sybase message 2401, Severity 11, state 2
Server `SETH'
Line 0
    Character set conversion is not available between client character
set 'iso_1' and server character set 'eucjis'.

t/5_sybperl_dbmoney....ok

Failed Test Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------

t/4_blk.t      2   512    19   30 157.89%  5-19
Failed 1/11 test scripts, 90.91% okay. 15/215 subtests failed, 93.02% okay.
make: *** [test_dynamic] Error 255

 -george



This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.