Re: Problem using Freeradius with Oracle

[Alan DeKok <aland@deployingradius.com>]

Mother wrote:
...
> Now, Acc[input/output]Octets as I see in oraclesql.conf is derived like
> this:
> 
> AcctInputOctets = '%{%{Acct-Input-Gigawords}:-0}'  << 32 |
> '%{%{Acct-Input-Octets}:-0}'
> 
> So it seems (AFAIK) that it's attempting to bit-shift the Gigawords and
> Octets received from the NAS.
> 
> My problem is that if this syntax is used, Oracle complains with
> 'ORA-00933: SQL command not properly ended'.

  See the Oracle documentation for how to do bit-shifting, and how to
use 64-bit numbers.

  Alan DeKok.