Re: Statistics tool?
[EMAIL PROTECTED] wrote: such a value would be nice as an SNMP'able 64bit counter? Does anyone know of any system that could be used to remotely monitor if a radius server is up? Similar to the uptime testing tools that are available for DNS and http. Chatted to my current monitoring provider and it would probably involve building a custom script for their system. Something along the lines of radtest and then you would add a nasclient line for each testing location and dummy users entry that can be queried by the test location. -- Graham Beneke Apolix Internet Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: online users
You need to be querying to radacct table - that is where you would find information on sessions. radcheck is generally only the static data regarding the users on your system. regards Graham Beneke Mordor Networks wrote: hi ivan thank you for your reply it tried this : $requet = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; $login_users = $requet and $login_users = SELECT COUNT(*) FROM radcheck WHERE AcctStopTime=0; still 0 , what im doing wrong? - 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: Where to find sql counter module ?
YvesDM wrote: On 2/24/07, *PD* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Simple questions... how and where to get sql counter module ? I try to googling for hours but still can not find it. TIA PD You should compile FR with experimental modules You have to create the module yourself Read rlm_sqlcounter in the doc/ folder . It's explained how to use this. In the current version of FR (1.1.4) the sqlcounter module is no longer experimental - comes as in the default collection of modules. There is also a wiki article on using sqlcounter: http://wiki.freeradius.org/Rlm_sqlcounter Its not complete but I am working on it. -- Graham Beneke - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Where to find sql counter module ?
YvesDM wrote: rlm_sqlcounter: No such attribute ChilliSpot-Max-Total-Octets obelix:/etc/freeradius# Strange... But I'm not in a rush, I'll find out what's wrong :-) Looks like a dictionary problem to me - Chillispot's dictionary is not yet part of FR you have to add it manually. Maybe someone with a little spare time can throw together the Chillispot dictionary as a patch ;-) Graham Beneke - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Assign static ip based on MAC
N S wrote: Currently chillispot is handing out ip addresses and FreeRadius ippool module is commented ( not using it) If you are using web based login then chillispot hands out its DHCP leases before it does its radius authentication. (The radius authentication only happens after the user has entered a username and password in the login page.) In order to give out fixed IP addresses you have to set chillispot to do MAC-Auth which will query the radius server with the MAC address as the username. This causes it to do a radius request when the device initially connects. You then must include a 'Framed-IP-Address' attribute in your radius reply. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Best practices for redundant servers
Nicolas Baradakis wrote: Graham Beneke wrote: Does anyone remember where there is doccumentation on this? radsqlrelay and rlm_sql_log have a manpage. Would it be possible for someone to dump all the man pages into the wiki? It may not be the preferred source of information but I find the wiki to be a lot more useful than the man pages. Reason being that I currently have to connect to the radius server i'm working though a horribly latent wireless connection and scrolling through man pages with a 700ms delay is really painful. At least the wiki pages I can load into my browser and read at my leisure without having to worry about the server connection. :-) regards Graham Beneke - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Best practices for redundant servers
Dennis Skinner wrote: For serious billable accounting you probably want to write to files and then import them into the db (there is a module to help with this). Radius will happily skip queries that take too long or if there are not enough mysql connections available on the accounting side. I remember reading about 'radsqlrelay' that does essentially this. It is also mentioned once in radiusd.conf but subsequent searching has brought up nothing worthwhile. Does anyone remember where there is doccumentation on this? regards Graham Beneke - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Prefixing Topics with Mailing list name
Hi Guys Something thats been bugging me about this list for a while is the fact that the post subjects have no indication which mailing list they are from. All the other mailing lists I'm on prefix subjects with something like [freeradius] but since this list (as well as freeradius-devel) don't do this it makes it quite difficult to figure out what is going on in my inbox. Could we get this changed? regards -- Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cell: 082-432-1873 callto://+27824321873 Skype: grbeneke callto://grbeneke WEB: www.apolix.co.za http://www.apolix.co.za/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Rewriting reply attributes
Alan DeKok wrote: You may be able to create a new attribute with the value of the old one, and then delete the old one. Hi Alan Thank you for the response. I'm still trying to come to grips with the some of the general concepts and program flows within freeradius. If you can point me to any good docs explaining this it would be great. That said - what modules or sections of the conf file should I be looking at to achieve your suggestion? -- Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cell: 082-432-1873 callto://+27824321873 Skype: grbeneke callto://grbeneke WEB: www.apolix.co.za http://www.apolix.co.za/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Rewriting reply attributes
Hi guys Is there any way (in some post processing module perhaps) to rewrite the name of a reply attribute without changing the value. One of the modules that I am using has the reply attribute 'hardwired' but it is returning the exact attribute value that I require. The more elegant solution would be to make the module more customisable - which is something I plan to pursue on the devel list shortly. But it would be really good if I can find a stop gap solution in the mean time. -- Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cell: 082-432-1873 callto://+27824321873 Skype: grbeneke callto://grbeneke WEB: www.apolix.co.za http://www.apolix.co.za/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
radcheck vs radreply
I seem to have a conceptual misunderstanding of the radcheck and radreply tables - and all my googling has given me nothing solid to correct myself on. Can someone explain the difference of the 2 and what their purpose in the system is. My understanding it the radcheck is used to decide whether a user should have access to the NAS and values are then sent back from the results of these checks... The radreply is then simply a list of properties/configuration attributes that are returned to the NAS is that specific user is authorised. My confusion comes - though - due to the fact that when running a radtest on my server none of the radcheck attributes are being returned and the users are being allowed to do more than they should be as a result. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Write access to the wiki
Peter Nixon wrote: No, actually you cant. I disabled new user creation as a all the spam bots appeared to be smart enough to create new users then use them for spamming. Anyone who wants a wiki account please mail me directly with the username you would like and I will happily create you an account. Cheers Fair enough - you've got mail :-) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Write access to the wiki
Is access to the wiki exclusive?? I wanted to start working on a sqlcounter page since the current documentation is rather lacking and I plan to 'journal' my exploits in figuring it out... But I can't seem to find the register link that is referred to. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: sqlcounter
Guy Fraser wrote: There is also some documentation in the config file. Most of that is specifically related to sqlcounter for time based billing I believe this has been discussed many times and there should be some information in the archives. Have you Googled for it? I have indeed - and everything I have come up with has been questions... with no answers. From the mailing list archives as well. Once you figure it out, maybe you wouldn't mind contributing some better documentation for rlm_sqlcounter to the project. I am sure future implementers would appreciate it. I figured last night that I should probably do this in the end - think I'm gonna have to sit with the source and figure out the solution myself. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: sqlcounter
K. Hoercher wrote: On 8/29/06, Fabiano Martins [EMAIL PROTECTED] wrote: I've benn searching with no sucess about this... It's frustrating... there is no documents about. Perhaps the looking into the very obscure doc/rlm_sqlcounter file helps, although it' not DOC for some strange reason. I've also looked at that document and it has not got me any closer to knowing what is going on. It gives examples of how to use sqlcounter for time based billing - but it does not explain what the different elements of the sqlcounter are - or how they work. I am wanting to build an octets based billing system using some custom dictionary items from the Chillispot NAS - but I can't find info anywhere. Although I have heard that it has been successfully been implemented. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Missing Attributes
Alan DeKok wrote: Graham Beneke [EMAIL PROTECTED] wrote: Add it... where? The chillispot daemon is not locking the user out once their transfer limit has been reached... Huh? You said you added the dictionary, and I asked where. Your answer makes no sense, other than as a statement unrelated to my question. sorry - missunderstood the question... was refering to 'it' from the origonal text... I added the dictionary file in the /etc/freeradius/ directory and then added a $include into 'dictionary' Also tried 'cut-n-pasting' the contents of the additional dictionary to 'dictionary' and that also made no differnence. Did you tell the server to send the attributes in the reply? Ok so how do i go about doing that? See the users file. Correct me if I am wrong - but 'users' is not parsed when i'm using a MySQL backend? Pretty sure I disabled it in my setup. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Missing Attributes
K. Hoercher wrote: Well, yes. But you have to put the equivalent in the pertinent tables, wherefore you should contemplate the information contained in the default users file. Actually, Alan didn't say you have to use it. *g* The radcheck table is populated automatically by the php script - and it includes a ChilliSpot-Max-Output-Octets attribute. This matches one of the attributes added in the dictionary so i'm not sure what to check next... - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Missing Attributes
I have FreeRadius 1.1 installed on a Ubuntu 6.06 Server Edition. I have integrated it with MySQL and a PHP admin application called phpMyPrepaid It is serving requests for a ChilliSpot daemon at my hotspot. I've added the additional Chillispot dictionary that has attributes for data volume limiting - but it does not appear to be working. I did a test radius request from a little win app called RadiusTest and it appears that the custom attributes are not been sent in the rad-reply packet by the radius server... As this is my first experience with radius - i have no idea where to start looking for where the problem may be. regards Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WEB: www.apolix.co.za http://www.apolix.co.za/ Cell: 082-432-1873 skype:+27824321873?call Skype: grbeneke skype:grbeneke?call - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Distro with FreeRadius 1.1
Hi All I'm trying to setup a FreeRadius 1.1.x - MySQL - phpMyPrepaid system. I'm looking for a distro that can get me there with the least path of resistance... I've currently got a dedicated box running FC4 and FreeRadius 0.9.x and I've been fumbling around for 2 weeks now and not getting anywhere. I found an RPM for ver 1.1.x and tried to install it but the system was unable to resolve a whole stack of dependencies. Tried to install from source and I got attacked by pages and pages of warnings and errors that i don't have a clue how to resolve... Thanks -- Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WEB: www.apolix.co.za http://www.apolix.co.za/ Cell: 082-432-1873 skype:+27824321873?call Skype: grbeneke skype:grbeneke?call - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Distro with FreeRadius 1.1
Thanks for the input guys - but it appears people don't fully read before replying. I specifically need FreeRadius 1.1.x - and since it was only released in Jan only the very latest distro's have any chance of having it. Did some intensive Googling and the first thing I came up with was Ubuntu 6.06 so i'm giving that a go. Seems SuSE 10.1 has version 1.1.0 so thats the backup plan... Graham Beneke Apolix Internet Services E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] WEB: www.apolix.co.za http://www.apolix.co.za/ Cell: 082-432-1873 skype:+27824321873?call Skype: grbeneke skype:grbeneke?call Peter Nixon wrote: Either SUSE Linux 10.1 or SUSE Linux Enterprise Server 10 should do you fine. Cheers All versions of SUSE Linux in the last 5 years or so have included FreeRADIUS. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html