Solved: Gigawords

[Guilherme Franco]

Hello,

Just to note that oraclesql.conf (in 1.1.7) is wrong about the gigawords.
The syntax for using bitwise operators is different in oracle and for such
needs, you must use the BITAND function and its variants.

But instead of doing bit shifts, I did this to solve it:

AcctInputOctets = '%{Acct-Input-Octets}' + ('%{Acct-Input-Gigawords}' *
4294967296), AcctOutputOctets = '%{Acct-Output-Octets}' +
('%{Acct-Output-Gigawords}' * 4294967296)

Guilherme Franco

On 9/14/07, Guilherme Franco <guilhermefranco at gmail.com> wrote:
>
> Hi Mr. DeKok,
>
> Ok, I've just asked it because of: http://wiki.freeradius.org/index.php/FAQ#Why_do_Acct-Input-Octets_and_Acct-Output-Octets_wrap_at_4_GB.3F
>  (which says that it should work in older versions)
>
> Also, the rlm_sql_log module version is the same in 1.1.7 as in 1.1.4 (v
> 1.3.2.2 2005/12/12).
>
> Thank you.
>
> Guilherme Franco
>
> On 9/14/07, Alan DeKok <aland at deployingradius.com> wrote:
> >
> > Guilherme Franco wrote:
> > > Hello,
> > >
> > > I'm using rlm_sql_log in freeradius 1.1.4.
> > >
> > > In order to correctly work with acct-input/ output gigawords,
> >
> > Upgrade to 1.1.7.
> >
> > Alan DeKok.
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070918/731b1680/attachment.html>