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: Lucas Rockwell <lr at socrates dot Berkeley dot EDU>
Subject: Re: sybperl and encryption
Date: Jun 27 2002 6:38PM

Michael,

Again, thanks. In the future, I'll make sure to use CTLib, so I won't have
a need to have DBSETLENCRYPT() added to DBLib.

-lucas

On 26 Jun 2002, Michael Peppler wrote:

> On Wed, 2002-06-26 at 16:34, Lucas Rockwell wrote:
> > Michael,
> >
> > Thanks for the response. That's the answer I was looking for.
>
> You're welcome.
>
> I browsed the DBlib manual, and there is a DBSETLENCRYPT() call, but
> that hasn't been implemented in Sybase::DBlib.
>
> If you (or someone else) needs/wants this it can be added quite easily.
>
> (although you should really use CTlib for any new programs...)
>
> Michael
>
>
> > On 26 Jun 2002, Michael Peppler wrote:
> >
> > > On Wed, 2002-06-26 at 16:16, Lucas Rockwell wrote:
> > > > Hi all,
> > > >
> > > > I am wondering how the Sybase password is passed to the server when using
> > > > Sybperl. Is it encrypted somehow or is it in the clear?
> > > >
> > > > For example, with this code, is $pwd encrypted by Sybperl:
> > > >
> > > >     use Sybase::DBlib;
> > > >
> > > >     $dbh = new Sybase::DBlib 'sa', $pwd, $server, 'test_app';
> > >
> > > In general it is not encrypted (AFAIK).
> > >
> > > In CTlib (and possibly in DBlib) you can turn on encryption for the
> > > session:
> > >
> > > my $dbh = new Sybase::CTlib 'webuser', 'webuser', 'troll', 'testapp',
> > >                 {CON_PROPS => { CS_SEC_ENCRYPTION => 1 }};
> > >
> > > There are a few other CS_SEC_XXX properties that are supported - see the
> > > sybperl man page, and the corresponding entries in the Sybase OpenClient
> > > manual.
> > >
> > > Michael
> > > --
> > > Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
> > > mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
> > > ZetaTools: Call perl functions as Sybase stored procedures!
> > >
> >
> >
> --
> Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
> mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
> ZetaTools: Call perl functions as Sybase stored procedures!
>