sqlcounter is not kicking users

2010-08-27 Thread ziko 
Hello,  I configured sqlcounter on my radius server and trying to limit hotspot 
users time. But when time expires, Max-All-Session is not kicking users. (but 
when they log out, then they cant log in)  How can i solve this problem?

I am using:
Freeradius 2
CentOS 5.3
Mikrotik as NAS.

My sqlcounter.conf:

sqlcounter noresetcounter {
counter-name = Max-All-Session-Time 
check-name = Max-All-Session 
sqlmod-inst = sql 
key = User-Name 
reset = never 
query = SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE 
UserName='%{%k}' 


  -
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: sqlcounter is not kicking users

2010-08-27 Thread Alan DeKok 
ziko wrote:
 Hello,  I configured sqlcounter on my radius server and trying to limit
 hotspot users time. But when time expires, Max-All-Session is not
 kicking users. (but when they log out, then they cant log in)  How can i
 solve this problem?

  Use a NAS that enforces Session-Timeout.

  This isn't a problem on the RADIUS server.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: sqlcounter is not kicking users

2010-08-27 Thread ziko 
Thank you for answer. I decided to use session-timeout  with Max-All-Session.  
Session-timeout kicks users when time expires, but then they can log in again. 
and max-all-session ant session-timeout alliance works great :)






From: Alan DeKok al...@deployingradius.com
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Fri, August 27, 2010 2:46:46 PM
Subject: Re: sqlcounter is not kicking users

ziko wrote:
 Hello,  I configured sqlcounter on my radius server and trying to limit
 hotspot users time. But when time expires, Max-All-Session is not
 kicking users. (but when they log out, then they cant log in)  How can i
 solve this problem?

  Use a NAS that enforces Session-Timeout.

  This isn't a problem on the RADIUS server.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



  -
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html