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 Sattler <msattler at jungle dot com>
Subject: Re: Looking before I leap: installing sybase
Date: Feb 28 1996 7:04PM

>mpeppler@itf.CH (Michael Peppler) said:
>> From: Michael Sattler 
>>
>> THE STORY THUS FAR:  Sybase is installed into /data/sybase, CGI.pm is
>> installed and the library moved manually to /usr/local/lib/perl5, Sybperl
>> is built but we can't figure out where to place it so that CGIs can access
>> the database.
>
>Normally, if you run
>
>	make install
>
>in the sybperl source directory all the files get placed in the right
>directories. From your statements you appear to have a standard Perl
>library location, and that shouldn't require any special handling.
>
>It's a little bit difficult to figure out what is wrong based on the
>information you've given. I suspect that it is something simple,
>though.

Thanks for the reply, Michael, and the gentle kick in the caboose for not
providing version and trace info.  Mea culpa.  I didn't because everything
seemed to run without warning or error, not that that's much of an excuse.

>Hardware/OS environment (for example: Sparc/SunOS4.x)

DEC Alpha OSF/1

>Exact perl release (run perl -v please)

5.001m

>Sybase OpenClient version

According to the manual, 10.0.x for DEC AXP OSF/1.

To come full circle, here is what Lang Zerner (a co-worker) wound up doing
to get Sybperl to run.  I hope that this is helpful to others.  For our
info, what did I do incorrectly?

My best to the readership, M

--- snip ---

From: lang@apocalypse.org (Lang Zerner)
To: msattler@jungle.com
Subject: Sybperl seems to be working
Date: Wed, 28 Feb 1996 02:15:30 GMT
Organization: ITC Consulting Group

/data/sybase/sybperl/eg/lang.pl is a copy of sql.pl in the same directory,
with a valid Sybase username and password hardcoded.  This is a security risk.
I have been using lang.pl to test the Sybperl installation.

While we spoke on the phone, I:

1) Created a /usr/local/lib/perl5/Sybase directory.

2) Copied CTlib.pm, DBlib.pm, and Sybperl.pm from
/data/sybase/sybperl/blib/Sybase to /usr/local/lib/perl5/Sybase.

This changed the lang.pl error from "Cannot find Sybase/DBlib.pm in @INC..."
to "Cannot find loadable module for Sybase::DBlib in @INC..."

3) Copied CTlib.so from /data/sybase/sybperl/blib/auto/Sybase/CTlib to
/usr/local/lib.

4) Copied DBlib.so from /data/sybase/sybperl/blib/auto/Sybase/DBlib to
/usr/local/lib.

This changed the error message to "DB-Library: Server name not found in
interface file."

The interface file is /data/sybase/interfaces, and AANS_SERVER is very clearly
described there.  However, the Sybase DB Client library doc says we have to
specify the server name in an environment variable called DSQUERY.

5) Set DSQUERY to AANS_SERVER.

This changed the error message to "Can't locate auto/Sybase/DBlib/sql.al in
@INC..."

6) Created /usr/local/lib/perl5/auto/Sybase.

7. Did a recursive copy of everything from
/data/sybase/sybperl/blib/auto/Sybase to /usr/local/lib/perl5/auto/Sybase.

The sample program works without error.

Be seeing you...
--Lang

ITC Consulting Group      integrated communication consulting services
915 Cole Street #151      internet publishing * networks * training * design
San Francisco, CA 94117   +1 800 673 7172 (outside USA call +1 415 861 7688)
itc@apocalypse.org        http://www.apocalypse.org/pub/itc/

--- snip ---

-----------------------------------------------------------------------+
Michael Sattler, Digital Jungle            |
San Francisco, California, USA        |
                                                                       |
I wrote "Internet TV with CU-SeeMe" for you to enjoy; ISBN 1575210061. |
                                                                       |
Wired via Metricom Ricochet wireless modems, I'm in the People's Cafe. |
Help wire California's schools on 9 Mar 96 -- http://www.netday96.com/ |