Re: gigawords how to?
Opps..Sorry I just missed to type a , after outputoctets line.
Problem solved.
Hello, i tried to add gigawords for freeradius 2.0
And added the gigawords lines as i seen on web and final version was like
this..
accounting_update_query = UPDATE ${acct_table1} \
SET FramedIPAddress = '%{Framed-IP-Address}', \
AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', \
AcctInputGigawords = '%{Acct-Input-Gigawords}', \
AcctOutputOctets = '%{Acct-Output-Octets}' \
AcctOutputGigawords='%{Acct-Output-Gigawords}', \
WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}'
But after restarting the freeradius i started to get the following errors.
Couldn't update SQL accounting ALIVE record - You have an error in your
SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'AcctOutputGigawords= '0',
WHERE AcctSessionId = '483bfd520007'' at line 1
So what can be the error?
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
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
Re: Gigawords
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
Re: Gigawords
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 [EMAIL PROTECTED] 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
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 [EMAIL PROTECTED] 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
Steve Cole [EMAIL PROTECTED] wrote: My problem is that Freeradius - even the CVS version - still seems to have no support for the RADIUS extensions for large data transfers (Acct-Input-Gigawords, Acct-Output-Gigawords). Huh? [EMAIL PROTECTED] radiusd]$ grep -i giga share/dictionary ATTRIBUTE Acct-Input-Gigawords52 integer ATTRIBUTE Acct-Output-Gigawords 53 integer Try reading the dictionaries. You've probably installed a new CVS version over top of an old one, and ignored the huge warning messages on make install which said it wasn't updating the dictionary files. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
On Tuesday 06 April 2004 15:07, Alan DeKok wrote: Steve Cole [EMAIL PROTECTED] wrote: My problem is that Freeradius - even the CVS version - still seems to have no support for the RADIUS extensions for large data transfers (Acct-Input-Gigawords, Acct-Output-Gigawords). Huh? [EMAIL PROTECTED] radiusd]$ grep -i giga share/dictionary ATTRIBUTE Acct-Input-Gigawords52 integer ATTRIBUTE Acct-Output-Gigawords 53 integer Try reading the dictionaries. The dictionaries don't concern me, what I need to do is log them. Unless I'm blind, there is no support for Accounting for them in SQL schema: -- start RadAcctId bigint(21) NOT NULL auto_increment, AcctSessionId varchar(32) NOT NULL default '', AcctUniqueId varchar(32) NOT NULL default '', UserName varchar(64) NOT NULL default '', Realm varchar(64) default '', NASIPAddress varchar(15) NOT NULL default '', NASPortId int(12) default NULL, NASPortType varchar(32) default NULL, AcctStartTime datetime NOT NULL default '-00-00 00:00:00', AcctStopTime datetime NOT NULL default '-00-00 00:00:00', AcctSessionTime int(12) default NULL, AcctAuthentic varchar(32) default NULL, ConnectInfo_start varchar(32) default NULL, ConnectInfo_stop varchar(32) default NULL, AcctInputOctets bigint(12) default NULL, AcctOutputOctets bigint(12) default NULL, CalledStationId varchar(50) NOT NULL default '', CallingStationId varchar(50) NOT NULL default '', AcctTerminateCause varchar(32) NOT NULL default '', ServiceType varchar(32) default NULL, FramedProtocol varchar(32) default NULL, FramedIPAddress varchar(15) NOT NULL default '', AcctStartDelay int(12) default NULL, AcctStopDelay int(12) default NULL, - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
Steve Cole [EMAIL PROTECTED] wrote: The dictionaries don't concern me, what I need to do is log them. Unless I'm blind, there is no support for Accounting for them in SQL schema: shrug So add them, and supply a patch to the schema queries. That's why they're in configuration files: so you can edit them. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Gigawords
On Tue, Apr 06, 2004 at 04:31:30PM -0400, Alan DeKok wrote: Steve Cole [EMAIL PROTECTED] wrote: The dictionaries don't concern me, what I need to do is log them. Unless I'm blind, there is no support for Accounting for them in SQL schema: shrug So add them, and supply a patch to the schema queries. That's why they're in configuration files: so you can edit them. PostgreSQL config already has the support. Someone was going to make similar changes for all other drivers IIRC... -- Fduch M. Pravking - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
