Re: User disconnects but stays online in radius

2013-02-19 Thread Phil Mayers
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

Re: User disconnects but stays online in radius

2013-02-19 Thread Mobin Yazarlou
On Tue, Feb 19, 2013 at 10:23 AM, Russell Mike radius@gmail.com wrote: On Monday, February 18, 2013, Mobin Yazarlou wrote: On Mon, Feb 18, 2013 at 9:50 PM, Phil Mayers p.may...@imperial.ac.ukwrote: On 18/02/13 18:02, Mobin Yazarlou wrote: Hi, I am using freeradius v2.1.12 with

Re: User disconnects but stays online in radius

2013-02-19 Thread Russell Mike
On Tue, Feb 19, 2013 at 11:08 AM, Phil Mayers p.may...@imperial.ac.ukwrote: 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

Re: User disconnects but stays online in radius

2013-02-19 Thread Russell Mike
On Tue, Feb 19, 2013 at 11:23 AM, Mobin Yazarlou yazarlo...@gmail.comwrote: On Tue, Feb 19, 2013 at 10:23 AM, Russell Mike radius@gmail.comwrote: On Monday, February 18, 2013, Mobin Yazarlou wrote: On Mon, Feb 18, 2013 at 9:50 PM, Phil Mayers p.may...@imperial.ac.ukwrote: On

Re: User disconnects but stays online in radius

2013-02-19 Thread Phil Mayers
On 19/02/13 11:23, Mobin Yazarlou wrote: Hi Mike, Now it is an hour that I am looking for a built-in solution or a ready-to-use script. The only thing I found was Idle-Timeout http://freeradius.org/rfc/rfc2865.html#Idle-Timeout attribute. This problem could be solved if RADIUS was responsible

Re: User disconnects but stays online in radius

2013-02-19 Thread Mobin Yazarlou
On Tue, Feb 19, 2013 at 2:38 PM, Phil Mayers p.may...@imperial.ac.ukwrote: 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

Re: User disconnects but stays online in radius

2013-02-19 Thread Mobin Yazarlou
On Tue, Feb 19, 2013 at 4:31 PM, Phil Mayers p.may...@imperial.ac.ukwrote: On 19/02/13 11:23, Mobin Yazarlou wrote: Hi Mike, Now it is an hour that I am looking for a built-in solution or a ready-to-use script. The only thing I found was Idle-Timeout

Re: User disconnects but stays online in radius

2013-02-19 Thread Alan DeKok
Mobin Yazarlou wrote: The more I read about this, the more complicated it gets! It's because UDP packets can be lost, and you can't realistically get information out of the NAS. The result is that any solution ends up being complicated, and patchy. I also found that sometimes removing the

Re: User disconnects but stays online in radius

2013-02-19 Thread Phil Mayers
On 19/02/13 13:28, Mobin Yazarlou wrote: The more I read about this, the more complicated it gets! It's quite simple in principle. 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

Re: User disconnects but stays online in radius

2013-02-19 Thread Phil Mayers
On 19/02/13 16:09, Russell Mike wrote: *A.) *Enable interim accounting Yes *B.)* Enable post-auth { update reply { Acct-Interim-Interval = 900 } } Yes C.) *You Said:* You also need to ensure the accounting_update_query{,___alt} are configured in your sql.conf; this is the

Re: User disconnects but stays online in radius

2013-02-19 Thread Russell Mike
On Tue, Feb 19, 2013 at 5:28 PM, Phil Mayers p.may...@imperial.ac.ukwrote: On 19/02/13 16:09, Russell Mike wrote: *A.) *Enable interim accounting Yes *B.)* Enable post-auth { update reply { Acct-Interim-Interval = 900 } } Yes C.) *You Said:* You also need to

Re: User disconnects but stays online in radius

2013-02-19 Thread Mobin Yazarlou
Thank you guys. I've learned many useful tips in the last comments. Now I know the idea of comparing online users in RADIUS and NAS can be a good solution but since I use two different NAS types on my network, and I am almost sure both of them don't have standard API to allow other apps read

Re: User disconnects but stays online in radius

2013-02-18 Thread Phil Mayers
On 18/02/13 18:02, Mobin Yazarlou wrote: Hi, I am using freeradius v2.1.12 with MySQL support and noticed if a user disconnect when radius server is down, NAS can not inform radius about user being disconnected and radius assume user is still online after coming up again. This restricts user

Re: User disconnects but stays online in radius

2013-02-18 Thread Russell Mike
On Monday, February 18, 2013, Phil Mayers wrote: On 18/02/13 18:02, Mobin Yazarlou wrote: Hi, I am using freeradius v2.1.12 with MySQL support and noticed if a user disconnect when radius server is down, NAS can not inform radius about user being disconnected and radius assume user is

Re: User disconnects but stays online in radius

2013-02-18 Thread Russell Mike
On Monday, February 18, 2013, Mobin Yazarlou wrote: On Mon, Feb 18, 2013 at 9:50 PM, Phil Mayers p.may...@imperial.ac.ukjavascript:_e({}, 'cvml', 'p.may...@imperial.ac.uk'); wrote: On 18/02/13 18:02, Mobin Yazarlou wrote: Hi, I am using freeradius v2.1.12 with MySQL support and