information from radiusd -X mode regarding this issue is :
[sql] expand: %{User-Name} - snan4love
[sql] sql_set_user escaped user -- 'snan4love'
[sql] expand: %{Acct-Input-Gigawords} -
[sql] ... expanding second conditional
[sql] expand: %{Acct-Input-Octets} -
[sql] ... expanding second
snan4love wrote:
But my problem is :
No matter how long i stay in the connection, the AcctInputOctets and
AcctOutPutOctets are always 0;
Blame the NAS.
the debug information from radiusd -X mode regarding this issue is :
Deleting the majority of the debug output is a bad idea. If you
in the connection, the AcctInputOctets and
AcctOutPutOctets are always 0;
the debug information from radiusd -X mode regarding this issue is :
[sql] expand: %{User-Name} - snan4love
[sql] sql_set_user escaped user -- 'snan4love'
[sql] expand: %{Acct-Input-Gigawords} -
[sql] ... expanding second conditional
On 27 Sep 2011, at 09:52, snan4love wrote:
Hello Everybody:
Thanks for opening this topic.
We didn't open it you did. :)
Right now,I have set up the FreeRadius+Mysql+Wifi system, I could get into
the internet via this system on my laptop.
But my problem is :
No matter how long i stay in
Also... Whilst it is a very pretty signature Mr Chapellon I direct you to the
rules of the FreeRADIUS users list...
http://freeradius.org/list/users.html
The Second rule of the FreeRADIUS users list - 'No HTML on the list'
The Third rule of the FreeRADIUS users list - 'No vcards'
-Arran
Arran
/log/radius/radutmp
[radutmp] expand: %{User-Name} - snan4love
++[radutmp] returns ok
[sql] expand: %{User-Name} - snan4love
[sql] sql_set_user escaped user -- 'snan4love'
[sql] expand: %{Acct-Input-Gigawords} -
[sql] ... expanding second conditional
[sql] expand: %{Acct-Input-Octets
On 27 Sep 2011, at 10:47, snan4love wrote:
Yes,I checked the entire debug output, there is no attribute about the
Acct-Input-Octets in the accounting-Request packet.
And here is my stupid question again:
How to add it?
By configuring the NAS to send it... Or by getting a new NAS. The
On 27 Sep 2011, at 10:52, Arran Cudbard-Bell wrote:
On 27 Sep 2011, at 10:47, snan4love wrote:
Yes,I checked the entire debug output, there is no attribute about the
Acct-Input-Octets in the accounting-Request packet.
And here is my stupid question again:
How to add it?
By
snan4love wrote:
Yes,I checked the entire debug output, there is no attribute about the
Acct-Input-Octets in the accounting-Request packet.
And here is my stupid question again:
How to add it?
http://wiki.freeradius.org/FAQ#How+do+I+enable+FreeRADIUS+to+log+accounting+attribute+type+X%3F
Event-Timestamp = Jan 1 2000 14:15:58 CST
Acct-Terminate-Cause = User-Request
Acct-Unique-Session-Id = 02a52d5fc2ac00e6
Timestamp = 1316677162
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Problem-expand-Acct-Input-Gigawords-always-get
On 27 Sep 2011, at 11:09, snan4love wrote:
Hello Arran:
Here is a stop request at the bottom of that debug information.
And something more confusing,
I used the user name snan4love log in my system for hundreds time, there
is only one time, I get the currect response with
Le 27/09/2011 10:21, Arran Cudbard-Bell a écrit :
Also... Whilst it is a very pretty signature Mr Chapellon I direct you
to the rules of the FreeRADIUS users list...
http://freeradius.org/list/users.html
The Second rule of the FreeRADIUS users list - 'No HTML on the list'
The Third rule of
when he reaches a session of 4GB.
As general datatraffic increases we would like to avoid this in our
new radius setup.
In the newest version, is there a way to reply gigawords from sqlcounter?
If not, is there another solution to this?
The latest version has rlm_expr, which is 64-bit clean
On Fri, Apr 1, 2011 at 10:40 AM, Alan DeKok al...@deployingradius.com wrote:
The latest version has rlm_expr, which is 64-bit clean. You can use
it to split the counters into 32-bit pieces.
Alan DeKok.
Tnx Alan, will check it out.
-
List info/subscribe/unsubscribe? See
a session of 4GB.
As general datatraffic increases we would like to avoid this in our
new radius setup.
In the newest version, is there a way to reply gigawords from sqlcounter?
If not, is there another solution to this?
Many thx.
Yves
-
List info/subscribe/unsubscribe? See http
RFC2869 says that Input and Output gigaword shoud be sent from NAS to
radius
server.
Now new versions of freeradius support gigaword. Should NAS supports
gigaword?
Some do, some don't. Most don't have it enabled by default. You will have
to look into NAS documentation to find out.
Ivan
Hi,
RFC2869 says that Input and Output gigaword shoud be sent from NAS to radius
server.
Now new versions of freeradius support gigaword. Should NAS supports
gigaword?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
i'm new here and i need your help in the following 2 points.
Point 1: Acct-Input/Output-Gigawords
Point 2: Bandwithlimit with PPP and PPPoE
My system: debian with kernel 2.6.8-2-386, Roaring Penguin PPPoE Version
3.10, PPP 2.4.4 (not quit sure) and MySQL 4.1.10a.
Point 1) After I
So... get the NAS to send it. Or buy a NAS that semds it.
I hoped that one of you can give me a hint on how.
See the NAS documentation for instructions on using RADIUS to limit
bandwidth.
I wrote the version and the kind of NAS before, so I hoped it could be true
that one of all the guys
Lars wrote:
So... get the NAS to send it. Or buy a NAS that semds it.
I hoped that one of you can give me a hint on how.
Google? It's been around for a while now.
See the NAS documentation for instructions on using RADIUS to limit
bandwidth.
I wrote the version and the kind of NAS
I wrote the version and the kind of NAS before, so I hoped it could be true
that one of all the guys here did it before with the same configuration.
The documentation of the NAS is not detailed enough to get the needed
information!
Did you look at the vendors dictionary (if there is one included
Hi,
i have 2 questions and i hope you'll help me.
I use the freeradius in combination with mysql-server for accounting and
authorizing.
The first:
how do i use the Acct-Input-Gigawords and Acct-Output-Gigawords Attributes
with FreeRADIUS Version 1.1.3 and FreeRADIUS Version 1.0.2 and PPP
2.4.4
how do i use the Acct-Input-Gigawords and Acct-Output-Gigawords Attributes
with FreeRADIUS Version 1.1.3 and FreeRADIUS Version 1.0.2 and PPP
2.4.4? I set up the fields in the mysql-table but they do not get filled
with data.
Those will be filled when the connection goes over the limit
Hi,
I set up the fields in the mysql-table but they do not get filled with data.
http://wiki.freeradius.org/FAQ#Why_do_Acct-Input-Octets_and_Acct-Output-Octets_wrap_at_4_GB.3F
(you need to modify the SQL queries as well, updating the database
schema alone isn't enough)
Greetings,
Stefan
Is there a way (radius or ppp) to get the Accounting-Data on-the-fly
(realtime) or maybe all 2 hours without disconnection the actual session
of
the user?
Depending on your NAS, you can send Accounting updates every 5 minutes !
The
attribute that NAS has to accept is called Acct-Interim-Interval.
Where can i set it up? I use rp-pppoe-server and ppp 2.4.4 on debian
That attribute should be replied by the server in access-accept RADIUS
packet. You can define it for each user in your user DB ( SQL, LDAP ) and
freeradius should be able to add it to the above mentioned packet.
Regards,
E:S
-
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
Hi list,
I'm having trouble identifying the Acct-Input-Gigawords field in the
shell environment of Exec-Program.
Does anyone know how to ensure that it is being exported?
I have a shell script (test-exec.sh) which according to examples in docs
goes like so:
#!/bin/sh
/usr/bin/printenv /tmp
Rob Hartzenberg wrote:
I'm having trouble identifying the Acct-Input-Gigawords field in the
shell environment of Exec-Program.
Does anyone know how to ensure that it is being exported?
Read the output of debugging mode. If it's in the packet, it will be
exported to any shell program. See
. If you see any
other issues, please let me know and I will fix them
Regards
Peter
On Tue 18 Sep 2007, Guilherme Franco wrote:
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
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
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
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
).
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
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
Daniel [EMAIL PROTECTED] wrote:
I have tried:
AcctInputOctets = '%{Acct-Input-Octets}+(%{Acct-Input-Gigawords}*4294967296)'
Doesn't seem to work. Any pointing in the right direction would br greatly
appreciated.
Does MySQL have 64-bit support for fields?
Alan DeKok.
-
List info
Alan DeKok wrote:
Does MySQL have 64-bit support for fields?
If you need to store it as a number (ie do math on it within MySQL), it
can handle up to 63 bits (which may be enough for this purpose - you
have some big problems if users are transferring over 9.2 Exabytes of
data in 1 session).
-Gigawords and
Acct-Output-Gigawords in to account. We are receiving them from our
suppliers. We need this because these days we are seeing very long session
times for ADSL links and high speed. We can record up to the 4gig mark.
I have tried:
AcctInputOctets = '%{Acct-Input-Octets}+(%{Acct-Input
It appears that Acct-Output-Gigawords and Acct-Input-Gigawords still don't
exist in MySQL and other drivers in Freeradius. Is this accurate?
Has anyone got any recommendations for a radius server that supports these
without using PostgresSQL (very difficult for me at present)? Really
On Feb 1, 2005, at 2:08 PM, Steve Cole wrote:
It appears that Acct-Output-Gigawords and Acct-Input-Gigawords still
don't
exist in MySQL and other drivers in Freeradius. Is this accurate?
Has anyone got any recommendations for a radius server that supports
these
without using PostgresSQL (very
What version of FreeRADIUS are you using? I was under the impression
that I had committed this fix several months ago, so it _ought_ to be
in the 1.0.0 release.
using 1.0.0-pre2 built on Jun 15 2004 from the src/debian
Does this mean it's fixed somewhere in the freeradius code so
On Thu, Aug 26, 2004 at 10:58:06AM +0200, Michael Markstaller wrote:
What version of FreeRADIUS are you using? I was under the impression
that I had committed this fix several months ago, so it _ought_ to be
in the 1.0.0 release.
using 1.0.0-pre2 built on Jun 15 2004 from the src/debian
[EMAIL PROTECTED] (Paul Hampson) wrote:
I guess I didn't after all. Drat. Now it's a 1.1.0 thing, unless some
one wants to make a case that it's a grave bug in 1.0.0...?
No. We can come out with 1.1.0 in a month or so.
... once I fix the annoying libltdl nonsense.
Alan DeKok.
-
List
On Mon, Aug 23, 2004 at 06:17:31PM +0200, Michael Markstaller wrote:
Anyway, what I've changed in my sql.conf (using mysql, other my differ using
POW(2,32)=4294967296) replace:
'%{Acct-Input-Octets}' with '%{Acct-Input-Octets} + (%{Acct-Input-Gigawords:-0} *
POW(2,32))'
'%{Acct-Output
I was last on this list in Dec. 2002 asking about Gigawords accounting with a
Cisco 7200 VXR. I have finally updated the Cisco IOS (with the help of a
Cisco engineer, it wasn't straightforward) and now am looking at Freeradius
again.
My problem is that Freeradius - even the CVS version
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
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
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
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
49 matches
Mail list logo