December 2005 - Freeradius-Users - lists.freeradius.org

Re[2]: HELP - Freeradius+mysql - LOST ACCOUNTING
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi. [ You wrote Thursday, December 15, 2005, 2:14:10 PM ] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SE> Hi, SE> use Acct-Interim-Interval attribute I TRY! and no changes Tell me please in that table i need write this attribute ? SE> ( maybe you will need to change your dictionary file ). yes, i had search this attribute and not foubd in any dictionaty Help me please - in what file of dictionalty i need write it ? SE> This also depends on pppoe which is using radclient - I SE> am not sure if it is supported by your server. I am using Poptop with SE> freeradius and it works. TEll me please what is PopTop ? SE> Regards, SE> Edvin SE> -----Original Message----- SE> From: freeradius-users-bounces(a)lists.freeradius.org SE> [mailto:freeradius-users-bounces@lists.freeradius.org] On Behalf Of Andreas SE> Sokov SE> Sent: Donnerstag, 15. Dezember 2005 11:29 SE> To: freeradius-users(a)lists.freeradius.org SE> Subject: HELP - Freeradius+mysql - LOST ACCOUNTING SE> Importance: High SE> Hi, freeradius-users-bounces. SE> I use pppoe+ppp+freeradius+mysql on Linux Debian. SE> When user connect by pppoe - into radacct table insertes records, where SE> inOctets & out ==0 SE> If session will be 20 hours - data about acct will be updated after session SE> will be close. SE> But if session will be lost - i lost ALL DATA ABOUT TRAFFIC (ACCT) SE> Tel me please - how i can update with interval current traffic for ever SE> connected users ? =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- ------------------------------------- Best Regards, Andreas Thursday, December 15, 2005 2:42:04 PM Web-Media L.t.d. +7 (901) 301-5811 ICQ UIN 177624

1 0

HELP - Freeradius+mysql - LOST ACCOUNTING
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi, freeradius-users-bounces. I use pppoe+ppp+freeradius+mysql on Linux Debian. When user connect by pppoe - into radacct table insertes records, where inOctets & out ==0 If session will be 20 hours - data about acct will be updated after session will be close. But if session will be lost - i lost ALL DATA ABOUT TRAFFIC (ACCT) Tel me please - how i can update with interval current traffic for ever connected users ? -- Best Regards, Andreas Thursday, December 15, 2005 3:22:10 AM "Do not hesitate to ask me" ICQ UIN 177624 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation http://HOST-LUX.RU - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month http://Reg-Master.net - Register`s Master of Domains http://Web-Media.Ru - Web Design studio. http://VEHICLE.RU - автомобили на заказ из США

2 1

how get current TRAFFIC (ACCT) ?
by Andreas Sokov 15 Dec '05

15 Dec '05

Hi, freeradius-users. Linux Debian, # uname -a Linux g48 2.6.14.3-1 #4 Sun Dec 11 05:57:57 MSK 2005 i686 GNU/Linux #freeradius -v freeradius: FreeRADIUS Version 1.0.5, for host , built on Oct 16 2005 at 11:56:56 # mysql -V mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline 5.0 TELL ME PLEASE : HOW I CAN GET CURRENT TRAFFIC INFORMATION ? I need to kno how much traffic user eat before it close your session. Do Know anybody ? I try radwho, radlast - but they show all but acct information Try radacct - but it is not show anything info, just run and no information ... HELP PLEASE. -- Best Regards, Andreas Thursday, December 15, 2005 1:29:42 PM "Do not hesitate to ask me" ICQ UIN 177624 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation http://HOST-LUX.RU - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month http://Reg-Master.net - Register`s Master of Domains http://Web-Media.Ru - Web Design studio. http://VEHICLE.RU - автомобили на заказ из США

2 1

chillispot, apache2, freeradius: my experience and howto
by Christophe Gravier 15 Dec '05

15 Dec '05

Hello, I wrote a little "how to" of what I have done in order to make freeradius working with chilli, regarding my configuration. Because it involves several services (apache ssl, freeradius, ldap, sql, ..) I didn't really find a suitable complete how to for my needs. That's the reason why I wrote mine (in french sorry) but then translated it into english and posted it to ChilliSpot forum (http://www.chillispot.org/forum/viewtopic.php?p=3035#3035) It aims at being exhausted, explaining thing from apache, ssl chilli, freeradius and next ldap (as soon I get it working). As someone told me on the list, I should not forget freeradius wiki ! So, do you think this is valuable ? (it covers not only freeradius in fact) . If yes, where in the wiki is it suitable to propose this ? Regards, Christophe. PS: I sent this mail on chillispot ml as well. -- Christophe Gravier Laboratoire DIOM, groupe SATIn - Doctorant ISTASE - Ingénieur d'études Perso: http://perso.univ-st-etienne.fr/gravchri/ SATIn: http://www.istase.com/satin Tel : 04 7748 5034 A mediter: http://www.fsffrance.org/news/article2005-11-25.fr.html

1 0

A draft of a complete howto of my chilli experience.
by Christophe Gravier 15 Dec '05

15 Dec '05

Hello, I wrote a little "how to" of what I have done in order to make chilli working, regarding my configuration. Because it involves several services (apache ssl, freeradius, ldap, sql, ..) I didn't really find a suitable complete how to for my needs. That's the reason why I wrote mine (in french sorry) but then translated it into english and posted it to ChilliSpot forum (http://www.chillispot.org/forum/viewtopic.php?p=3035#3035) Just feel free to add your comment to get it improved and share your opinion. Regards, Christophe. -- Christophe Gravier Laboratoire DIOM, groupe SATIn - Doctorant ISTASE - Ingénieur d'études Perso: http://perso.univ-st-etienne.fr/gravchri/ SATIn: http://www.istase.com/satin Tel : 04 7748 5034 A mediter: http://www.fsffrance.org/news/article2005-11-25.fr.html

1 0

Flexible clients' addresses?
by Martin Pauly 14 Dec '05

14 Dec '05

Hi, I have some 150 new radius clients waiting at my doorstep. Unfortuantely their IP addresses are _not_ within a single Subnet. Most of them are, however grouped into a bunch of 25 pseudo-subnets of the following kind: client 192.168.<n>.240/28 { secret = somesecret shortname = somename } with n between 0 and 254. Rather than putting 25+ entries of this kind into clients.conf, I am looking for a more flexible way of client specification. I have two ways in mind to approach the problem: Approach 1: Specify a subnet mask with a "hole": client 192.168.0.240/255.255.0.28 { secret = somesecret shortname = somename } describes what I need when interpreted with bitwise netmask semantics. This is currently not supported, but for what reason -- considererd insane or simply not desired by anyone yet? Approach 2 (more general): Store the property of being a radius client in my LDAP database. I found some older postings related to this: On Jan 30, 2005, Alan walters wrote: > > We have free radius working with ldap I have been looking for a way > > to add our clients files o our ldap has anyone had any success with this reply from "Mitchell, Michael J" <Michael.Mitchell(a)team.telstra.com>: > I've actually been looking at this over the weekend. Have written some > code, but haven't tested it yet. I'm hoping to get to that today > sometime. I based it largely on what was done in the sql module, so it > may need a bit of refinement. > > I believe Kostas has it on his todo list also. I'm happy to submit a > "draft patch" for review and comment if it helps get this completed. Has there been any progress on that? I quick look at src/main/client.c has revealed nothing so far. Thanks, Martin -- Dr. Martin Pauly Fax: 49-6421-28-26994 HRZ Univ. Marburg Phone: 49-6421-28-23527 Hans-Meerwein-Str. E-Mail: pauly(a)HRZ.Uni-Marburg.DE D-35032 Marburg

2 1

Forwarding Accounting Requests
by David Bickle 14 Dec '05

14 Dec '05

Hi, I am looking to have FreeRadius forward accounting stop/start packets to a third party device. I understand this can be done by configuring the proxy .conf. The problem has to do with how the accounting requests are forwarded. In other versions of Radius it is possible to forward accounting packets with an attribute setting that ensures the forwarding server doesn't listen for a response. I would like to set this same configuration in FreeRadius but it doesn't appear that this functionality. Is there a way to forward accounting request packets (start/stop) without requiring the forwarding server to listen for responses? Thanks in advance.

1 0

Multiple Home Servers
by maxim maxime 14 Dec '05

14 Dec '05

Hello, I have a 0.9.2 server working as a proxy to three ISPs. Since they've just decided to work together, they still have some dial-up users. Their new users will be generated with a proper prefix, but all of the old users (with no prefix/suffix) will go through NULL realm. Although I can have multiple NULL realms, but only if one server replies with reject, it will not go through other realms (it will fail-over if no answer). How can I tell freeradius to go to next server if the username was not found in the previous home server? It is possible with modules as mentioned in configurable_failover and changing "action on results". How about in proxy? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

LDAP: Variables in "identity" setting
by Derrick Woo 14 Dec '05

14 Dec '05

The LDAP server we have set up is used to authenticate users based on their username and password. If I were to query from the (Linux) command line using ldapsearch, the query would appear as follows: ldapsearch -x -h ldap.domain.com -b ou=ldap,o=domain.com -D uid=XXX,ou=it,o= domain.com -w 'YYY' Where XXX is a person's username and YYY is their password. That means a person can only query their own information and not anyone elses (unless, of course, they have someone else's username and password). >From what I can see, it doesn't appear as though the %{User-Name} variable can be used within the "identity" setting in freeRADIUS 1.0.1. If that's correct, does it mean freeRadius won't be able to be used for this particular set up? If I hardcode a test username and password in the configuration as follows: server = "ldap.domain.com" identity = "uid=XXX,ou=it,o=domain.com" password = 'YYY' basedn = "ou=ldap,o=domain.com" it binds correctly. However, for our particular setup, both the username and password's used to bind to the server need to be variable at run time.

2 5

bandwidth per user (pppoe)
by TwoMan 14 Dec '05

14 Dec '05

Hi All, I have successfully set up freeradius with mysql backend, rp-pppoe concentrator, and pppd. Bandwidth control also working, but every pppd connection have the same bandwidth, because I cannot determine which user has benn connected. I use the ppp/ip-up script to control the bandwidth. The desired bandwidth is in the mysql database too, for each user. Could You help me find a way how to use different badwidth to each user? thx in advance TM

3 4