(RADIATOR) radius crash

[Hugh Irvine]

Hello Eapen -

The problem you have is due to several things.

First of all, your configuration file should be changed slightly to deal with 
possibly missing attributes that are used in the calculation refered to in 
the error message.

This part of the SQL statement should be changed:

	.... balancetime=balancetime-%{Acct-Session-Time} .....

should be something like this:

	balancetime=balancetime-0%{Acct-Session-Time} ....

as it is the missing value that is causing the crash.

Secondly there have been some improvements in later versions of Radiator to 
deal with the method "quote" error (this will go away if the above is fixed 
in any case).

The latest version is Radiator 2.19.

regards

Hugh

>
> Hi,
> our radiator radius was working perfectly, when suddenly it started
> crashing.
> when we checked the logs we found that,when a particular query as
> mentioned below is excecuted, the crash occurs.
>
> Wed Jan  9 23:26:19 2002: ERR: do failed for 'update amcard set
> balancetime=balancetime- where username='96340961'': You have an err
> or in your SQL syntax near 'where username='96340961'' at line 1
>
>
> pls note the double quotes (") at the end of the username.
> we find that each time the crash occurs, this SQL statement is
> there,ofcourse the usernames will be different.
>
> The other error that showed in the terminal was:
> cant call method "quote" on an undefined value at
> /usr/local/lib/perl5/site_perl/5.005/Radius/AuthSQL.pm  line 363
>
> This file was not at all changed or modified.
>
> Waiting your valuable respones
>
> Regards
> eapen
>
> -------------------------------------------------------

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.