Hello Chris,
Im still not convinced its the DBD code, since we dont see that behaviour here
with 0.13. I guess there is one other link in the chain, and thats the Sybase
client libraries. Have you investigated that possibility?
IN any case, here is a temporary fix for you. IN AuthSQL.pm,
add a line at about line 287 as shown below:
# Use the default assumption about returned cols:
# first is password, second is check items, third
# is reply items
my $password = shift @row;
# Chris, Add the next line to strip trailing NULs:
$password = s/\000*$//;
On Feb 25, 3:05pm, Chris Hanes wrote:
> Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
> I downloaded version .13 and it does it as well. I'm still not convinced the
NULs
> are coming from the databse. It adds the NUL on every string coming from the
db,
> even in the DBD::Sybase test programs. I've also got packets off the network
and
> the strings being sent over the network do not seem to have NUL terminators.
> Here's a sample packet.
>
> .`g-E).P.\.i..E. 00 60 67 2d 45 29 00 50 8b 5c 02 69 08 00 45 00
> .V..@.€.¼¤...... 00 56 8b c7 40 00 80 06 bc a4 d8 e6 00 16 d8 e6
> .S...2.Z.g·..œP. 00 53 05 99 04 32 05 5a a8 67 b7 8d a7 9c 50 18
> .±$............. 1f b1 24 c9 00 00 04 01 00 2e 00 00 00 00 a0 09
> ..password¡..... 00 08 70 61 73 73 77 6f 72 64 a1 06 00 02 00 09
> .'€..nannie...Á. 00 27 80 d1 06 6e 61 6e 6e 69 65 fd 10 00 c1 00
> ........ 01 00 00 00 00 00 00 00
>
>
> DBD:Sybase interprets this as:
> [root@linux-rad t]# od -c -x r.txt
> 0000000 | n a n n i e \0 | \0
> 6e7c 6e61 696e 0065 007c
> 0000011
> [root@linux-rad t]#
>
> If this triggers anything with anybody, let me know. I'm going to keep
plugging
> away at this.
>
> Thanks,
> Chris
>
> Mike McCauley wrote:
>
> > Hi Chris,
> >
> > On Feb 24, 4:24pm, Chris Hanes wrote:
> > > Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
> > > Hi all,
> > >
> > > Mike has identified the problem as a NUL character being added to the
> > password
> > > coming from the SQLServer. The problem appears to be occuring in the
> > DBD:Sybase
> > > module. I modified some example ct-lib code that came with FreeTDS and
it
> > pulled
> > >
> > > strings from the SQLServer fine - no NUL terminator. I also got
DBD:FreeTDS
> > > working with Radiator - unfortunately it doesn't seem to want to work
with
> > > AuthByRodopi. Anyone else had this problem with DBD:Sybase? It does it
in
> > both
> > > DBD:Sybase version .14 and .21 and it doesn't matter whether I use ct-lib
> > from
> > > FreeTDS or ct-lib from sybase - the NUL character still shows up.
Help!!!
> >
> > We use DBD-Sybase-0.13 without observing that problem. I wonder if the NULs
are
> > actually in the database, and FreeTDS just happens to strip the trailing
NUL
> > for free (I could imagine a C library doing that).
> >
> > Anyone else with thoughts?
> >
> > >
> > > Thanks,
> > > Chris
> > >
> > >
> > >
> > > Mike McCauley wrote:
> > >
> > > > Hello Chris,
> > > >
> > > > In order to get a handle on this, we would need to see your Radiator
log
> > file
> > > > at trace level 4, showing what Radiator is doing with the request, and
why
> > it
> > > > is rejecting it.
> > > >
> > > > Your config file (no secrets) would also be helpful.
> > > >
> > > > Cheers.
> > > >
> > > > On Feb 22, 6:17pm, Chris Hanes wrote:
> > > > > Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
> > > > > Hi all,
> > > > > I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD
Sybase
> > > > > .21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS
> > > > > SQLServer 7.0. After much hassle, I have the network connectivity
to
> > > > > the SQLServer. However, I can't get AuthSQL or AuthRodopi working.
> > > > > Radiator is looking up passwords correctly on the SQLServer and yet
it
> > > > > still fails the auth request. Here's part of my password log file
for
> > > > > an AuthSQL realm.
> > > > >
> > > > > Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL
> > > > > Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL
> > > > > Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL
> > > > > Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL
> > > > >
> > > > > Any help would be GREATLY appreciated.
> > > > >
> > > > > Thanks,
> > > > > Chris Hanes
> > > > >
> > > > >
> > > > > ===
> > > > > Archive at http://www.thesite.com.au/~radiator/
> > > > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > > > 'unsubscribe radiator' in the body of the message.
> > > > >-- End of excerpt from Chris Hanes
> > > >
> > > > --
> > > > Mike McCauley [EMAIL PROTECTED]
> > > > Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
> > > > 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
> > > > Phone +61 3 9598-0985 Fax +61 3 9598-0955
> > > >
> > > > Radiator: the most portable, flexible and configurable RADIUS server
> > > > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > > > Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> > > > NT, Rhapsody
> > > > ===
> > > > Archive at http://www.thesite.com.au/~radiator/
> > > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > > 'unsubscribe radiator' in the body of the message.
> > >
> > >
> > > ===
> > > Archive at http://www.thesite.com.au/~radiator/
> > > To unsubscribe, email '[EMAIL PROTECTED]' with
> > > 'unsubscribe radiator' in the body of the message.
> > >-- End of excerpt from Chris Hanes
> >
> > --
> > Mike McCauley [EMAIL PROTECTED]
> > Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
> > 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
> > Phone +61 3 9598-0985 Fax +61 3 9598-0955
> >
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> > NT, Rhapsody
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Chris Hanes
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, MacOS X
ÿ
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
