[EMAIL PROTECTED] wrote:
Sebastian Wild wrote:
Hello list,
I've just joined in here. My name is Sebastian and I am from Germany. I work as adminstrator at an ISP and I also am a maintainer of a private wlan project called wlan-r.
Now wlan-r uses chillispot to authenticate wireless users on hotspots via freeradius against mysql and it works fine.
Recently I've seen that it is possible to get info about which users are currently online on wlan. Since that was not on a hotspot but on a website somewhere at the net I am thinking that it used a feature of the freeradius server. Now it would be very interesting to know how to get the info about which users are currently online out of free radius.
Does anyone know how to do that?
Some implementations rely on the accounting status: if there is a start record without a stop record you can assume that the user is still online. But this represents not always the reality.
-- Gerald
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thank you all for your help!
I've now done it by using the data from the radacct table of the radius db and it works fine.
I've even added a table listing our hotspots by their essid and mac and my script looks the hotspots up there via the CalledStationId which it gets from radacct.
As far as we tested it it worked all fine :)
My statistics script now gives current logged in users as well as prior logins back since freeradius is runnign on the server :)
I only had to block the first entries of radacct from being listed because at those times something went badly wrong and so they have no AcctEndTime (0000-00-00-00:00) ;)
And there is plenty more info in radacct that could be used :) Maybe I will expand the statistics...
greets from snowy Regensburg, GER Sebastian
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
