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..." Looks like the rlm_sql_log module was not compiled to parse that sintax. What can I do, please (besides create a procedure on the DB to treat that)? Thank you very much. Guilherme Franco
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
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
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-O... (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
participants (3)
-
Alan DeKok -
Guilherme Franco -
Phil Mayers