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