Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Eric Webber <streethockey at ureach dot com>
Subject: HELP, Syberl does not like my interfaces file, but isql does ???!!!!!
Date: Aug 2 2000 1:57PM

HELP, Syberl does not like my interfaces file, but isql 
does ???!!!!!

Could this be because my interfaces file is the newer, binary 
hex looking file as opposed to the host port clear text type ?

here it is:

## OFA300 on
##       Services:
##              query   tcp     (5600)
##              master  tcp     (5600)

OFA300 4 2
        query  tli tcp /dev/tcp

#  query tcp ether arioch 5600  
# notice I commented out the above line as it does NOT work, 
# but the hex looking line works with isql but NOT sybperl

Ok, here is the deal.  If I change my interfaces file to the 
format you describe below, isql will not work, AND neither will 
sybperl, of course.  But if I leave my interfaces file alone, 
isql WILL work, but sybperl will not.  I guess it might be 
important to note that we are trying to run sybperl on ONE box, 
and SYBASE itself on ANOTHER BOX, i.e. CLIENT/SERVER.  The 
interfaces file we are using on our linux client box is of the 
format that works with the sybase server running on solaris.
Notice that our interfaces file is NOT of the host port clear 
text type, but rather uses a binary hex looking address instead.
Can someone please help me figure out WHY I can isql across the 
network to my sybase server, but cannot sybperl across ?????

Also I have attached my ENVIRONMENT SPECIFICS AGAIN below, so 
please look at them closely, I have also included the error 
messages I get.  It all appears to fail on that interfaces file.
BUT WHY THEN does openclient and isql WORK with this interfaces 
file ??!!!!

The environment files and error messages follow mpeppler's 
comments below.

---- On Mon, 31 Jul 2000, Michael Peppler 
( wrote:

> Eric Webber writes:
>  > Dear Mike, I too am having difficulties with "make test"
>  > but under linux.  Please see my versions and error 
>  > below, and if you can specifically respond to my issue, I 
>  > be MOST grateful, thanks !!!
>  >  t/bcp...............dubious
>  >          Test returned status 255 (wstat 65280, 0xff00)
>  >  make[1]: Leaving directory `/root/sybperl/sybperl-
>  > 
>  > 
>  >  Sybase error: Unknown network type found in interface 
> I don't know why isql works, but this line clearly describes 
the error 
> as being in the interfaces file. The interfaces file on linux 
> be
> 	query tcp ether  
> 	master tcp ether  
> Michael
> -- 
> Michael Peppler         -||-  Data Migrations Inc.
>    -||-
> Int. Sybase User Group  -||-
> Sybase on Linux mailing list:


This is sybperl, version 2.12

Sybase::DBlib $Revision: 1.50 $ $Date: 2000/05/13 22:52:58 $ 

Copyright (c) 1991-1999 Michael Peppler

This is sybperl, version 2.12

Sybase::CTlib $Revision: 1.41 $ $Date: 2000/05/13 22:51:14 $

Copyright (c) 1995-1999 Michael Peppler
Portions Copyright (c) 1995 Sybase, Inc.

Summary of my perl5 (5.0 patchlevel 5 subversion 3) 
    osname=linux, osvers=2.2.5-22smp, archname=i386-linux
    uname='linux 2.2.5-22smp #1 smp wed 
jun 2 
09:11:51 edt 1999 i686 unknown '
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef useperlio=undef d_sfio=undef
    cc='cc', optimize='-O2', gccversion=egcs-2.91.66 
(egcs-1.1.2 release)
    cppflags='-Dbool=char -DHAS_BOOL -I/usr/local/include'
    ccflags ='-Dbool=char -DHAS_BOOL -I/usr/local/include'
    stdchar='char', d_stdstdio=undef, usevfork=false
    intsize=4, longsize=4, ptrsize=4, doublesize=8
    d_longlong=define, longlongsize=8, d_longdbl=define, 
    alignbytes=4, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib
    libs=-lnsl -ldl -lm -lc -lposix -lcrypt
    libc=, so=so, useshrplib=false, libperl=libperl.a
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, 
    cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'


Characteristics of this binary (from libperl): 
  Built under linux
  Compiled at Aug 30 1999 23:09:51



==================  END of version info

ERROR MESSAGES WHEN running "make test" on sybperl

[root@gemini1 sybperl-2.12]# make test
make[1]: Entering directory `/root/sybperl/sybperl-2.12/BCP'
make[1]: Leaving directory `/root/sybperl/sybperl-2.12/BCP'
make[1]: Entering directory `/root/sybperl/sybperl-2.12/CTlib'
make[1]: Leaving directory `/root/sybperl/sybperl-2.12/CTlib'
make[1]: Entering directory `/root/sybperl/sybperl-2.12/DBlib'
make[1]: Leaving directory `/root/sybperl/sybperl-2.12/DBlib'
make[1]: Entering directory `/root/sybperl/sybperl-2.12/Sybperl'
make[1]: Leaving directory `/root/sybperl/sybperl-2.12/Sybperl'
make[1]: Entering directory `/root/sybperl/sybperl-2.12/BCP'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib -
00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Harness 
qw(&runtests $ve
rbose); $verbose=0; runtests @ARGV;' t/*.t
t/bcp...............Sybase error: Unknown network type found in 
interface file.
OS Error: Unknown error 4294967295
Can't call method "sql" on an undefined value at t/bcp.t line 
        Test returned status 255 (wstat 65280, 0xff00)
Undefined subroutine &Test::Harness::WCOREDUMP called 
at /usr/lib/perl5/5.00503/
Test/ line 288.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory `/root/sybperl/sybperl-2.12/BCP'
make: *** [test] Error 2
[root@gemini1 sybperl-2.12]#

Get your own "800" number - Free
Free voicemail, fax, email, and a lot more