FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il lun, 2003-07-21 alle 17:20, Lowden, James K ha scritto:
> > From: Matias Braun [mailto:cpd AT gramadosite.com.br]
> > Sent: July 21, 2003 10:40 AM
> >
> > in tds v. 5.0 the password length is "CHAR[30]", but i use a 
> > password with char[128] with sybase sql anywhere 5.5 in isql. 
> > Then i changed in source code the length of the password to 
> > 128 "TDS_MAX_LOGIN_STR_SZ 128"(tds.h), but ins't 
> > working, my freetds.log shows that my password continues 
> > whith char[30]. Is this a protocol limit?
> 
> Matias,  
> 
> Sybase servers use TDS 5.0.  The login packet for TDS 5.0 provides up to 30
> bytes for the password.  Cf. http://www.freetds.org/tds.html.  AFAIK, the
> 30-byte limit is a fixed property of the protocol.  
> 
> If you're willing and able to use tcpdump(8) to capture a login packet with
> a password longer than 30 bytes, I'm sure folks here would be interested to
> see it.  
> 
> Could it be perhaps that isql lets you enter a longer password but ignores
> the characters beyond 30?  
> 

It's not easy and not well documented. Instead of filling password in
login packet you leave the field empty, set an appropriate field and use
some other tokens (packet??) to pass the password (that can be crypted
too). Some explanation in Sybase TDS specs but not very detailed. If
anyone can do some network capture I think someone will be glad to code
it...

freddy77