Re: Deleting stale session automatically with unlang

2011-01-15 Thread Bishal Pun
Hello Eddie, Thanks for the help at last deleting the space from sql: Update section did the tricks. Thank you all for help. Thank you On Sat, Jan 15, 2011 at 1:00 PM, Eddie Stassen estas...@gmail.com wrote: I should not give that error according to the source. It definitely works in the

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Bishal Pun
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.comwrote: Bishal Pun wrote: if(User-Name){ %{sql: UPDATE radacct set

Re: Deleting stale session automatically with unlang

2011-01-14 Thread 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

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Eddie Stassen
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

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Bishal Pun
Hello Edi, Enclosing sql statement inside empty if gives same error: if(User-Name){ if(%{sql: UPDATE radacct set AcctStopTime=ADDDATE(AcctStartTime,INTERVAL AcctSessionTime SECOND), AcctTerminateCause='Clear-Stale Session' WHERE UserName='%{User-Name}' and

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Christ Schlacta
try appending the following snippet to the end of the SQL statement: ; SELECT COUNT(*) col FROM dual WHERE 1=1; the result is numeric 1 is returned, and the requirement that something must return is satisfied. I believe there may be some other statement you can append instead to query the

Re: Deleting stale session automatically with unlang

2011-01-14 Thread Eddie Stassen
I should not give that error according to the source. It definitely works in the latest version. Perhaps its the space between 'sql:' and 'UPDATE' that is preventing the parser from recognising it as a non-select query. Try removing it? On Sat, Jan 15, 2011 at 4:02 AM, Bishal Pun

Deleting stale session automatically with unlang

2011-01-13 Thread Bishal Pun
+Hi , I am using freeradius 2.1.6 + mysql + LDAP for AAA in freebsd server. What I want to do is, when my AP reboots or due to power failure clients login is still seen there as online but the client is not able to do login. SO is it possible to clear the stale session with unlang if the