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: David Hajoglou <hojo at i-tel dot com>
Subject: (no subject)
Date: Dec 17 1998 3:34AM

        We actually, after I sent this, thought that since we are using a
secure session that the user name and passwd of the user(one of our
agents) can be referenced into the new sybase::dblib... command.
Do you feel that this is a good method?

David hajoglou

On Wed, 16 Dec 1998, Michael Peppler wrote:

> >>>>> "David" == David Hajoglou  writes:
> David> My question is about the dbsetluser and dbsetlpw functions.
> David> Where would I run these functions so as to avoid putting plain
> David> text user and passwds in the script.
> Actually DBSETLUSER and DBSETLPW aren't implemented in
> Sybase::DBlib. You pass the username and password to the dblogin() or
> new() calls.
> One technique is to store this information in a file that is readable
> only by the user running the script. In this case, assuming the web
> server runs as user 'webuser' you would create a file that is readable
> only by 'webuser' and which has two lines
> the_user
> the_password
> (with appropriate values for these two lines, of course) and then your
> code would do something like
> #!/usr/local/bin/perl -w
> use strict;
> use Sybase::DBlib;
> my @data;
> open(IN, ".the_password_file") || die "ohlala!: $!";
> while() {
>     chomp;
>     push(@data, $_);
> }
> my $dbh = new Sybase::DBlib $data[0], $data[1];
> etc...
> This is of course only one of several ways that this can be
> implemented.
> Michael
> --
> Michael Peppler         -||-  Data Migrations Inc.
>       -||-
> Int. Sybase User Group  -||-
> Sybase on Linux mailing list: