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 <aland@deployingradius.com>wrote:
Bishal Pun wrote:
if(User-Name){ "%{sql: UPDATE radacct set AcctStopTime=ADDDATE(AcctStartTime,INTERVAL AcctSessionTime SECOND), AcctTerminateCause='Clear-Stale Session' WHERE UserName='%{User-Name}' and CallingStationId='%{Calling-Station-Id}' and AcctStopTime is null}" }
That should work, barring SQL issues.
but it doesn't help me, giving me error like Wed Jan 12 15:16:14 2011 : Error: rlm_sql_mysql: MYSQL Error: No Fields
That's a MySQL issue.
any help?
Can you run the command from the mysql client? i.e. without RADIUS being involved?
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html