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 Peppler <mpeppler at peppler dot org>
Subject: RE: Another Sybperl install prob
Date: Jan 26 2000 5:10PM

David White writes:
 > Still having problems installing on linux  always fails in the same place.
 > 
 > I tried adding the env vars
 > I tried commenting out the static linking in the CONFIG file in sybperl
 > I tried adding -lcs    is it lc or lcs because lcs would not work
 > 
 > Could somebody walk me throught it?  I would reallllly apreciate it!!!

[WARNING - long message!]

First - are you sure that the OpenClient libs are installed correctly?
If you have the 11.9.2/11.1.1 OC you should have these files:

   4 -r-xr-xr-x   1 sybase   sybase       3703 Jul 12  1999 examples.so*
 120 -r-xr-xr-x   1 sybase   sybase     117362 Jun  7  1999 libblk.a*
 524 -r-xr-xr-x   1 sybase   sybase     529520 Jun  7  1999 libcomn.a*
 396 -r-xr-xr-x   1 sybase   sybase     398293 Jun  7  1999 libcomn.so*
  84 -r-xr-xr-x   1 sybase   sybase      81542 Jun  7  1999 libcs.a*
  60 -r-xr-xr-x   1 sybase   sybase      55936 Jun  7  1999 libcs.so*
 664 -r-xr-xr-x   1 sybase   sybase     673002 Jun  7  1999 libct.a*
 436 -r-xr-xr-x   1 sybase   sybase     441107 Jun  7  1999 libct.so*
  12 -r-xr-xr-x   1 sybase   sybase      10139 Jun  7  1999 libinsck.so*
  56 -r-xr-xr-x   1 sybase   sybase      51112 Jun  7  1999 libintl.a*
  32 -r-xr-xr-x   1 sybase   sybase      31922 Jun  7  1999 libintl.so*
 588 -r--r--r--   1 sybase   sybase     594466 Jun  7  1999 libsrv.a
 372 -r-xr-xr-x   1 sybase   sybase     374182 Jun  7  1999 libsrv.so*
   8 -r-xr-xr-x   1 sybase   sybase       6508 Jun 10  1999 libssencode.so*
 136 -r-xr-xr-x   1 sybase   sybase     132363 Jun 10  1999 libssfile.so*
   8 -r-xr-xr-x   1 sybase   sybase       8113 Jun 10  1999 libsstasks6.so*
1336 -r-xr-xr-x   1 sybase   sybase    1361512 Jun 10  1999 libsstools6.so*
1212 -r-xr-xr-x   1 sybase   sybase    1232950 Jun  7  1999 libsybdb.a*
 768 -r-xr-xr-x   1 sybase   sybase     782151 Jun  7  1999 libsybdb.so*
 276 -r-xr-xr-x   1 sybase   sybase     276644 Jun  7  1999 libsybtcl.a*
 160 -r-xr-xr-x   1 sybase   sybase     156706 Jun  7  1999 libsybtcl.so*
   8 -r-xr-xr-x   1 sybase   sybase       6260 Jul 12  1999 sybsyesp.so*
  20 -r-xr-xr-x   1 sybase   sybase      18237 Jul 12  1999 xpsmsgs.so*

If you have the 11.0.3.3/10.0.4 files:

 100 -rw-r--r--   1 root     root        97954 Sep 10  1998 libblk.a
 384 -rw-r--r--   1 root     root       388928 Sep 10  1998 libcomn.a
 288 -rwxr-xr-x   1 root     root       290474 Sep 10  1998 libcomn.so*
  76 -rw-r--r--   1 root     root        70060 Sep 10  1998 libcs.a
  48 -rwxr-xr-x   1 root     root        47565 Sep 10  1998 libcs.so*
 536 -rw-r--r--   1 root     root       542890 Sep 10  1998 libct.a
 352 -rwxr-xr-x   1 root     root       355201 Sep 10  1998 libct.so*
   8 -rw-r--r--   1 root     root         7312 Sep 10  1998 libinsck.a
   8 -rwxr-xr-x   1 root     root         7568 Sep 10  1998 libinsck.so*
  56 -rw-r--r--   1 root     root        49624 Sep 10  1998 libintl.a
  32 -rwxr-xr-x   1 root     root        31062 Sep 10  1998 libintl.so*
 532 -rw-r--r--   1 root     root       537636 Sep 10  1998 libsrv.a
 328 -rwxr-xr-x   1 root     root       331683 Sep 10  1998 libsrv.so*
1052 -rw-r--r--   1 root     root      1071836 Sep 10  1998 libsybdb.a
 656 -rwxr-xr-x   1 root     root       666919 Sep 10  1998 libsybdb.so*
 140 -rw-r--r--   2 root     root       135180 Sep 10  1998 libsybtcl.a
  84 -rwxr-xr-x   2 root     root        78923 Sep 10  1998 libsybtcl.so*
 140 -rw-r--r--   2 root     root       135180 Sep 10  1998 libtcl.a
  84 -rwxr-xr-x   2 root     root        78923 Sep 10  1998 libtcl.so*


Second - to build on a RH 6.1 system I do this:

Script started on Wed Jan 26 08:53:21 2000

troll (8:53AM):1 > gunzip -c ~/src/Sybase-dist/sybperl-2.11.tar.gz | tar xvf -
sybperl-2.11/
sybperl-2.11/config.pl
sybperl-2.11/CTlib/
sybperl-2.11/CTlib/t/
sybperl-2.11/CTlib/t/cursor.t
sybperl-2.11/CTlib/t/ctlib.t
sybperl-2.11/CTlib/README
sybperl-2.11/CTlib/CTlib.xs
sybperl-2.11/CTlib/Makefile.PL
sybperl-2.11/CTlib/CTlib.pm.in
sybperl-2.11/DBlib/
sybperl-2.11/DBlib/DBlib.xs
sybperl-2.11/DBlib/Makefile.PL
sybperl-2.11/DBlib/DBlib.pm.in
sybperl-2.11/DBlib/t/
sybperl-2.11/DBlib/t/dblib.t
sybperl-2.11/DBlib/t/money.t
sybperl-2.11/DBlib/README
sybperl-2.11/eg/
sybperl-2.11/eg/rpc-example.pl
sybperl-2.11/eg/TABLEop.pm
sybperl-2.11/eg/README.dbschema
sybperl-2.11/eg/ctlib.pl
sybperl-2.11/eg/sql.pl
sybperl-2.11/eg/bcp.dat
sybperl-2.11/eg/SybWWW.pm
sybperl-2.11/eg/GenRepDefs.pl
sybperl-2.11/eg/ct_sql.pl
sybperl-2.11/eg/ct_param.pl
sybperl-2.11/eg/dbcc.pl
sybperl-2.11/eg/who.pl
sybperl-2.11/eg/proc.isql
sybperl-2.11/eg/README
sybperl-2.11/eg/bcp.pl
sybperl-2.11/eg/dbschema.pl
sybperl-2.11/eg/SecureSql.pm
sybperl-2.11/eg/buffer.pl
sybperl-2.11/eg/dbtext.pl
sybperl-2.11/eg/dbschema.disk.pl
sybperl-2.11/eg/ct_cursor.pl
sybperl-2.11/eg/Show.cgi
sybperl-2.11/eg/Login.pm
sybperl-2.11/eg/dbschema.old
sybperl-2.11/lib/
sybperl-2.11/lib/ctutil.pl
sybperl-2.11/lib/sql.pl
sybperl-2.11/lib/sybperl.pl
sybperl-2.11/lib/sybutil.pl
sybperl-2.11/README.linux
sybperl-2.11/Sybperl/
sybperl-2.11/Sybperl/t/
sybperl-2.11/Sybperl/t/sybperl.t
sybperl-2.11/Sybperl/t/dbmoney.t
sybperl-2.11/Sybperl/Makefile.PL
sybperl-2.11/Sybperl/Sybperl.pm
sybperl-2.11/Sybperl/README
sybperl-2.11/MANIFEST
sybperl-2.11/BCP/
sybperl-2.11/BCP/MANIFEST
sybperl-2.11/BCP/t/
sybperl-2.11/BCP/t/bcp.dat
sybperl-2.11/BCP/t/bcp.t
sybperl-2.11/BCP/BCP.pm
sybperl-2.11/BCP/Makefile.PL
sybperl-2.11/BCP/README
sybperl-2.11/sqlda.h.min
sybperl-2.11/pod/
sybperl-2.11/pod/README
sybperl-2.11/pod/sybperl-1.0xx.man
sybperl-2.11/pod/Makefile
sybperl-2.11/pod/sybperl.pod
sybperl-2.11/Makefile.PL
sybperl-2.11/SPR
sybperl-2.11/patchlevel.h
sybperl-2.11/Version
sybperl-2.11/UPGRADE
sybperl-2.11/PWD
sybperl-2.11/README.win32
sybperl-2.11/CHANGES
sybperl-2.11/README
sybperl-2.11/README.thread
sybperl-2.11/CONFIG
sybperl-2.11/FAQ
troll (8:53AM):2 > cd sybperl-2.11/
troll (8:53AM):3 > perl Makefile.PL 
Checking if your kit is complete...
Looks good
Checking if your kit is complete...
Looks good
Writing Makefile for Sybase::BCP
Writing Makefile for Sybase::CTlib
Writing Makefile for Sybase::DBlib
Writing Makefile for Sybase::Sybperl
Writing Makefile for Sybase
troll (8:53AM):4 > make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Sybase
mkdir blib/lib/auto
mkdir blib/lib/auto/Sybase
cp config.pl blib/lib/config.pl
cp lib/sql.pl blib/lib/sql.pl
cp lib/sybperl.pl blib/lib/sybperl.pl
cp lib/sybutil.pl blib/lib/sybutil.pl
cp lib/ctutil.pl blib/lib/ctutil.pl
make[1]: Entering directory `/tmp/sybperl-2.11/BCP'
mkdir ../blib/lib/Sybase
mkdir ../blib/arch/auto/Sybase/BCP
mkdir ../blib/lib/auto/Sybase/BCP
mkdir ../blib/man3
cp BCP.pm ../blib/lib/Sybase/BCP.pm
Manifying ../blib/man3/Sybase::BCP.3
make[1]: Leaving directory `/tmp/sybperl-2.11/BCP'
make[1]: Entering directory `/tmp/sybperl-2.11/CTlib'
mkdir ../blib/arch/auto/Sybase/CTlib
mkdir ../blib/lib/auto/Sybase/CTlib
cp CTlib.pm ../blib/lib/Sybase/CTlib.pm
AutoSplitting ../blib/lib/Sybase/CTlib.pm (../blib/lib/auto/Sybase/CTlib)
cp CTlib.pod ../blib/lib/Sybase/CTlib.pod
/usr/bin/perl -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 /usr/lib/perl5/5.00502/ExtUtils/xsubpp -prototypes -typemap /usr/lib/perl5/5.00502/ExtUtils/typemap CTlib.xs >CTlib.tc && mv CTlib.tc CTlib.c
cc -c -I/opt/sybase/include -Dbool=char -DHAS_BOOL -I/usr/local/include -O2    -DVERSION=\"2.11\" -DXS_VERSION=\"2.11\" -fpic -I/usr/lib/perl5/5.00502/i686-linux/CORE -DCTLIBVS=100 -DSYBPLVER='"2.11"' -DDO_TIE CTlib.c
Running Mkbootstrap for Sybase::CTlib ()
chmod 644 CTlib.bs
LD_RUN_PATH="/opt/sybase/lib:/lib" cc -o ../blib/arch/auto/Sybase/CTlib/CTlib.so  -L/opt/sybase/lib -shared -L/usr/local/lib CTlib.o    -L/opt/sybase/lib -lct -lcs -lsybtcl -lcomn -lintl -linsck -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.11/CTlib'
make[1]: Entering directory `/tmp/sybperl-2.11/DBlib'
mkdir ../blib/arch/auto/Sybase/DBlib
mkdir ../blib/lib/auto/Sybase/DBlib
cp DBlib.pm ../blib/lib/Sybase/DBlib.pm
AutoSplitting ../blib/lib/Sybase/DBlib.pm (../blib/lib/auto/Sybase/DBlib)
cp DBlib.pod ../blib/lib/Sybase/DBlib.pod
/usr/bin/perl -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 /usr/lib/perl5/5.00502/ExtUtils/xsubpp -prototypes -typemap /usr/lib/perl5/5.00502/ExtUtils/typemap DBlib.xs >DBlib.tc && mv DBlib.tc DBlib.c
cc -c -I/opt/sybase/include -Dbool=char -DHAS_BOOL -I/usr/local/include -O2    -DVERSION=\"2.11\" -DXS_VERSION=\"2.11\" -fpic -I/usr/lib/perl5/5.00502/i686-linux/CORE -DDBLIBVS=1000 -DSYBPLVER='"2.11"' -DDO_TIE DBlib.c
Running Mkbootstrap for Sybase::DBlib ()
chmod 644 DBlib.bs
LD_RUN_PATH="/opt/sybase/lib:/lib" cc -o ../blib/arch/auto/Sybase/DBlib/DBlib.so  -L/opt/sybase/lib -shared -L/usr/local/lib DBlib.o    -L/opt/sybase/lib -lsybdb -linsck -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.11/DBlib'
make[1]: Entering directory `/tmp/sybperl-2.11/Sybperl'
mkdir ../blib/arch/auto/Sybase/Sybperl
mkdir ../blib/lib/auto/Sybase/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.11/Sybperl'
troll (8:56AM):5 > vi PWD
# This file contains optional login id, passwd and server info for the test
# programs:
# You probably don't want to have it lying around after you've made
# sure that everything works OK.

UID=sa
PWD=
SRV=
~
~
~
~
~
~
~
~
~
~
~
~
~
~
troll (8:56AM):6 > make test
make[1]: Entering directory `/tmp/sybperl-2.11/BCP'
make[1]: Leaving directory `/tmp/sybperl-2.11/BCP'
make[1]: Entering directory `/tmp/sybperl-2.11/CTlib'
make[1]: Leaving directory `/tmp/sybperl-2.11/CTlib'
make[1]: Entering directory `/tmp/sybperl-2.11/DBlib'
make[1]: Leaving directory `/tmp/sybperl-2.11/DBlib'
make[1]: Entering directory `/tmp/sybperl-2.11/Sybperl'
make[1]: Leaving directory `/tmp/sybperl-2.11/Sybperl'
make[1]: Entering directory `/tmp/sybperl-2.11/BCP'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/bcp...............ok
All tests successful.
Files=1,  Tests=9,  1 wallclock secs ( 0.14 cusr +  0.03 csys =  0.17 CPU)
make[1]: Leaving directory `/tmp/sybperl-2.11/BCP'
make[1]: Entering directory `/tmp/sybperl-2.11/CTlib'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/ctlib.............ok
t/cursor............ok
All tests successful.
Files=2,  Tests=52,  1 wallclock secs ( 0.46 cusr +  0.05 csys =  0.51 CPU)
make[1]: Leaving directory `/tmp/sybperl-2.11/CTlib'
make[1]: Entering directory `/tmp/sybperl-2.11/DBlib'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/dblib.............ok
t/money.............ok
All tests successful.
Files=2,  Tests=35,  1 wallclock secs ( 0.27 cusr +  0.02 csys =  0.29 CPU)
make[1]: Leaving directory `/tmp/sybperl-2.11/DBlib'
make[1]: Entering directory `/tmp/sybperl-2.11/Sybperl'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -I/usr/lib/perl5/5.00502/i686-linux -I/usr/lib/perl5/5.00502 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/dbmoney...........ok
t/sybperl...........ok
All tests successful.
Files=2,  Tests=60,  0 wallclock secs ( 0.35 cusr +  0.00 csys =  0.35 CPU)
make[1]: Leaving directory `/tmp/sybperl-2.11/Sybperl'
troll (8:56AM):7 > exit

Script done on Wed Jan 26 08:56:54 2000

As you can see I didn't need to do *any* configuration, because my
SYBASE env. variable is set correctly when the perl Makefile.PL is run 
(and I happen to have a test server that accepts a login with 'sa' and 
no password)

Michael


 > -----Original Message-----
 > From: owner-SYBPERL-L@list.cren.net
 > [mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of Michael Peppler
 > Sent: Friday, January 21, 2000 2:54 PM
 > To: SybPerl Discussion List
 > Subject: Re: Another Sybperl install prob
 > 
 > 
 > David White writes:
 >  > during the make test portion of the setup I get a number of Undefined
 >  > references .
 >  > CTlib.o(.text+0xad79): undefined reference to `cs_cmp'
 > 
 > Looks like you aren't linking to -lcs, or that those symbols aren't
 > found during the make test session.
 > 
 > You probably need to set LD_LIBRARY_PATH to point to $SYBASE/lib
 > before running make test.
 > 
 > I note that you use static linking for sybperl. I would recommend not
 > doing that unless you believe that there is a specific need for it.
 > 
 > Michael
 > -- 
 > Michael Peppler         -||-  Data Migrations Inc.
 > mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
 > Int. Sybase User Group  -||-  http://www.isug.com
 > Sybase on Linux mailing list: ase-linux-list@isug.com
 > 
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com