On Fri, Jan 14, 2011 at 1:57 PM, Johan Meiring <jmeir...@pcservices.co.za> wrote: > 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}" > > --
Enclosing the UPDATE in an empty 'if' works: if ("%{sql: UPDATE ...}") { } That prevents the rlm_sql_mysql module from looking for returned fields. Eddie - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html