Re: How to get fractions of seconds?
I see it useful too, when specifying for example "response_window" that instead of be 1 "One second" could be 1200 as in "twelve hundred milliseconds". I have found some devices that time out in 3 seconds , in these cases you still want to retry at least once . Of course here the network delay is kept under 300 milliseconds end to end. From: Alan DeKok To: FreeRadius users mailing list Sent: Wed, February 9, 2011 11:38:11 AM Subject: Re: How to get fractions of seconds? Stefan A. wrote: > Best would be to have something like '%l', but in a resolution of > milliseconds. This is impossible. The dates and elapsed times in RADIUS have a resolution down to one second, but no more. It's possible to "fake" adding milliseconds, but they will bear little relation to the actual session times. Network delays, processing delays, etc. will all affect the results. 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: Use Event-Timestamp for Accounting Start/Stop with MySQL
My 2 cents...
Might not be the best way but for now it works...
in the DDL schema.sql
evttime_utcepstop varchar(30) NULL default NULL
evttime_utcepstop (Would be our column in the Mysql DB to store the
Event-Time-Stamp Attr Radius '55')
I don't need it in the start so I added in the INSERT in the
"accounting_start_query" conf file dialup.conf: but the value is ""
I was more interested in the stop.
So.. In the "accounting_stop_query" I changed the update and included
evttime_utcepstop = '%{Event-Timestamp}' \
Yes it is a string for example "Dec 7 2010 00:14:54 UTC" ( my server locale is
UTC)
then in a very straight forward sql you can do something like:
select unix_timestamp(str_to_date(evttime_utcepstop, "%b %d %Y %T"));
That way you will get back your EPOCH.
I thought in the possibility of convert it before at the time of the update but
I rather to not spend the time in the realtime and instead in the post
processing.
Hope it helps
Ramon
- Original Message
From: Eddie Stassen
To: FreeRadius users mailing list
Sent: Tue, December 21, 2010 2:58:53 PM
Subject: Re: Use Event-Timestamp for Accounting Start/Stop with MySQL
On Tue, Dec 21, 2010 at 3:28 PM, Alan DeKok wrote:
> Eddie Stassen wrote:
>> 2.1.10 allows you to use "{%Event-Timestamp#}" to get date type
>> attributes printed in numeric format. It doesn't seem to be
>> documented, but its in the code.
>
> $ man unlang
>
> It's there.
>
Thanks, I was looking at the web man page at
http://freeradius.org/radiusd/man/unlang.html, which I now notice is
not quite up to date.
> There's enough stuff in the server that I'm starting to forget what it
> can do.
Thats one of the best parts of programming - looking over your old
code and finding all the awesome stuff you did and already forgot
about ;-)
>
> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Looking for an editor for FreeRADIUS documentation
Need to give something back to the Open Source community. So I'd very happy to
contribute with this project.
I have some experience contributing to standard bodies such as WBA which I'm
the Cochair of R&D and authored some of the stage 2 documents in the WiMAX
Forum (GRWG) currently in RiLTE (GSMA) and previously in CDG "Packet group".
Strong development background and FreeRadius' user.
Ramon Castillo
$HOME = GMT + 1
- Original Message
From: Alan DeKok
To: FreeRadius users mailing list
Sent: Tue, May 18, 2010 9:16:06 AM
Subject: Looking for an editor for FreeRADIUS documentation
In the interest of making the project better, we're looking for an
editor for the documentation. The existing documentation is an "ad hoc"
collection of files thrown together over a decade of effort, and written
by many different people.
We'd like to organize the documentation ("doc/" directory), and clean
it up. We're looking for an editor with the following skills:
- willing to do the work
- can write reasonably clearly
- basic knowledge of RADIUS
The goal is to *organize* the documentation, not to write more. The
existing documentation is basic, and could be improved through simple
re-organization.
No knowledge of "git" is required. Familiarity with "restructured
text" would be good. We're looking to move the documentation to that
format.
If it matters, this is a *paid* position. We can't afford a lot, but
we can afford to pay for work done. The rates will be negotiable based
on quantity of work and results.
Please send email to the list if you're interested. We can choose a
candidate, and do the edits publicly, so people see visible progress.
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: duplicate sessions
As a random thought . Aren't these interim accounting messages hence Radius (40) Acct-Status-Type = '3' From: Santiago Balaguer García To: Lista de correo RADIUS Sent: Mon, March 1, 2010 3:53:47 PM Subject: RE: duplicate sessions I think you need to analyse more the accounting request because the MAC and IP address would be different. Check the attributes framedipaddress and calledstationid in Accountig request. Date: Sun, 28 Feb 2010 20:56:16 +0400 From: na...@ultel.net To: freeradius-users@lists.freeradius.org Subject: duplicate sessions Hello All! I have great problems with duplicate sessions! ~2500 online users, accounting per minute, 25 db socket limit for radius daemon. Nas port id, accstoptime, session id, inputoctets, outputoctets is same in duplicate sessions. But most duplicate sessions only have difference with acctstarttime (1 second difference) Any ideas? Thanks! ¡Nuevo MSN Entretenimiento! Todos los trailers, series de tv y videoclips, los mejores juegos online y lo último sobre tus estrellas favoritas.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: WiMAX-Capabilty proxy issue
Great !!! Thanks Alan Ramon From: Alan DeKok To: FreeRadius users mailing list Sent: Fri, November 13, 2009 2:18:38 PM Subject: Re: WiMAX-Capabilty proxy issue Ramon J. Castillo wrote: > I'm having an issue when proxying an access-request message between two > WiMAX networks. > I recently downloaded FR 2.1.8 and I'm in the middle of the messaging path. > The home network is using EAP-TLS but it should be transparent for the > proxy right? > The issue is with the AVP WiMAX-Capability(1) please see below the > packets captured (shown as in WireShark) The fix will be in 2.1.8. See the git "stable" branch for more details. 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
WiMAX-Capabilty proxy issue
Dear all; I'm having an issue when proxying an access-request message between two WiMAX networks. I recently downloaded FR 2.1.8 and I'm in the middle of the messaging path. The home network is using EAP-TLS but it should be transparent for the proxy right? The issue is with the AVP WiMAX-Capability(1) please see below the packets captured (shown as in WireShark) Sending network AVP before FR proxy as arrived: AVP: l=17 t=Vendor-Specific(26) v=WiMAX(24757) VSA: l=11 t=WiMAX-Capability(1) C=0x00: 2 TLV(s) inside TLV: l=5 t=WiMAX-Release(1): 1.4 WiMAX-Release: 1.4 TLV: l=3 t=WiMAX-Accounting-Capabilities(2): No-Accounting(0) WiMAX-Accounting-Capabilities: No-Accounting (0) After proxy from FR to the Home network AVP: l=17 t=Vendor-Specific(26) v=WiMAX(24757) VSA: l=11 t=WiMAX-Capability(1) C=0x00: TLV: l=7 t=WiMAX-Release(1): 1.4\002\005 WiMAX-Release: 1.4\002\005 [Not enough room in packet for TLV header] The home network AAA complains with the error message that can not decode the AVP WiMAX-Capabilty. Any ideas why and what can I do to fix it are very much appreciated Merci Thanks a lot Vielen Dank! Gracias Ramon- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
