Hello Mr. Mayers, I don't think so cause I've copied the very same sintax that can be found in oraclesql.conf of FR 1.1.7. Thank you. Guilherme Franco On 9/14/07, Phil Mayers <p.mayers@imperial.ac.uk> wrote:
On Fri, 2007-09-14 at 00:05 -0300, 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, I've replaced '%{Acct-Input-Octets}' with '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}' in the rlm_sql_log conf, but this results in invalid queries like:
"update radacct set... ...acctiputoctets = 0 << 32 | 98..."
Is that not because you put an invalid query template in?
You need () around the (val << N) bit.
You also almost certain want to do:
(giga << 32) + words
...rather than using bitwise | operator
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html