User disconnects but stays online in radius

[Mobin Yazarlou]

On Tue, Feb 19, 2013 at 2:38 PM, Phil Mayers <p.mayers at imperial.ac.uk>wrote:

> On 19/02/13 06:53, Russell Mike wrote:
>
>> Hi Phil & Moby,
>>
>> I am also interested in this solution since experiencing the same
>> problem.  I liked the solution no1.
>>
>> But I have no idea where I can get that script but I can modify if I
>> have one.
>>
>
> It's a pretty simple script. Depending on your SQL database, you just do a
> "select from radacct where acctstarttime + acctsessiontime < 'now - 2
> hours'" or whatever.
>
> It should be a 1-line SQL query.
>
> However - I should emphasise that interim accounting and expiring dead SQL
> sessions is no substitute for a resilient RADIUS service; you should really
> have two servers, and look to use robust accounting *as well* as interim
> acct.
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/**
> list/users.html <http://www.freeradius.org/list/users.html>
>


 The more I read about this, the more complicated it gets!
 Dear Phil, the first and third solutions you provided will work great but
their implementation is not that easy. As you said above, following the
first approach needs packet monitoring as well, which is not easy to
implement unless there be a log file/table in freeradius for this packets.
And the value for "acctsessiontime" is 0 until the user disconnects and
freeradius sets the correct value for this field and some other fields in
radacct table.

 I also found that sometimes removing the last accounting record for the
locked user in the radacct table won't work and you need to set
"/var/log/freeradius/radutmp" to null, to unlock that user.

 I wish there was a table for online users in NAS and we could compare
online user in NAS and online users in RADIUS and decide what to do.

 I am still looking forward for your helpful comments and suggestion on
this topic.

Thank you,
Moby
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130219/87d0fc7f/attachment.html>