Re: reset sql counter every 30 minute

2011-01-27 Thread Bishal Pun
You can use Session-Timeout attribute in your radreply sql table like: +-+---+-++-+---+ | id | UserName | Attribute | op | Value | +-+---+-++-+---+ | | 257 | test | Session-Timeout | := | 1800|

Re: Deleting stale session automatically with unlang

2011-01-15 Thread Bishal Pun
ersion. Perhaps its the space between 'sql:' and > 'UPDATE' that is preventing the parser from recognising it as a > non-select query. Try removing it? > > On Sat, Jan 15, 2011 at 4:02 AM, Bishal Pun wrote: > > Hello Edi, > > Enclosing sql statement insi

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Bishal Pun
L error: Sat Jan 15 07:44:47 2011 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Sat Jan 15 07:44:47 2011 : Error: rlm_sql (sql): failed after re-connect On Fri, Jan 14, 2011 at 6:19 PM, Eddie Stassen wrote: > On Fri, Jan 14, 2011 at 1:57 PM, Johan Meiring > wrote

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Bishal Pun
Alan, While running that command in mysql it clear the session of user. But with radius unlang it is giving error in radius log. Thanks On Fri, Jan 14, 2011 at 3:41 PM, Alan DeKok wrote: > Bishal Pun wrote: > > > if(User-Name){ > > "%{sql: UPDATE radacct set AcctStopTim

Deleting stale session automatically with unlang

2011-01-13 Thread Bishal Pun
+Hi , I am using freeradius 2.1.6 + mysql + LDAP for AAA in freebsd server. What I want to do is, when my AP reboots or due to power failure clients login is still seen there as online but the client is not able to do login. SO is it possible to clear the stale session with unlang if the authenti

Max-All-Session counter module problem[SOLVED]

2009-08-30 Thread Bishal Pun
Hello all, Problem is solved. Actually it was due to radgroupcheck table. There I have inserted Max-All-Session as 9. I deleted it and now the user can log in. Thank you Bishal Hi, I am posting the debug of another user who has same problem: rad_recv: Access-Request packet from hos

Max-All-Session counter module problem

2009-08-29 Thread Bishal Pun
Hi, I am posting the debug of another user who has same problem: rad_recv: Access-Request packet from host 202.79.xx.XX port 65050, id=12, length=189 NAS-Identifier = "pppoe-bhw." Acct-Session-Id = "1633129-mpd-pppoe-70" NAS-Port = 70 NAS-Port-Type = Ethernet S