Hi Tim,
Just a feedback.
Arun Nair from Aruba ERT solved the problem.
He changed the query.
I was using the query below :
select count(*) as sessions from radius_acct
where (username = '%{Authentication:Username}') AND
end_time is null AND termination_cause is null AND
(updated_at BETWEEN (now() - interval '1 hour') AND now());
It was replaced with the following one that is working fine now.
SELECT COUNT(*) AS active_count FROM radius_acct WHERE username = '%{Authentication:Username}' AND start_time >= NOW() -
INTERVAL '2 day' AND end_time is NULL;
Another important thing that he explained is that counter starts with 0 because it is using accounting information. So after first sucessfull authorization counter is 0, after second counter is 1 and so on.
To limit 3 active sessions I am suing the following Enforcement:
(Authorization:[Insight Repository]:Active-Sessions GREATER_THAN_OR_EQUALS 3) -- Deny
Thanks,
Luis Fernando Rodrigues