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 wrote:
> I should not give that error according to the source. It definitely
> works in the latest version. P
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 wrote:
> Hello
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 resu
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
CallingStationId='%{Calling-Sta
On Fri, Jan 14, 2011 at 1:57 PM, Johan Meiring
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_my
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 solu
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 wrote:
> Bishal Pun wrote:
>
> > if(User-Name){
> > "%{sql: UPDATE radacct set AcctStopTime=ADDDATE(AcctStartTime,
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 shou
+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 authenti
9 matches
Mail list logo