More info, appears that it affects numeric items in the database - so I am guessing it is an issue with unixODBC/FreeTDS
I added a debug line, and also modified AuthPLATYPUS to use information from the accttype field (PPP, STATIC, OTHER) and my output log shows: Wed Mar 27 05:21:33 2002: DEBUG: Pass XXXXXXX Act Y Time ^@ Block Y Gua ^@ AT PPP So it gets password, Active, Block, and AT (account type) fine ... But both Time and Guarantor come up as ^@ which if memory serves is the ASCII representation of NULL The odd thing is when I use ISQL included with unixODBC I get the values as expected, argh Steve > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Steve Brown > Sent: Monday, March 25, 2002 5:47 PM > To: [EMAIL PROTECTED] > Subject: (RADIATOR) $timeleft is whacked > > > Okay, so I decided to try AuthBy Platypus and just go with the flow. Any > user without blocktime=N authenticates just fine. But a user with > blocktime=Y always comes back as no time left. > > So, I decided to do some testing. When I start ISQL I run a query by > hand: > > SQL> select password, active, timeleft, blockuser, guarantor from > customer where username='steve_b' > query = select password, active, timeleft, blockuser, guarantor from > customer where username='steve_b' > +-------------------------------------------------+--+--+--+--+ > | | | | | | > +-------------------------------------------------+--+--+--+--+ > | XXXXXXX | Y| 3600| Y| 0| > +-------------------------------------------------+--+--+--+--+ > 1 rows affected > > This looks great. My Blockuser is Y and not G, and I have 3600 minutes > left. > > Next item was a change to Radius/AuthPLATYPUS.pm logging: > > # Apply blockuser time > $self->log($main::LOG_DEBUG, > "User $name has no time left -- $timeleft"); > return undef; > > I added the "-- $timeleft" to the logging. When I actually test radius > and dial in it logs nothing. Well, actually it logs > > 'User steve_b has no time left -- ' > > with no output past the -- > > Any ideas? I should add that I am running ISQL from the same box running > radiator, using the exact same ODBC drivers. > > Steve > > > === > Archive at http://www.open.com.au/archives/radiator/ > Announcements on [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. > === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
