(RADIATOR) $timeleft is whacked

[Steve Brown]

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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]On
> Behalf Of Steve Brown
> Sent: Monday, March 25, 2002 5:47 PM
> To: radiator at open.com.au
> 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.