(RADIATOR) question

[Hugh Irvine]

Hello Chris -

You should test your SQL statements by hand with your database tools 
first before putting them in the configuration file.

regards

Hugh


On Monday, Jul 21, 2003, at 20:10 Australia/Melbourne, Chris Garzon 
wrote:

> Hi,
>
> I've set up my AcctSQLStatement to look like this:
>
> AcctSQLStatement update RADUSERS set
> TIMELEFT=TIMELEFT-0%{Acct-Session-Time}, 
> OCTETSINLEFT=OCTETSINLEFT-0%{Ac \
> ct-Input-Octets}, OCTETSOUTLEFT=OCTETSOUTLEFT-0%{Acct-Output-Octets} 
> where
> USERNAME='%n'
>
> AcctSQLStatement update RADUSERS set VALIDFROM=now where VALIDFROM IS 
> NULL
>
> now the second statement returns this error in the logfile:
>
> Mon Jul 21 18:02:49 2003: ERR: do failed for 'update RADUSERS set
> VALIDFROM=now where VALIDFROM=NULL': Unknown column 'now' in 'field 
> list'
>
>
> -chris
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.502 / Virus Database: 300 - Release Date: 7/18/2003
>
> This Email is protected by RAV AntiVirus Security Software for SuSE 
> Linux eMail Server
>
> ===
> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
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.