FreeTDS Development Group

[carl dotsch <cardosur AT cardosur.com>]

"James K. Lowden" wrote:

> On Tue, 20 Aug 2002 18:35:03 -0400, "Blake Nyquist"
> <blake.nyquist AT voyager.net> wrote:
>
> > 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?
>
> Blake,
>
> Here's one clue, in tds.h:
>
> #define TDS_MAX_LOGIN_STR_SZ 30
> typedef struct tds_login {
>         TDS_CHAR  host_name[TDS_MAX_LOGIN_STR_SZ+1];
>         TDS_CHAR  user_name[TDS_MAX_LOGIN_STR_SZ+1];
>         TDS_CHAR  password[TDS_MAX_LOGIN_STR_SZ+1];
> ...
>
> Probably this and several other "char(30)" choices reflect TDS 5.0 as
> defined by Sybase. I should add that to the list of known issues.
>
> > 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.
>
> The engineering approach would be to spend some time with tcpdump and
> figure out what the protocol does to send passwords greater than 30
> characters.  (It might not be any more complicated than simply sending the
> *whole* password!)  The whattheheck approach would be to change the
> structure definition (in tds.h.in), re-./configure, and see what happens.
> Joy of open source, you heard it here first. ;)
>
> I don't remember this issue coming up before.  There is some interest in
> allowing for tablenames and such >30 characters, but no one working on the
> problem as yet.
>
> > 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)!!!
>
> DBD::Sybase is the way to go.
>
> > Any assistance would be greatly appreciated!
>
> A quick check of the source code suggests you could use any value for the
> length of tds_login.password.  Please set it to whatever MS says the max
> password length is, rebuild, and let us know how you fare.
>
> Be advised that the password cannot include embedded nulls.  That would
> probably trip up perl, and it would definitely not work with FreeTDS.
>
> Regards,
>
> --jkl
>
> ---
> You are currently subscribed to freetds as: [cardosur AT cardosur.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')