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
