Re: Freeradius2 + MySQL + Accouting

2013-09-17 Thread Arran Cudbard-Bell
On 17 Sep 2013, at 18:41, Wederson Rodrigues weder...@vipvilhena.com.br wrote: Regards, I have a server configured with freeradius2 rlm_mysql and have authentication working well. But the Accouting is only done on start and stop. Wanted it to be done every 5 minutes (300 interim-update

Freeradius2 + MySQL + Accouting

2013-09-17 Thread Wederson Rodrigues
Regards, I have a server configured with freeradius2 rlm_mysql and have authentication working well. But the Accouting is only done on start and stop. Wanted it to be done every 5 minutes (300 interim-update) but is not working. Radtest result: Sending Access-Request of id 250 to 127.0.0.1 port

Re: Freeradius2 + MySQL + Accouting

2013-09-17 Thread Arran Cudbard-Bell
On 17 Sep 2013, at 19:02, Wederson Rodrigues weder...@vipvilhena.com.br wrote: I used radtest just to show the attributes that are returning. I'm using a debian (ppp) as NAS, with the enabled plugins: plugin rp-radius.so pppoe.so radattr.so Even better, RTFS. Arran Cudbard-Bell

Accouting time duratin calculation

2013-06-05 Thread Miha
Hi, how does freeradius calculate duration time? My NAS sends start and stop packet. In mysql table I can see accstarttime and accstoptime. Is the duration time automaticly created from start time and stop time or should NAS also send duration time? In other words is it possbile that

Re: Accouting time duratin calculation

2013-06-05 Thread Russell Mike
Hi, On Wed, Jun 5, 2013 at 7:43 AM, Miha m...@softnet.si wrote: Hi, how does freeradius calculate duration time? MySQL query grabs the information from radacct i.e. sqlcounter forevertimecounter { counter-name = Max-All-Session-Time check-name =

Re: Accouting time duratin calculation

2013-06-05 Thread Fajar A. Nugraha
On Wed, Jun 5, 2013 at 2:43 PM, Miha m...@softnet.si wrote: Hi, how does freeradius calculate duration time? My NAS sends start and stop packet. In mysql table I can see accstarttime and accstoptime. Is the duration time automaticly created from start time and stop time or should NAS also

Re: Need basic help with accouting

2012-01-04 Thread Cosmin Neagu
I found how to do what i needed to do From what i discovered by default it does not do any accounting regarding user logins. I have to set in radiusd.conf in log section: auth = yes By default was set to no On 01/03/2012 04:52 PM, Alan DeKok wrote: Cosmin Neagu wrote: I already learned how

Re: Need basic help with accouting

2012-01-04 Thread Fajar A. Nugraha
On Wed, Jan 4, 2012 at 7:52 PM, Cosmin Neagu cosmin.ne...@omnilogic.ro wrote: I found how to do what i needed to do From what i discovered by default it does not do any accounting regarding user logins. I have to set in radiusd.conf in log section: auth = yes By default was set to no That's

Re: Need basic help with accouting

2012-01-04 Thread Cosmin Neagu
Yes you are right...did some searching on accounting and this is what i want next. Thanks for clarification. Cosmin Neagu On 01/04/2012 03:08 PM, Fajar A. Nugraha wrote: On Wed, Jan 4, 2012 at 7:52 PM, Cosmin Neagucosmin.ne...@omnilogic.ro wrote: I found how to do what i needed to do

Need basic help with accouting

2012-01-03 Thread Cosmin Neagu
Hello radius users, I need some basic info/redirection to start using accounting with freeradius. I already learned how to use authentication, but i'm unable to figure out from details in configurations files how to do some accounting - basic stuff like when a user logs in or out for start.

Re: Need basic help with accouting

2012-01-03 Thread Alan DeKok
Cosmin Neagu wrote: I already learned how to use authentication, but i'm unable to figure out from details in configurations files how to do some accounting - basic stuff like when a user logs in or out for start. Can anyone point me to some documentation on how to do basic accounting for

Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Vincent, Fabien
Dear all, I'm using Radius for authenticating admin users on different network equipments. group authorize {...} works fine with rlm_ldap and group management. But I have some problem for accounting on F5 BigIP LTM / GTM. In fact, my radius accounting server is receiving

Re: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Suman Dash
NAS-IP-Address = *[IP address unknown, not corresponding to NAS interfaces] * Did you added your F5 IP address to NAS Table ? Regards Suman * On Mon, Oct 17, 2011 at 4:56 PM, Vincent, Fabien fabien.vinc...@coreye.frwrote: Dear all, ** ** I’m using Radius for authenticating admin users

RE: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Vincent, Fabien
NAS-IP-Address = [IP address unknown, not corresponding to NAS interfaces] * Did you added your F5 IP address to NAS Table ? Yes I have added the F5 IP address, authorize works fine using the SQL NAS Table, but the IP returned by the F5 Accounting packet isn't a valid Self IPs of the

Re: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Alan DeKok
Vincent, Fabien wrote:\ /Yes I have added the F5 IP address, authorize works fine using the SQL NAS Table, but the IP returned by the F5 Accounting packet isn’t a valid Self IPs of the corresponding F5…/ The NAS-IP-Address attribute can be ANYTHING. It has little or no correspondence to the

Re: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Phil Mayers
On 17/10/11 12:26, Vincent, Fabien wrote: F5-Attr-14 = /[Hexa decimal output starting with 0x …]/ This happens when an unknown attribute is found. The attribute is assumed to be type octets and is rendered at hex. */++ ATTRIBUTE F5-Attr-14 14 octets/* This won't help at all. This is

RE: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Vincent, Fabien
[mailto:freeradius-users-bounces+fabien.vincent=coreye.fr@lists.freeradius.o rg] De la part de Phil Mayers Envoyé : lundi 17 octobre 2011 16:51 À : freeradius-users@lists.freeradius.org Objet : Re: Problem with F5 BigIP accouting : hexadecimal attribute On 17/10/11 12:26, Vincent, Fabien wrote: F5-Attr-14

Re: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Len Conrad
Thanks, but I won't transfer until closer to the expiration date, so please lock it up again. also wanted to make sure somebody was on watch, hadn't been in contact since Don died. Len -- Original Message -- From: Phil Mayers p.may...@imperial.ac.uk

Re: Problem with F5 BigIP accouting : hexadecimal attribute

2011-10-17 Thread Alan Buxey
Hi, add that to the following: VENDOR F5 3375 BEGIN-VENDOR F5 ATTRIBUTE F5-LTM-User-Role 1 integer ATTRIBUTE F5-LTM-User-Role-Universal 2 integer# enable/disable ATTRIBUTE F5-LTM-User-Partition3 string

Re: accouting

2010-05-18 Thread Alan Buxey
Hi, I have installed the following two rpms: freeradius-mysql-2.1.3-1.fc9.i386 and freeradius-postgresql-2.1.3-1.fc9.i386 on my Fedora machine. However, when I tried to configure sql server by using mysqladmin ..., system says command not found. Do I need to install anything else

accouting

2010-05-17 Thread rosect190
I have installed the following two rpms: freeradius-mysql-2.1.3-1.fc9.i386 and freeradius-postgresql-2.1.3-1.fc9.i386 on my Fedora machine. However, when I tried to configure sql server by using mysqladmin ..., system says command not found. Do I need to install anything else (and

Re: accouting

2010-05-17 Thread Larry Brower
rosect...@yahoo.com wrote: I have installed the following two rpms: freeradius-mysql-2.1.3-1.fc9.i386 and freeradius-postgresql-2.1.3-1.fc9.i386 on my Fedora machine. However, when I tried to configure sql server by using mysqladmin ..., system says command not found. Do I need to

Re: accouting

2010-05-17 Thread VU VAN HUNG
Larry Brower wrote: rosect...@yahoo.com wrote: I have installed the following two rpms: freeradius-mysql-2.1.3-1.fc9.i386 and freeradius-postgresql-2.1.3-1.fc9.i386on my Fedora machine. However, when I tried to configure sql server by using mysqladmin ..., system says command not

How to increase the accouting rate sent via Proxy?

2009-09-18 Thread Cristina Miyata
to the home server via Proxy We configured the proxy to use load_factor = 40.~ Is there any other configuration we can change to increase the accouting rate sent via Proxy? Any help appreciated! Thanks in advance. Cristina Miyata - List info/subscribe/unsubscribe? See http

How to send accouting without expecting a response

2009-08-04 Thread Cristina Miyata
Dear FreeRADIUS users, I need to send a copy of all accounting RADIUS our FreeRADIUS receives to another FreeRADIUS that is configured to send no accounting response. How can I configure my proxy RADIUS to not expect for a response for the requests our FreeRADIUS send? Appreciate

Re: Interim Accouting

2009-05-21 Thread Ivan Kalik
May I know the common practise of radius accounting, it is common to expect the radius client to provide interim accounting, ie it sends accounting info every so many seconds interval before the session is closed ? Every so many minutes, not seconds. It doesn't make much sense to have this

Re: Interim Accouting

2009-05-21 Thread Johan Meiring
Ming-Ching Tiew wrote: I just checked Coova chilli, it does it for the clients session based on a configurable interval. But for the administrative account of the NAS itself, it does not do any interim accounting. My coova-chilli DOES send interim accounting -- Johan Meiring Cape PC

Interim Accouting

2009-05-20 Thread Ming-Ching Tiew
May I know the common practise of radius accounting, it is common to expect the radius client to provide interim accounting, ie it sends accounting info every so many seconds interval before the session is closed ? I just checked Coova chilli, it does it for the clients session based on a

Re: Interim Accouting

2009-05-20 Thread Maxim Vinnichenko
Hello Ming-Ching, Thursday, May 21, 2009, 9:38:53 AM, you wrote: May I know the common practise of radius accounting, it is common to expect the radius client to provide interim accounting, ie it sends accounting info every so many seconds interval before the session is closed ? I just

accouting log twice

2008-06-18 Thread Mathieu Lemaitre
Hello, We use freeradius for our clients. Clients have a username with a realm, like [EMAIL PROTECTED] Proxy radius and radius server are on the same machine, and my proxy.conf looks like this: realm domain { type= radius authhost= localhost:1812

Re: accouting log twice

2008-06-18 Thread Ivan Kalik
Upgrade. In 2.0.5 every virtual server has it's own AAA configuration. Ivan Kalik Kalik Informatika ISP Dana 18/6/2008, Mathieu Lemaitre [EMAIL PROTECTED] piše: Hello, We use freeradius for our clients. Clients have a username with a realm, like [EMAIL PROTECTED] Proxy radius and radius

accouting detail

2008-04-17 Thread Guillaume Chartrand
Hi, I'm using freeradius 2.0.3 and I want to make accounting with the detail module. I enable it in the accouting section and the detail module is defined in radiusd.conf Here is the accounting section in site-enabled/default file accounting { # # Create a 'detail'ed log

Re: accouting detail

2008-04-17 Thread Alan DeKok
Guillaume Chartrand wrote: So why he doesn't make accounting. Can it be my AP who's doesn't send accounting packet? For my testing purpose I use a sample D-Link router. Yes. As always, run it in debugging mode to see what it's doing. Alan DeKok. - List info/subscribe/unsubscribe? See

RE: accouting detail

2008-04-17 Thread Guillaume Chartrand
 : Re: accouting detail Guillaume Chartrand wrote: So why he doesn't make accounting. Can it be my AP who's doesn't send accounting packet? For my testing purpose I use a sample D-Link router. Yes. As always, run it in debugging mode to see what it's doing. Alan DeKok. - List info

Re: accouting detail

2008-04-17 Thread Alan DeKok
Guillaume Chartrand wrote: Here is my debug output With authentication packets. These are NOT the same as accounting packets. i.e. What you posted doesn't help. I didn't copy all the debug output because with just one request he made about 1000 lines. If you want all the debug output,

RE: accouting detail

2008-04-17 Thread Ivan Kalik
Lanaudičre Centre administratif, Repentigny (450) 470-0911 poste 7218 -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Alan DeKok Envoyé : 17 avril 2008 10:20 Ŕ : FreeRadius users mailing list Objet : Re: accouting detail Guillaume Chartrand wrote: So why

Triple Play Service Accouting Suggestion

2007-04-13 Thread ram
Hi all iam planning to deploy DSL Services along with Triple play service I would like to use FreeRadius for my test application/ and performance well going to live environment could some suggest me. is this Free Radius can be used for this kind of application if this supports, can some one

Bug on Accouting-Requests proxying

2006-10-27 Thread Geoffroy Arnoud
FreeRADIUS 1.1.3 bug - Accounting requests reemission by FreeRADIUS In file main\request_list.c, function refresh_request. In the case of an accounting request (request-proxy-code == PW_ACCOUNTING_REQUEST), FreeRADIUS adds to the proxied packet the attribute Acct-Delay-Time (or updates it, if

accouting over more than one servers

2006-07-10 Thread Fretz Marco
hello there ive got a problem. we are using 2 radius servers to auth our xDSL users quering from a CISCO PPPoE Router. how can i protect a user to dial in from a secound xdsl line if first radius is down and CISCO AAA useses the 2nd radius server? and btw: does anybody know how to setup up

Re: SQL Accouting

2005-09-28 Thread Paolo Rotela
Message - From: Ben Dowling [EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Tuesday, September 27, 2005 6:00 PM Subject: SQL Accouting Hi, I'm still having problems getting FreeRadius-1.0.4 to log accounting data to sql. I know it is receiving

Re: SQL Accouting

2005-09-28 Thread Ben Dowling
I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined there, and they are correct. The sql connection is working

Re: SQL Accouting

2005-09-28 Thread Paolo Rotela
, 2005 2:30 PM Subject: Re: SQL Accouting I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined

Re: SQL Accouting

2005-09-28 Thread Ben Dowling
PM Subject: Re: SQL Accouting I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined

Re: SQL Accouting

2005-09-28 Thread Paolo Rotela
[EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Wednesday, September 28, 2005 2:30 PM Subject: Re: SQL Accouting I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my

Re: SQL Accouting

2005-09-28 Thread Alan DeKok
Ben Dowling [EMAIL PROTECTED] wrote: I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined

Re: SQL Accouting

2005-09-28 Thread Ben Dowling
PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Wednesday, September 28, 2005 2:30 PM Subject: Re: SQL Accouting I previously mentioned, the accounting section contains just 'sql'. I have no sql section in radiusd.conf though (perhaps

Re: SQL Accouting

2005-09-28 Thread Ben Dowling
in radiusd.conf though (perhaps this is my problem?) and no sql_accouting definitions in my sql.conf, but the sql accouting queries are defined there, and they are correct. Is it getting accounting packets? Run it in debugging mode, and use radclient to send it accounting packets. See

Re: SQL Accouting

2005-09-28 Thread Alan DeKok
Ben Dowling [EMAIL PROTECTED] wrote: Yeah it is getting accounting packets, because I can log them to file with 'detail'. Just not to sql. The debug log should show the SQL module being executed for any accounting packets. If not, there's the problem. If the SQL module is being executed, it

Logging accouting data to SQL

2005-09-15 Thread Ben Dowling
Hi, I am using freeradius 1.0.4. I have enabled the 'sql' module in the accouting section of radiusd.conf but the accouting data is logged to /var/log/radius/radacct and not to mysql. How do I configure this? Cheers, Ben - List info/subscribe/unsubscribe? See http://www.freeradius.org/list

Re: Logging accouting data to SQL

2005-09-15 Thread Alan DeKok
Ben Dowling [EMAIL PROTECTED] wrote: I am using freeradius 1.0.4. I have enabled the 'sql' module in the accouting section of radiusd.conf but the accouting data is logged to /var/log/radius/radacct and not to mysql. How do I configure this? Run the server in debugging mode, send

Accouting Problems

2005-03-30 Thread Sebastian Steinhauer
Hi. I'm working an wireless network for our local city. I'm using freeRadius 1.0.1 on a Debian server and Alchemy 6.0 with ChilliSpot on Linksys accesspoints. Everything's working fine but I've a little problem with the accouting function on freeRadius. Everything (including the radacct

Re: Accouting Problems

2005-03-30 Thread Artur Hecker
an wireless network for our local city. I'm using freeRadius 1.0.1 on a Debian server and Alchemy 6.0 with ChilliSpot on Linksys accesspoints. Everything's working fine but I've a little problem with the accouting function on freeRadius. Everything (including the radacct) is stored in a MySQL database

Re: Accouting Problems

2005-03-30 Thread Alan DeKok
Sebastian Steinhauer [EMAIL PROTECTED] wrote: Now I've following problem. If a user disconnects without loggin off from the system over the CilliSpot Logoff-URL the user will be kept online (AcctStopTime = 0) in the radacct. See the FAQ. The server can only log information if the NAS sends

Re: Can radrelay do realtime accouting?

2004-11-30 Thread Kostas Kalevras
On Tue, 30 Nov 2004, Yyc wrote: hi all, There are servral radius server and one accouting server. if i want to do realtime accouting, what should i do? radrelay can run as deamon? or use crontab to let radrelay run every x mins? radrelay can run as a daemon. But since you only have one

Re: Can radrelay do realtime accouting?

2004-11-30 Thread Yyc
hi, radrelay can run as a daemon. But since you only have one accounting server i don't see a point in using it. radsqlrelay (bug #154) could be helpful in your installation. Must I modify radrelay source code to run it as a deamon? I mean than every radius server record accouting packet

Re: Can radrelay do realtime accouting?

2004-11-30 Thread Kostas Kalevras
that by default (both radrelay and radsqlrelay). I mean than every radius server record accouting packet in detail file, and fw detail to accouting server which write accouting data in database. and this way can reduce loss when any server down . You can either use radrelay: radius-detail-radrelay-radius

Can radrelay do realtime accouting?

2004-11-29 Thread Yyc
hi all, There are servral radius server and one accouting server. if i want to do realtime accouting, what should i do? radrelay can run as deamon? or use crontab to let radrelay run every x mins? Thanks u. Regards Yyc

RE: How do i change the format of Accouting detail file?

2004-11-01 Thread Yyc
to our own DB for accouting. So less attributes are easy for my module to read. You're not going to write another FreeRADIUS module to do that. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http

How do i change the format of Accouting detail file?

2004-10-31 Thread Yyc
hi all, my freeradius-1.0.1 installed under /usr/local/, and acct logfile under /usr/local/var/log/radius/radacct/xx.xx.xx.xx, in logfile format like this Tue Oct 26 11:16:38 2004 User-Name = JohnDoe Acct-Status-Type = Accounting-On Acct-Session-Id = 4496

Can I use radclient to simulate accouting?

2004-10-13 Thread Yyc
Title: Can I use radclient to simulate accouting? hi all, I have no NAS ,but i want to test how to accouting with freeradius. Thanks. Regards. Yyc

Re: Can I use radclient to simulate accouting?

2004-10-13 Thread Thor Spruyt
Can I use radclient to simulate accouting?Yes, just like you do authentication, but specify acct instead of auth :) Run radclient without any parameters: ./radclient -- Regards, Thor Spruyt E: [EMAIL PROTECTED] W: www.thor-spruyt.com M: +32 (0)475 67 22 65 - Original Message - From

re: Can I use radclient to simulate accouting?

2004-10-13 Thread Yyc
:[EMAIL PROTECTED] Thor Spruyt : 20041013 21:52 : [EMAIL PROTECTED] : Re: Can I use radclient to simulate accouting? Can I use radclient to simulate accouting?Yes, just like you do authentication, but specify acct instead of auth :) Run radclient without any parameters: ./radclient -- Regards

Re: Can I use radclient to simulate accouting?

2004-10-13 Thread Thor Spruyt
Yyc wrote: and another question. can i simulate a user who login at 7:00,and logout at 8:00,for example; http://www.thor-spruyt.com/radscenario -- Regards, Thor Spruyt E: [EMAIL PROTECTED] W: www.thor-spruyt.com M: +32 (0)475 67 22 65 - List info/subscribe/unsubscribe? See

Re: Can I use radclient to simulate accouting?

2004-10-13 Thread Dirk Enrique Seiffert - CaribeNet
On Wednesday 13 October 2004 08:46, Yyc wrote: hi all, I have no NAS ,but i want to test how to accouting with freeradius. echo User-Name = test,Password = secret, Acct-Status-Type == Start | radclient -s localhost acct testing123 echo User-Name = test,Password = secret, Acct-Status

Re: Can I use radclient to simulate accouting?

2004-10-13 Thread marek cervenka
On Wednesday 13 October 2004 08:46, Yyc wrote: hi all, I have no NAS ,but i want to test how to accouting with freeradius. echo User-Name = test,Password = secret, Acct-Status-Type == Start | radclient -s localhost acct testing123 echo User-Name = test,Password = secret, Acct

Re: what is the accouting format?

2004-08-09 Thread Thor Spruyt
Yyc wrote: hello, anybody knows? thanks. regards. Read http://www.freeradius.org/list/users.html -- Regards, Thor Spruyt E: [EMAIL PROTECTED] W: www.thor-spruyt.com M: +32 (0)475 67 22 65 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

what is the accouting format?

2004-08-08 Thread Yyc
hello, i m building a radius accounting project and i want to acknowledge what format does the accounting files write. I have install freeradiusMySql under RH 9.0 but i have no NAS device to test accounting. So far as i know,accouting info can be writen in DB,and I got

Re: what is the accouting format?

2004-08-08 Thread Norguhtar
First for testing authenticate use radtest. For testing accountig you can use gnugk openphone ;) --

Re: what is the accouting format?

2004-08-08 Thread Yyc
hello, anybody knows? thanks. regards. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Radius Accouting Functionality Testing

2004-06-14 Thread Hemanth Mysore
Hi All , I am doing Radius Server(Accounting Feature)Testing.. Can anyonetell me what are all the possible testing I can do to conform the RadiusAccouting Functionality , I think Some testing document will be very usefull , Thanking you all in advance , With Regards Hemanth Do you