login (auth) when the
time goes to zero.
sqlcounter noresetcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query = SELECT IFNULL(SUM
Never mind. I did not have noresetcounter in the authorize section. This in
turn caused me to use the
wrong check variable (Max-All-Session-Time instead of Max-All-Session) as the
right one wasn't known (because
the noresetcounter wasn't known to 'authorize'.
Anyway. My apologies for the false
Hi,
My objective to configure freeradius is that the user automatically gets
logged out during the accounting process by noresetcounter statement.
But currently, the user that is logged in keeps being connected even
when the time is up.
Here's my counter.conf:
---
sqlcounter noresetcounter
-Timeout 3600
Idle-Timeout 60
Thanks RM --
On Mon, Apr 1, 2013 at 1:35 PM, Muhammad Nuzaihan Kamal Luddin
muham...@taqisystems.com wrote:
Hi,
My objective to configure freeradius is that the user automatically gets
logged out during the accounting process by noresetcounter statement
UserName='%{User-Name}''
[noresetcounter]expand: SELECT SUM(AcctSessionTime) FROM radacct
WHERE UserName='%{User-Name}' - SELECT SUM(AcctSessionTime) FROM radacct
WHERE UserName='6cmy75HS'
sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE
UserName='6cmy75HS
On occasions sqlcounter does not seem to work correctly, especially for
NEW
User that have no radacct details.
After doing some digging, I've identified the issue only to happen on the
first ever connect of the user in a new account.
As you will see from the sql below, if no integer is
Hi,
I've noticed on the default FR 2.0.4 MySQL counter.conf file, for the
sqlcounter noresetcounter , there isn't a count-attribute of
Acct-Session-Time or a reply-name of something like Session-Timeout.
The dailycounter and monthlycounter both have a reply-name . Is this
for a reason
Anyone have advice/input?
N White wrote:
I'm having trouble setting up the noresetcounter(Max-All-Session). I'm
running freeradius 1.0.4(Debian). I have compiled and added the
rlm_sqlcounter.so files to the proper folder in Debian, and freeradius
-X shows the module starting up(I have
I'm having trouble setting up the noresetcounter(Max-All-Session). I'm
running freeradius 1.0.4(Debian). I have compiled and added the
rlm_sqlcounter.so files to the proper folder in Debian, and freeradius
-X shows the module starting up(I have renamed it hotspotcounter). If
you would like
**
Here
my configuration on sqlcounter.conf
**
sqlcounter
noresetcounter {
counter-name = Max-All-Session-Time
check-name = Max-All-Session
sqlmod-inst = sql
key = User-Name
reset = never
query
10 matches
Mail list logo