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