Deleting stale session automatically with unlang

Johan Meiring jmeiring at
Fri Jan 14 12:57:24 CET 2011

On 2011/01/14 12:50 PM, Bishal Pun wrote:
> Alan,
>   While running that command in mysql it clear the session of user. But with
> radius unlang it is giving error in radius log.

I might be wrong, but as far as I know rlm_mysql expects something to come 
back from the query.

Can't think of a solution though unless rlm_mysql will allow somehting like

"%{sql: SELECT 1; 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}"


Johan Meiring
Cape PC Services CC
Tel: (021) 883-8271
Fax: (021) 886-7782

More information about the Freeradius-Users mailing list