Skip to Content.
Sympa Menu

freetds - Re: long password issues

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: carl dotsch <cardosur AT cardosur.com>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: long password issues
  • Date: Thu, 22 Aug 2002 01:11:24 +0200




carl dotsch wrote:

> Blake Nyquist wrote:
>
> > Hello, all. First off, I wanted to commend all the developers and
> > contributors to the FreeTDS project! It has come in extremely handy for us
> > as we recently inherited responsibility for numerous M$ SQL Server
> > databases even though our group specializes in Linux-based systems.
> >
> > We have been using FreeTDS through Perl's DBD::Sybase module, but maybe
> > the
> > current problem will change that for us.... Due to unique security
> > requirements for some of our database logins, we are trying to use an MD5
> > encrypted password as the actual DB password. Since using MD5
> > automatically
> > forces any plain-text password to 32 characters, it appears this is
> > causing
> > problems with logins.
> >
> > After some poking around, we believe there is a limitation on sending a
> > password greater than 27 characters in length. Does anyone know if this is
> > a limitation on FreeTDS's part, DBD::Sybase's part, or some other piece of
> > the puzzle? Are there any known solutions or work-arounds? The
> > 32-character
> > password can be used through M$'s query analyzer tool just fine, so the
> > database itself doesn't seem to have any problems with the longer
> > password.
> >
> > I was wondering if Perl's DBD::ODBC module would fix the problem, but I
> > haven't had luck in successfully installing that module with FreeTDS. If
> > anyone has a thorough how-to for getting that setup correctly, that would
> > also be a huge help (even if it doesn't fix this problem)!!!
> >
> > Our existing setup is on a Red Hat Linux box with Perl 5.6, the latest
> > version of DBD::Sybase and about a 2-month-old snapshot of FreeTDS. Other
> > than, staying on Linux and using Perl there are no requirements for what
> > means we use to make this work. Any assistance would be greatly
> > appreciated!
> >
> > Thanks in advance!
> >
> > cheers,
> > Blake Nyquist
> >
> > __________________
> > Blake Nyquist
> > blake.nyquist AT voyager.net
> >
> > ---
> > You are currently subscribed to freetds as: [cardosur AT cardosur.com]
> > To unsubscribe, forward this message to $subst('Email.Unsub')
>
> ---
> You are currently subscribed to freetds as: [cardosur AT cardosur.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page