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 <al...@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 >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html