RE: Accounting - limits

2011-07-25 Thread Ryan Williams
Hello anonymous! You can write a custom SQL query and include it when authenticating the user to determine if the user has or has not downloaded in excess of 1GB. Assuming of course that you're storing the accounting data in an SQL database. Regards, Ryan Williams - List

Download/Upload Calculation

2011-07-25 Thread radiusus
Hello, I am new to radius server and I need some information if possible. Can anybody help with any documentation regarding the calculation of input/output octets on user/daily basis? I am interested only in reporting and analyzing the traffic of download/upload. I have been trying to use

counter daily

2011-07-25 Thread Angus JIANG Jian
Dear all, Can you give me an example of how to set the cache-size ? This is my config for the counter. counter daily { filename = ${raddbdir}/db.daily key = User-Name count-attribute = Acct-Session-Time reset = daily

Re: Please help me ASAP

2011-07-25 Thread John Dennis
On 07/24/2011 09:29 AM, Its Me wrote: Hi, I am new user in Linux,I have install freeradius2 rpm in my Linux machine(RHEL-5.5 Server),I m facing problem below detail ,please help me how can i install and setup my radiusd -X output below problem. radiusd: Opening IP addresses and Ports

Problem with max-all-session check

2011-07-25 Thread ShR3K
Hello, I installed freeradius with SQL module but when I try to connect it always says : (Check item - counter) is less than zero Rejected user test, check_item=0, counter=1139 I have define the check-name in my counter (Max-All-Session) and I have a line for each user in the database with

Re: Accounting - limits

2011-07-25 Thread Evgeny Yurchenko
Sun, 24 Jul 2011 23:42:19 -0700, Ryan Williams wrote: Hello anonymous! You can write a custom SQL query and include it when authenticating the user to determine if the user has or has not downloaded in excess of 1GB. Assuming of course that you're storing the accounting data in an SQL database.

Re: Accounting - limits

2011-07-25 Thread Rizky Marunda Dinata
for FreeRadius. -- next part -- An HTML attachment was scrubbed... URL: https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110725/2991ff1a/attachment.html -- Message: 6 Date: Mon, 25 Jul 2011 16:29:04 +1000 From: Ryan

MySQL - One RADIUS database per realm

2011-07-25 Thread Dave Thompson
At my place of employment we have a web frontend to our radius server. This frontend will be used by several different clients. We want to store each client's usernames/passwords and MAC addresses in their own database. The database name will be the client's realm name. The reason we want this

Re: MySQL - One RADIUS database per realm

2011-07-25 Thread Danny Stemmet
Hi Dave, I have not tested this, but I will try it as soon as I have a chance.. Create a sql.conf file per client. Be sure to create an instance of type sql per client/realm. eg. client1_sql sql { . lots of configuration parameter (configurable per client, including

Re: MySQL - One RADIUS database per realm

2011-07-25 Thread Dave Thompson
I think that multiple SQL instances are exactly what I'm looking for! Thank you for the information! On Mon, Jul 25, 2011 at 2:54 PM, Danny Stemmet da...@msbmicro.com wrote: Hi Dave, I have not tested this, but I will try it as soon as I have a chance.. Create a sql.conf file per client.

Proxying based on a regex

2011-07-25 Thread Charles Plater
I'm trying to configure our FreeRadius (2.1.9) server to proxy based on the format of the ID. I have a working regex that determines the domain to which the request should be sent, but I'm having a hard time figuring out the syntax of the proxy statement. Here's what I've tried: if (User-Name

RE: Proxying based on a regex

2011-07-25 Thread Sallee, Stephen (Jake)
We did this through our realms see code: In your proxy.conf realm ~.*umhb\\.edu$ { some code here### ###usually the virtual server you want to proxy them to### } If I am understanding your question right that should do it, but others may have a better way .. or I could be on crack ...

View attributes of an connection

2011-07-25 Thread Jean Carlos Oliveira Guandalini
I need to find the value of an attribute created by a module, it is possible? radiusd -X or radiusd -xxx does not show these values. Thanks Jean - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Proxying based on a regex

2011-07-25 Thread Arran Cudbard-Bell
Impressive, you've both made up entirely fictitious syntaxes for doing proxying... Um anyway. if(User-Name =~ /REGEX/){ update control { Proxy-To-Realm := 'my_proxy_realm' } } Then configure the realm in proxy.conf. Subcapture groups can provide you with parts

Re: Proxying based on a regex

2011-07-25 Thread Charles Plater
The desired end result is for the end users to not have to type in the realm. The users would just type in their IDs. We have 2 campuses, and one campus uses a standard license plate format for the IDs - i.e. aa. The other campus uses a first initial followed by the last name i.e. jsmith.

Re: View attributes of an connection

2011-07-25 Thread Arran Cudbard-Bell
On 25 Jul 2011, at 22:24, Jean Carlos Oliveira Guandalini wrote: I need to find the value of an attribute created by a module, it is possible? radiusd -X or radiusd -xxx does not show these values. Sure you just need to expand it somewhere. update request { Tmp-String-0 := %{variable

Re: Proxying based on a regex

2011-07-25 Thread Arran Cudbard-Bell
Sorry only first one is fictitious, second one should work fine :) -Arran On 25 Jul 2011, at 22:33, Arran Cudbard-Bell wrote: Impressive, you've both made up entirely fictitious syntaxes for doing proxying... Um anyway. if(User-Name =~ /REGEX/){ update control {

Re: View attributes of an connection

2011-07-25 Thread Alan DeKok
Jean Carlos Oliveira Guandalini wrote: I need to find the value of an attribute created by a module, it is possible? What does that mean? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: View attributes of an connection

2011-07-25 Thread Arran Cudbard-Bell
Make that: update request { Tmp-String-0 := %{variable I want to expand} } On 25 Jul 2011, at 22:34, Arran Cudbard-Bell wrote: On 25 Jul 2011, at 22:24, Jean Carlos Oliveira Guandalini wrote: I need to find the value of an attribute created by a module, it is possible? radiusd

RE: Proxying based on a regex

2011-07-25 Thread Sallee, Stephen (Jake)
Impressive, you've both made up entirely fictitious syntaxes for doing proxying... Um anyway. Glad you like it : ) I am still new to FR so forgive me if I am mistaken but that little bit of unlang would go into the sites-enabled-default config correct? If so isn't it doing the same thing

Re: Proxying based on a regex

2011-07-25 Thread Arran Cudbard-Bell
On 25 Jul 2011, at 22:49, Sallee, Stephen (Jake) wrote: Impressive, you've both made up entirely fictitious syntaxes for doing proxying... Um anyway. Glad you like it : ) I am still new to FR so forgive me if I am mistaken but that little bit of unlang would go into the

Re: View attributes of an connection

2011-07-25 Thread Jean Carlos Oliveira Guandalini
Thanks Arran, it's works for me. The reason i need this it's because a module is not set an attribute, see the log: Mon Jul 25 18:04:03 2011 : Debug: rlm_backcounter/time-limit: (rlm_backcounter.c#780) backcounter_authorize(): user prepago is over limit - adding 'Monthly-Time-Exceeded' attribute

RE: Proxying based on a regex

2011-07-25 Thread Sallee, Stephen (Jake)
Not quite ... I see, that makes sense. Thanks for taking the time to explain. Jake Sallee Godfather of Bandwidth Network Engineer University of Mary Hardin-Baylor 900 College St. Belton, Texas 76513 Fone: 254-295-4658 Phax: 254-295-4221 From:

Re: Accounting - limits

2011-07-25 Thread Evgeny Yurchenko
Rizky Marunda Dinata Mon, 25 Jul 2011 06:34:04 -0700 Dear Evgeny, Yes, freeradius is able to monitor and limit usage, for example will reject login after 1 GB of sum ( download+upload), please read info about sql-counter (http://wiki.freeradius.org/Rlm_sqlcounter) Thank you very much Rizky

When I am using FreeRadius as Proxy and when a timeout happens this is not been reported back to the application.

2011-07-25 Thread Raja_Kiran
My Setup: Application -- my-FreeRadius-proxy (my rlm_myapp listening on this) --- Home Server listens on RADIUS AccessReq -- recived accessrequest to rlm_myapp decided to proxy -- -- Time out and we expect the timeout to be intimated to the rlm_myapp. Issue: when ever the time out