Re: mysql isn't match with online users status

2008-05-20 Thread Alan DeKok
Zahra Bahar wrote: we have freeradius for accounting of dialup and vpn users. sometimes users have been stoped but they are online in mysql table . what's wrong? is there any log of commmands exchange between freeardius and mysql? What's wrong is that the NAS isn't telling FreeRADIUS

Re: mysql isn't match with online users status

2008-05-20 Thread Zahra Bahar
I considerd row fields in radacct table. all the fields even duration time is correct but stop field is zero for some users that we know they are disconnected so they cann't to be conected until passing random time that thay go to be stoped but the stop-time field is the same as start-time.

Re: mysql isn't match with online users status

2008-05-20 Thread Arran Cudbard-Bell
Zahra Bahar wrote: I considerd row fields in radacct table. all the fields even duration time is correct but stop field is zero for some users that we know they are disconnected so they cann't to be conected until passing random time that thay go to be stoped but the stop-time field is the same

Re: mysql isn't match with online users status

2008-05-20 Thread Zahra Bahar
but another fields are true. could radius have true session-duration but didn't receive stop time? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: mysql isn't match with online users status

2008-05-20 Thread Alan DeKok
Zahra Bahar wrote: but another fields are true. could radius have true session-duration but didn't receive stop time? The server has session duration until the NAS stops sending packets. The session MAY continue for a short time after the last packet. In short, we've been doing this for

Re: mysql isn't match with online users status

2008-05-20 Thread Marinko Tarlac
@Zahra Check the connection between NAS and your radius server. Problem can be caused if your connection is unstable and sometimes radius server didn't receive stop packages. So, just like Alan said.. RS server works fine and you don't need to fix it :) On Tue, May 20, 2008 at 1:09 PM, Alan

mysql isn't match with online users status

2008-05-19 Thread Zahra Bahar
we have freeradius for accounting of dialup and vpn users. sometimes users have been stoped but they are online in mysql table . what's wrong? is there any log of commmands exchange between freeardius and mysql? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html