Deleting stale session automatically with unlang

[Johan Meiring]

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