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: Sybperl errors.
Date: Aug 30 2001 3:43PM

Try rebuilding perl - it *may* be the solution.

Michael

nsmudde@csc.com writes:
 > We have been working offline with Brad who has been very helpful.
 > 
 > Could it have anything to do with the fact that we pulled a binary version
 > of perl rather than compiling from source?
 > 
 > I submit this one more time, just hoping.....
 > 
 > Nancy
 > ---------------------- Forwarded by Nancy C Smudde/TMG/CSC on 08/29/2001
 > 10:34 AM ---------------------------
 > 
 > 
 > Al S Lo Piccolo/TMG/CSC
 > 08/29/2001 08:43 AM
 > 
 > To:   Brad_Ziegler@notes.mdor.state.mn.us
 > cc:   Brad_Ziegler@notes.mdor.state.mn.us, Nancy C Smudde/TMG/CSC@CSC
 > Subject:  Re: Sybperl errors.  (Document link: Database 'Nancy C Smudde',
 >       View '($Inbox)')
 > 
 > Brad,
 > 
 > Thanks, but that did not work either. Do you know what files we should have
 > in our $SYBASE/lib directory?
 > 
 > Thanks...Al
 > 
 > 
 > 
 > Brad_Ziegler@notes.mdor.state.mn.us on 08/28/2001 01:12:21 PM
 > 
 > To:   Al S Lo Piccolo/TMG/CSC@CSC
 > cc:   Brad_Ziegler@notes.mdor.state.mn.us, Nancy C Smudde/TMG/CSC@CSC
 > Subject:  Re: Sybperl errors.
 > 
 > 
 > 
 > Hmmmm, I see 2 things.  First, is //bin in your path really what you want?
 > Next, you might want to add /sybase/syb115/bin to your path.  Then give it
 > another shot.
 > 
 > Good luck,
 > Brad
 > 
 > 
 > 
 >                     alopicco@csc.
 >                     com                  To:
 > Brad_Ziegler@notes.mdor.state.mn.us
 >                                          cc:     nsmudde@csc.com
 >                     08/28/01             Subject:     Re: Sybperl errors.
 >                     02:20 PM
 > 
 > 
 > 
 > 
 > 
 > 
 > Hello Brad,
 > 
 > Here are our env settings:
 > 
 > newhacunix1:root> env
 > _=/usr/bin/env
 > MANPATH=/usr/local/datatools2/man:/usr/man:/usr/local/syncsort/man
 > LANG=en_US
 > LOGIN=root
 > IMQCONFIGCL=/etc/IMNSearch/dbcshelp
 > NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
 > PATH=/usr/local/datatools/sbacktrack/bin:/usr/bin:/bin:/usr/ccs/bin:/usr/lpp:/etc:/usr/sbin:/usr/ucb:.://bin:/usr/bin/X11:/sbin:/hac/cmds:/usr/local/nw:/usr/local/nw/bin:/usr/local/nw/client:/home/patrol/AIX-RS/bin/.:/usr/local/syncsort/bin:/usr/local/bin:/usr/local/patrol/PATROL3.2:/usr/InHouse/legato:/nw/label:/usr/man:/usr/local/nw:/usr/bin
 > 
 > 
 > LC__FASTMSG=true
 > IMQCONFIGSRV=/etc/IMNSearch
 > CGI_DIRECTORY=/var/docsearch/cgi-bin
 > LOGNAME=root
 > DT_SBACKTRACK_PATH=/usr/local/datatools2/backups/daily:/usr/local/datatools2/backups/offsite:/usr/local/datatools2/backups/weekly
 > 
 > 
 > MAIL=/usr/spool/mail/root
 > LOCPATH=/usr/lib/nls/loc
 > DTBASE=/usr/local/datatools2
 > SYBASE=/sybase/syb115
 > USER=root
 > DOCUMENT_SERVER_MACHINE_NAME=localhost
 > DSQUERY=silver115
 > AUTHSTATE=compat
 > DTHOME=/usr/local/datatools
 > SHELL=/bin/ksh
 > ODMDIR=/etc/objrepos
 > DOCUMENT_SERVER_PORT=49213
 > HOME=/
 > TERM=vt100
 > MAILMSG=[YOU HAVE NEW MAIL]
 > PWD=/apps/ftpdata
 > DOCUMENT_DIRECTORY=/usr/docsearch/html
 > TZ=PST8PDT
 > ENV=~.kshrc
 > DEVICE=/dev/rmt0.1
 > PATROL_HOME=/home/patrol/AIX-RS
 > DT_SBACKTRACK_HOME=/usr/local/datatools/sbacktrack
 > A__z=! LOGNAME
 > LIBPATH=/sybase/syb115/lib
 > newhacunix1:root>
 > 
 > And the location of the Sybase binaries is /sybase/syb115/bin.
 > 
 > Thanks...Al
 > 
 > 
 > 
 > 
 > 
 > Brad_Ziegler@notes.mdor.state.mn.us on 08/28/2001 11:39:07 AM
 > 
 > To:   Nancy C Smudde/TMG/CSC@CSC
 > cc:   Al S Lo Piccolo/TMG/CSC@CSC
 > Subject:  Re: Sybperl errors.
 > 
 > 
 > 
 > What are your environment settings? (all of them)  I believe you mentioned
 > below that you lib name was /sybase/syb115/lib.  Correspondingly, are the
 > binaries in /sybase/syb115/bin?
 > 
 > Brad
 > 
 > 
 > 
 > 
 > 
 >                     nsmudde@csc.c
 >                     om                   To:
 > Brad_Ziegler@notes.mdor.state.mn.us
 >                                          cc:     alopicco@csc.com
 >                     08/28/01             Subject:     Re: Sybperl errors.
 >                     11:23 AM
 > 
 > 
 > 
 > 
 > 
 > 
 > Thanks for the reply.  It is good to hear of your success, since we are
 > having such a miserable time getting started.
 > 
 > We changed the environment variable LIBPATH as you suggested with no
 > difference in the results.  We had the same problem with DBD::Sybase which
 > is why we tried the Sybperl, thinking that it was older and better tested.
 > 
 > The system administrator said that he even tried changing the makefile
 > directly to point to our SYBASE directory.   We still have not been able to
 > load this module.  We are on the verge of bcping the data out and working
 > with flat files!
 > 
 > Thanks again for your input.
 > Nancy
 > 
 > 
 > 
 > 
 > 
 > Brad_Ziegler@notes.mdor.state.mn.us on 08/28/2001 08:31:14 AM
 > 
 > To:   Nancy C Smudde/TMG/CSC@CSC
 > cc:
 > Subject:  Re: Sybperl errors.
 > 
 > 
 > 
 > Yes, my libraries do have members with the .so.a extension.  Here is my
 > Open Client 12 library subdirectory:
 > libblk.a                libct_r.a               libsrv.a
 > libblk_r.a              libct_r.exp             libsrv.exp
 > libcobct.a              libct_r.so.a            libsrv.so.a
 > libcobct_r.a            libddce.so.a            libsrv_r.a
 > libcomn.a               libddce.so.a.12.0.1     libsrv_r.exp
 > libcomn.exp             libinsck.so.a           libsrv_r.so.a
 > libcomn.so.a            libinsck.so.a.12.0.1    libsybdb.a
 > libcomn_r.a             libinsck_r.so.a         libsybdb.exp
 > libcomn_r.exp           libinsck_r.so.a.12.0.1  libsybdb.so.a
 > libcomn_r.so.a          libintl.a               libtcl.a
 > libcs.a                 libintl.exp             libtcl.exp
 > libcs.exp               libintl.so.a            libtcl.so.a
 > libcs.so.a              libintl_r.a             libtcl_r.a
 > libcs_r.a               libintl_r.exp           libtcl_r.exp
 > libcs_r.exp             libintl_r.so.a          libtcl_r.so.a
 > libcs_r.so.a            libsdce.so.a            libxadtm.a
 > libct.a                 libsdce.so.a.12.0.1     libxadtm.so.a
 > libct.exp               libskrb.so.a
 > libct.so.a              libskrb.so.a.12.0.1
 > 
 > We have been using Perl with Sybperl for probably 4 or so years.  We
 > replaced AIX COBOL & Embedded SQL for COBOL programs with Perl & Sybperl
 > and reduced the runtimes by over a factor of 10.  No problems with
 > stability that we have seen.  We are also converting our warehouse
 > migration programs that are coded in C over to Perl.  Runtimes are around
 > the same so far.
 > 
 > We will soon be converting over to use DBI with DBD::Sybase for portability
 > reasons.  We also have DB2 UDB and want to be able to write to 1 api (DBI)
 > instead of 3 (Sybperl, DBI, and ODBC).  We use Sybase ASE, Sybase IQ, and
 > DB2 UDB.  I'm having problems installing the DBD::ODBC module to use for
 > IQ, but DBD::Sybase works fine for now.
 > 
 > Brad
 > 
 > PS.  Was it your Libpath that was causing your problems?
 > 
 > 
 > 
 > 
 >                     nsmudde@csc.c
 >                     om                   To:
 > Brad_Ziegler@notes.mdor.state.mn.us
 >                                          cc:
 >                     08/27/01             Subject:     Re: Sybperl errors.
 >                     02:43 PM
 > 
 > 
 > 
 > 
 > 
 > 
 > Thanks for your response.
 > Do your sybase libraries also have the .so.a extensions?
 > How long have you been using sybper on AIX?  Is is stable?
 > Thanks
 > Nancy
 > 
 > 
 > 
 > 
 > Brad_Ziegler@notes.mdor.state.mn.us@list.cren.net on 08/23/2001 08:38:26 AM
 > 
 > Please respond to SYBPERL-L@list.cren.net
 > 
 > Sent by:  owner-SYBPERL-L@list.cren.net
 > 
 > 
 > To:   SybPerl Discussion List 
 > cc:
 > Subject:  Re: Sybperl errors.
 > 
 > 
 > 
 > Double check the libpath to ensure that it is also pointing at the correct
 > Sybase lib directory.  That is usually where I go wrong when the build of
 > the makefile goes awry.
 > Brad
 > 
 > 
 > 
 > 
 >                     Michael Peppler
 >                      List 
 >                     rg>                        cc:
 >                     Sent by:                   Subject:     Re: Sybperl
 > errors.
 >                     owner-SYBPERL-L@lis
 >                     t.cren.net
 > 
 > 
 >                     08/23/01 10:18 AM
 >                     Please respond to
 >                     SYBPERL-L
 > 
 > 
 > 
 > 
 > 
 > 
 > nsmudde@csc.com writes:
 >  > There are mostly .a files in /lib and /usr/lib.  There are a few .so.a
 >  > lib.b
 >  > libC.a
 >  > libC128.a
 > 
 > Hmmm... All I can think of is that perl isn't finding the libraries
 > when it tries to build the Makefiles (during perl Makefile.PL).
 > 
 > >From your original email, I see that perl thinks shared libraries
 > should end in .a, but not .so.a, and that may be the problem.
 > 
 > Was perl built on this box/OS version?
 > 
 > It seems to me that perl is looking for libct.a and not finding it
 > (and doesn't see libct.so.a as a viable alternative!)
 > 
 > Anyone else with AIX experience on this list?
 > 
 > Michael
 > 
 > 
 >  >
 >  > Michael Peppler @list.cren.net on 08/22/2001
 > 03:51:38
 >  > PM
 >  >
 >  > Please respond to SYBPERL-L@list.cren.net
 >  >
 >  > Sent by:  owner-SYBPERL-L@list.cren.net
 >  >
 >  >
 >  > To:   SybPerl Discussion List 
 >  > cc:
 >  > Subject:  Re: Sybperl errors.
 >  >
 >  >
 >  > nsmudde@csc.com writes:
 >  >  > This is what is in the directory.
 >  >  > % cd /sybase/syb115/lib
 >  >  > % ll
 >  >  > total 30288
 >  >  > -rwxr-xr-x   1 sybase   sybase   7944759 Mar 07 1998  dbgomni1.so*
 >  >  > -rwxr-xr-x   1 sybase   sybase    720592 Dec 23 1997  libcomn.so.a*
 >  >  > -rwxr-xr-x   1 sybase   sybase    742794 Dec 23 1997  libcomn_r.so.a*
 >  >  > -rwxr-xr-x   1 sybase   sybase    109515 Dec 23 1997  libcs.so.a*
 >  >
 >  > Hmmm... I'm not familiar with AIX, but the file names seem strange
 >  > (ending in .so.a rather than just .so)
 >  >
 >  > If that is wrong then the Makefile.PL script won't find any of the
 >  > library files...
 >  >
 >  > Could you check in /lib or /usr/lib to see what the naming convention
 >  > for library files should be?
 >  >
 >  > Michael
 >  >
 >  >
 >  >  > Michael Peppler @list.cren.net on 08/22/2001
 >  > 03:04:42
 >  >  > PM
 >  >  >
 >  >  > Please respond to SYBPERL-L@list.cren.net
 >  >  >
 >  >  > Sent by:  owner-SYBPERL-L@list.cren.net
 >  >  >
 >  >  >
 >  >  > To:   SybPerl Discussion List 
 >  >  > cc:
 >  >  > Subject:  Re: Sybperl errors.
 >  >  >
 >  >  >
 >  >  > nsmudde@csc.com writes:
 >  >  >  > Thanks for the quick response.
 >  >  >  > Actually we have both Sybase 11.5 and 12 on this machine with 11.5
 > as
 >  >  >  > production.  All of the variables are set to the 11.5
 > installation.
 >  >  >  >
 >  >  >  > We noticed that the LD_RUN_PATH points to /lib but we have set
 > this
 >  > path
 >  >  > to
 >  >  >  > /sybase/syb115/lib in both the profile and the makefile.
 >  >  >  > Could this be a problem?
 >  >  >  >
 >  >  >  > -DDO_TIE CTlib.c
 >  >  >  > cc: unrecognized option `-qmaxmem=16384'
 >  >  >  > cc: unrecognized option `-q32'
 >  >  >  > cc: unrecognized option `-qlonglong'
 >  >  >  > mkdir ../blib/arch/auto/Sybase/CTlib
 >  >  >  > Running Mkbootstrap for Sybase::CTlib ()
 >  >  >  >         chmod 644 CTlib.bs
 >  >  >  >         LD_RUN_PATH="/lib" ld -o
 >  > ../blib/arch/auto/Sybase/CTlib/CTlib.so
 >  >  >  > -L/sybase/syb115/lib -bhalt:4 -bM:SRE
 >  >  >  > -bI:/usr/local/lib/perl5/5.6.0/aix/CORE/perl.exp -bE:CTlib.exp -b
 >  >  > noentry
 >  >  >  > -lC -lc -L/usr/local/lib CTlib.o    -L/sybase/syb115/lib -lm
 >  >  >
 >  >  > You can see from the link line here that the script didn't find any
 >  >  > Sybase libraries. There should be a -lct -lcs -lcomn -ltcl -lintl, at
 >  >  > least.
 >  >  >
 >  >  > So go check /sybase/syb115/lib and see if you have any .a or .so
 > files
 >  >  > in there - my guess is that they aren't installed.
 >  >  >
 >  >  > Michael
 >  >  >
 >  >  >
 >  >  >  > Michael Peppler @list.cren.net on 08/22/2001
 >  >  > 01:31:15
 >  >  >  > PM
 >  >  >  >
 >  >  >  > Please respond to SYBPERL-L@list.cren.net
 >  >  >  >
 >  >  >  > Sent by:  owner-SYBPERL-L@list.cren.net
 >  >  >  >
 >  >  >  >
 >  >  >  > To:   SybPerl Discussion List 
 >  >  >  > cc:
 >  >  >  > Subject:  Re: Sybperl errors.
 >  >  >  >
 >  >  >  >
 >  >  >  > nsmudde@csc.com writes:
 >  >  >  >  > We are having trouble loading sybperl.  The system admin has
 > tried
 >  >  >  >  > everything from changing various path statements to
 > reinstalling
 >  > perl
 >  >  >  > from
 >  >  >  >  > source.  Please see errors in attached message.  I know that we
 >  >  > resolved
 >  >  >  >  > this before on another system, but nothing works here.  Any
 > help
 >  > is
 >  >  >  >  > appreciated.
 >  >  >  >
 >  >  >  > A couple of issues.
 >  >  >  >
 >  >  >  > First:
 >  >  >  >
 >  >  >  >  > We are running:
 >  >  >  >  > $ perl -V
 >  >  >  >  > Summary of my perl5 (revision 5.0 version 6 subversion 0)
 >  >  > configuration:
 >  >  >  >
 >  >  >  >  >   Linker and Libraries:
 >  >  >  >  >     ld='ld', ldflags =' -L/usr/local/lib -b32'
 >  >  >  >  >     libpth=/usr/local/lib /lib /usr/lib /usr/ccs/lib
 >  >  >  >  >     libs=-lbind -lnsl -ldbm -ldb -ldl -lld -lm -lC -lc -lcrypt
 >  > -lbsd
 >  >  >  > -lPW
 >  >  >  >  > -licov
 >  >  >  >
 >  >  >  > The -ldb above is going to cause problems if libdb.a is from
 > Berkeley
 >  >  >  > DB 1.x (because it has a function called dbopen(), which will
 >  > conflict
 >  >  >  > with DBlibrary's dbopen()).
 >  >  >  >
 >  >  >  >  > Hi Nancy,
 >  >  >  >  > Here are the errors.  I noticed that a lot of the undefined
 >  > symbols
 >  >  >  > start
 >  >  >  >  > with "ct". Does this product expect to have the sybase ct
 >  > libraries
 >  >  >  >  > installed on the server? If it does, that could be a problem as
 > we
 >  > do
 >  >  >  > not
 >  >  >  >  > own the server version.
 >  >  >  >  >
 >  >  >  >  > Al
 >  >  >  >  >
 >  >  >  >  > newhacunix1:root> perl Makefile.PL
 >  >  >  >  > Checking if your kit is complete...
 >  >  >  >  > Looks good
 >  >  >  >  > Checking if your kit is complete...
 >  >  >  >  > Looks good
 >  >  >  >  > Writing Makefile for Sybase::BCP
 >  >  >  >  > Note (probably harmless): No library found for -lct
 >  >  >  >  > Note (probably harmless): No library found for -lcs
 >  >  >  >  > Note (probably harmless): No library found for -ltcl
 >  >  >  >  > Note (probably harmless): No library found for -lcomn
 >  >  >  >  > Note (probably harmless): No library found for -lintl
 >  >  >  >  > Note (probably harmless): No library found for -linsck
 >  >  >  >  > Writing Makefile for Sybase::CTlib
 >  >  >  >  > Note (probably harmless): No library found for -lsybdb
 >  >  >  >  > Note (probably harmless): No library found for -linsck
 >  >  >  >
 >  >  >  > OK - now this is the real problem. When running perl Makefile.PL
 > the
 >  >  >  > script can't find the Sybase library files anywhere (or at least
 > not
 >  >  >  > where it expects them).
 >  >  >  >
 >  >  >  > Is the SYBASE env. variable set correctly?
 >  >  >  >
 >  >  >  > If this is ASE 12.x, is the SYBASE_OCS variable set correctly? (in
 >  >  >  > general for ASE 12.x the easiest thing to do is to source the
 >  >  >  > SYBASE.sh or SYBASE.csh file that the Sybase installation creates
 > in
 >  >  >  > the root directory of the Sybase install tree to get the correct
 >  >  >  > env. variables set).
 >  >  >  >
 >  >  >  > Michael
 >  >  >  > --
 >  >  >  > Michael Peppler - Data Migrations Inc. -
 >  > http://www.mbay.net/~mpeppler
 >  >  >  > mpeppler@peppler.org - mpeppler@mbay.net
 >  >  >  > International Sybase User Group - http://www.isug.com
 >  >  >  >
 >  >  >  >
 >  >  >
 >  >  > --
 >  >  > Michael Peppler - Data Migrations Inc. -
 > http://www.mbay.net/~mpeppler
 >  >  > mpeppler@peppler.org - mpeppler@mbay.net
 >  >  > International Sybase User Group - http://www.isug.com
 >  >  >
 >  >  >
 >  >
 >  > --
 >  > Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
 >  > mpeppler@peppler.org - mpeppler@mbay.net
 >  > International Sybase User Group - http://www.isug.com
 >  >
 >  >
 > 
 > --
 > Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
 > mpeppler@peppler.org - mpeppler@mbay.net
 > International Sybase User Group - http://www.isug.com
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 

-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com