Hi,
i'm configuring a server with a sql counter to check the total byte in a
week for the users.
But the server will reply a wrong count.
Here's the counter:
sqlcounter weeklybytecounter {
counter-name = Weekly-Total-Max-Octets
check-name = Max-Weekly-Octets
reply-name = Mikrotik-Total-Limit
perfectly then any
time I run radiusd normally it works as well... But if I change the name
of a sqlcounter instance and run radiusd normally it will error until
radiusd -X is run again Very strange!!!
I spend all last night testing this and it seams I was always doign the
right thing
Hey Everyone,
I'm trying to create a new sqlcounter instance that counts octets. I
think
what I've done is correct but I get the following error when I start
FreeRadius...
Mon Oct 1 21:09:41 2012 : Error:
/usr/local/etc/raddb/sites-enabled/default[203]: Failed to find
Russell Stockhammer wrote:
I'm trying to create a new sqlcounter instance that counts octets. I think
what I've done is correct but I get the following error when I start
FreeRadius...
...
sql/mysql/counter.conf
Why? The default sqlcounter file is in raddb/modules. Put
On Tue, Oct 2, 2012 at 6:47 PM, Alan DeKok al...@deployingradius.com wrote:
Russell Stockhammer wrote:
I'm trying to create a new sqlcounter instance that counts octets. I think
what I've done is correct but I get the following error when I start
FreeRadius...
...
sql/mysql
Fajar A. Nugraha wrote:
I think he might got confused because there are
raddb/sql/mysql/counter.conf and raddb/sql/postgresql/counter.conf, as
well as raddb/modules/sqlcounter_expire_on_login.
OK... and the modules are in the raddb/modules directory.
Perhaps we should add a small
On Tue, 2 Oct 2012, Alan DeKok wrote:
Russell Stockhammer wrote:
I'm trying to create a new sqlcounter instance that counts octets. I think
what I've done is correct but I get the following error when I start
FreeRadius...
...
sql/mysql/counter.conf
Why? The default
On Tue, 2 Oct 2012, Fajar A. Nugraha wrote:
On Tue, Oct 2, 2012 at 6:47 PM, Alan DeKok al...@deployingradius.com wrote:
Russell Stockhammer wrote:
I'm trying to create a new sqlcounter instance that counts octets. I think
what I've done is correct but I get the following error when I start
On Wed, Oct 3, 2012 at 12:04 PM, Russell Stockhammer
russg...@329ncle.no-ip.org wrote:
Ok, but there is also a;
-
$INCLUDE sql/mysql/counter.conf
Good catch :)
FR is pretty flexible in its configuration. Suffice to say that most
(all?) module configuration (including sql
Thanks Fajar!!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi everybody!!
I have been using Freeradius as AAA of some wireless hotspots and it works
great!!
After reading the Rlm_sqlcounter wiki page I started to use it, and it also
works great. This is the code of my sqlcounters:
sqlcounter dailycounter {
counter-name = Daily-Session-Time
On Wed, Aug 8, 2012 at 8:34 PM, Andres Gomez Ruiz
andres.go...@urbalink.co wrote:
I have some users that I need to reject their sessions at midnight, because
of that Im using the dailycounter...
IIRC that's not what dailycounter is for.
but I need that user can't login again
(the user is
the sqlcounter is resetted hourly), with username test1, I
can
access the services given by freeradius an unlimited time.
That's not right.
- Did you read the wiki?
- Did you try to run FR in debug mode? Did it send Session-Timeout
attribute? Was it calculated correctly?
- Does your NAS honor
On Fri, Jun 29, 2012 at 2:58 PM, Andrei Petru Mura mapand...@gmail.com wrote:
Fri Jun 29 10:20:06 2012 : Info: [hourlycounter] expand: %{sql:SELECT
SUM(AcctSessionTime - GREATER((1340953200 -
AcctStartTime::ABSTIME::INT4), 0)) FROM radacct WHERE
So, as you can see from my comments, the Session-Timeout attribute isn't
present in the radius response debug from the first login. The second
time
when it appears, it is caluculated correctly. For now I think that I
have an
issue with FR, so I don't go further to my chillispot NAS yet.
I'm running FreeRADIUS in conjunction with PostgreSQL 9.1. Snippet from
radiusd.conf:
modules {
...
$INCLUDE sql/postgresql/counter.conf
...
}
in my sql/postgresql/counter.conf, I have the following:
sqlcounter dailycounter {
counter-name = Daily-Session-Time
check
| := | test1
Please fix that. Really. It's been ~6 years that Password := has
been *documented* as being wrong.
See the FAQ.
168 | test1 | Max-Daily-Session | := | 60
The problem is that every time when I authenticate for the first time
per hour (because the sqlcounter
168 | test1 | Max-Daily-Session | := | 60
The problem is that every time when I authenticate for the first time per
hour (because the sqlcounter is resetted hourly), with username test1, I can
access the services given by freeradius an unlimited time.
That's not right.
- Did you
YvesDM wrote:
We 're about to upgrade our radius which is still running 1.1.7
We use monthly datalimits so we patched the sqlcounter in order to
make it reply max 4GB of left quota (to avoid wrapping), even if the
user still has 10GB quota left.
Of course this results in a logged out user
On Fri, Apr 1, 2011 at 10:40 AM, Alan DeKok al...@deployingradius.com wrote:
The latest version has rlm_expr, which is 64-bit clean. You can use
it to split the counters into 32-bit pieces.
Alan DeKok.
Tnx Alan, will check it out.
-
List info/subscribe/unsubscribe? See
Hi,
We 're about to upgrade our radius which is still running 1.1.7
We use monthly datalimits so we patched the sqlcounter in order to
make it reply max 4GB of left quota (to avoid wrapping), even if the
user still has 10GB quota left.
Of course this results in a logged out user when he reaches
We are working on re-setting up our hotspot (coovachilli/freeradius
accounting in sql/ldap authentication) better and are trying to setup
bandwidth limiting and such.
What we seem to be having problems with is how to pull the data out of
the sqlcounter module to compare the data used
I want to use sqlcounter to control the user's traffic usage, and I have
these needs:
1. I have read http://wiki.freeradius.org/Rlm_sqlcounter the wiki about
the sqlcounter, and I get %b as the unix time value of beginning of reset
period but how can I set this value? I want to sqlcounter
I am trying to do the same in sqlcounter but looks like the %b is hard
coded and there is no way to make it dynamically read from database. I
have tried using custom sqlcounter but it doe not escapes properly.
Anyone effort in commenting on this thread will be highly appreciable
again, you are really helpful !!
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Changing-radgroup-with-a-sqlcounter-tp3270524p3274236.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org
Anyone ?
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Changing-radgroup-with-a-sqlcounter-tp3270524p3273562.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
If I understand you correctly, instead of kicking the user with the
sqlcounter, you simply want to move them into a different group. It should
pretty straight forward. You need to set read_groups = yes in your sql
module. I would recommend that you put the check and reply attributes
Hello,
I am working on a radius config for a hotspot. I already configured a script
that kick the user when the quota exceed thanks to some very useful posts in
the coova forum.
I used this counter :
sqlcounter noresetBytecounter {
counter-name = Total-Max-Octets
check
chillispot_max_bytes_daily returns reject for
request 10
modcall: leaving group authorize (returns reject) for request 10
Delaying request 10 for 5 seconds
Finished request 10
Going to the next request
Now if i replace the query with :
sqlcounter chillispot_max_bytes_daily {
counter-name = ChilliSpot-Max-Total
Dear Gentlemen
I'm having a problem with my daily count :
sqlcounter chillispot_max_bytes_daily {
counter-name = ChilliSpot-Max-Total-Octets
check-name = ChilliSpot-Max-Total-Octets
reply-name = ChilliSpot-Max-Total-Octets
sqlmod-inst = sql
key = User-Name
reset = daily
query = SELECT SUM
Mordor Networks wrote:
It is disconnecting the user if limit is reached but user can connect
again like it is not stopping the account, now if i replace the query
with #query = SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets)) FROM
radacct WHERE UserName='%{%k}' that will disconnect the
Hello, I configured sqlcounter on my radius server and trying to limit hotspot
users time. But when time expires, Max-All-Session is not kicking users. (but
when they log out, then they cant log in) How can i solve this problem?
I am using:
Freeradius 2
CentOS 5.3
Mikrotik as NAS.
My
ziko wrote:
Hello, I configured sqlcounter on my radius server and trying to limit
hotspot users time. But when time expires, Max-All-Session is not
kicking users. (but when they log out, then they cant log in) How can i
solve this problem?
Use a NAS that enforces Session-Timeout
...@deployingradius.com
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Fri, August 27, 2010 2:46:46 PM
Subject: Re: sqlcounter is not kicking users
ziko wrote:
Hello, I configured sqlcounter on my radius server and trying to limit
hotspot users time. But when time expires, Max-All
- what he already finihsed).
Seems like a reasonable work-around for the user to simply re-connect for
the remaining time.
Regards,
Liran.
On Thu, Aug 12, 2010 at 10:07 AM, tadi...@verizon.net wrote:
I'm using Freeradius + Chillispot+MySql for hotspot. Sqlcounter
noresetcounter works fine
I'm using Freeradius + Chillispot+MySql for hotspot. Sqlcounter noresetcounter
works fine for prepaid access time, however the counter is loaded only once
when the user first authenticate.
This means that even if Max-All-Session changes after initial logon (as it
happens when the user adds
tadi...@verizon.net wrote:
I'm using Freeradius + Chillispot+MySql for hotspot. Sqlcounter
noresetcounter works fine for prepaid access time, however the counter is
loaded only once when the user first authenticate.
This means that even if Max-All-Session changes after initial logon
On Fri, Jun 4, 2010 at 11:52 AM, Антон Зайцев anton.zajt...@gmail.comwrote:
Hello everyone.
Need some help. I want to limit my users with MB traffic monthly. I have
set up sqlcounter and it works great. But it resets in month starting user
first connect to NAS. Users can register and connect
Hello everyone.
Need some help. I want to limit my users with MB traffic monthly. I have set
up sqlcounter and it works great. But it resets in month starting user first
connect to NAS. Users can register and connect on different day during the
month and then it resets differently for each user
Hello
I have installed freeradius + LDAP backend. I need to limit the
connection time per user. I found sqlcounter as a solution but I have
two problems:
1 - I need to take the values: Max-Daily-Session and
Max-Monthly-Session from LDAP and not from mysql DB.
2 - I need to terminate
To: freeradius-users@lists.freeradius.org
Sent: Sunday, November 29, 2009 5:45 PM
Subject: Session-Octets-Limit and sqlcounter
Hi,
I'm using freeradius-2.1.6, and I'm going to make a download limitation for
my users. I used sqlcounter module and config it as follow:
sqlcounter
Charles wrote:
Do you manage to fix your problem?
Kindly share your solution. I am interested in knowing how I can
configure my freeradius to limit users by both time and max download size
As with *ALL* of these questions:
Does your NAS support this?
Go read the NAS
- Original Message -
From: Alan DeKok al...@deployingradius.com
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, November 30, 2009 3:04 PM
Subject: Re: Session-Octets-Limit and sqlcounter
Charles wrote:
Do you manage to fix your problem?
Kindly share your
Charles wrote:
My NAS is m0n0wall (http://m0n0.ch/wall/features.php) and its captive
portal features are briefly outlined here:
http://doc.m0n0.ch/handbook/ch12s06.html .
It mentions bandwidth setings.
How nice.
In my current setup, I use session_timeout and it works very well but I
have
- Original Message -
From: Alan DeKok al...@deployingradius.com
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, November 30, 2009 4:08 PM
Subject: Re: Session-Octets-Limit and sqlcounter
Charles wrote:
My NAS is m0n0wall (http://m0n0.ch/wall/features.php
On Mon, Nov 30, 2009 at 4:44 PM, Charles char...@goma.kivu-online.com wrote:
Thanks Allan,
I think you are right, I will ask in the monowall forum.
Just that the forum is not very active on Captive Portal issues.
Could you be kind to suggest a NAS that you know which can help me achieve
my
I think you are right, I will ask in the monowall forum.
Just that the forum is not very active on Captive Portal issues.
Could you be kind to suggest a NAS that you know which can help me achieve
my goal?
Thanks in advance - I know I am asking too much.
Yes you do. Now go and read
, 2009 11:09 PM
Subject: Re: Session-Octets-Limit and sqlcounter
On Mon, Nov 30, 2009 at 4:44 PM, Charles char...@goma.kivu-online.com
wrote:
Thanks Allan,
I think you are right, I will ask in the monowall forum.
Just that the forum is not very active on Captive Portal issues.
Could you be kind
Hi,
I'm using freeradius-2.1.6, and I'm going to make a download limitation for
my users. I used sqlcounter module and config it as follow:
sqlcounter monthlydownload {
counter-name = Monthly-Download-Byte
check-name = Max-Monthly-Download
reply-name = Session-Octets-Limit
key = User-Name
I'm using freeradius-2.1.6, and I'm going to make a download limitation
for
my users. I used sqlcounter module and config it as follow:
According to the log messages, it shows anything is OK:
Where is my problem?
rlm_sqlcounter: Reply attribute Session-Octets-Limit is number 3009
Did
Hi,
I'm having issues with octet accounting. Users are monthly limited in
octets, not in time.
The problem i have is when a user logs in on the last day of the month
and stays online for 3 days then there's 2days within the new month
but the accounting counts within the previous month, which we
YvesDM wrote:
I'm having issues with octet accounting. Users are monthly limited in
octets, not in time.
The problem i have is when a user logs in on the last day of the month
and stays online for 3 days then there's 2days within the new month
but the accounting counts within the previous
because sqlcounter...
To: t...@kalik.net, FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Date: Saturday, May 9, 2009, 2:03 PM
i am using freeradius 1.1.7, not that old rite??? i've tried using := operator
and cleartext-password but still doesn't work..this bellow is my radcheck
--- On Tue, 5/12/09, Ming-Ching Tiew mct...@yahoo.com wrote:
Whereas the radclient continually sending accounting info
to
the server, I thought doing the reject at accouting will
also some what accomplishing the same purpose.
Any comments ?
Further readings seems to indicate
I am thinking of using sqlcounter to implement a logout counter,
ie whenever I want to logout a particular user, I set something
into the database, then the sqlcounter will pick it up, and
drop the existing session.
Dropping sessions on radius server will have no impact on users connection
I am thinking of using sqlcounter to implement a logout counter,
ie whenever I want to logout a particular user, I set something
into the database, then the sqlcounter will pick it up, and
drop the existing session.
OK I read in some of the older posts, one way people have
implemented
happen??
--- On Sat, 5/9/09, Ivan Kalik t...@kalik.net wrote:
From: Ivan Kalik t...@kalik.net
Subject: Re: authentication failed because sqlcounter...
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Date: Saturday, May 9, 2009, 2:51 AM
mm confusing..i just enable
happen??
--- On Sat, 5/9/09, Ivan Kalik t...@kalik.net wrote:
From: Ivan Kalik t...@kalik.net
Subject: Re: authentication failed because sqlcounter...
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Date: Saturday, May 9, 2009, 2:51 AM
mm confusing..i just enable
mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it as
default no change i made in noresetcounter module. then i adding noresetcounter
in authorize and instantiate section.
i have defined 1user named tes and password tes has loged in normally before i
add attribut max-all
mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it as
default no change i made in noresetcounter module. then i adding noresetcounter
in authorize and instantiate section.
i have defined 1user named tes and password tes has loged in normally before i
add attribut max-all
mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it as
default no change i made in noresetcounter module. then i adding noresetcounter
in authorize and instantiate section.
i have defined 1user named tes and password tes has loged in normally before i
add attribut max-all
mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it
as default no change i made in noresetcounter module. then i adding
noresetcounter in authorize and instantiate section.
i have defined 1user named tes and password tes has loged in normally
before i add attribut max
tnt-4 wrote:
3) Currently I receive something like Reply-Message = Your maximum
never usage time has been reached when the counter reaches its limit -
even when what was counted as not time but data volume. Can Reply-Message
for sqlcounter be configured as in the expiration module
alt_ wrote:
Can you show some examples please? I try to do like this:
noresetBytecounter
if (reject) {
update reply {
Reply-Message := Traffic limit exceeded.
}
}
but if noresetBytecounter return reject freeradius immediatly return reject
to
On Thu, 26 Feb 2009 12:03:22 +0200, Alan DeKok al...@deployingradius.com
wrote:
alt_ wrote:
Can you show some examples please? I try to do like this:
noresetBytecounter
if (reject) {
update reply {
Reply-Message := Traffic limit exceeded.
}
}
but if
Alexander Solodukhin wrote:
/etc/freeradius/sites-enabled/default[412]: SQL Counter modules aren't
allowed in 'post-auth' sections -- they have no such method.
The REJECT handler needs to be put into the post-auth section. Not
the sqlcounter module.
Please READ the default configuration
Can you show some examples please? I try to do like this:
noresetBytecounter
if (reject) {
update reply {
Reply-Message := Traffic limit exceeded.
}
}
but if noresetBytecounter return reject freeradius immediatly return
reject
to user and do not
no such method.
Don't put the counter there but the counter attribute:
if(control:Counter-Attribute 0) { ...
Sorry, i read mans and comments in config and try to do like you say but
it's not work as i need. I have sqlcounter:
sqlcounter noresetBytecounter {
counter-name = Total-Max
Sorry, i read mans and comments in config and try to do like you say but
it's not work as i need. I have sqlcounter:
sqlcounter noresetBytecounter {
counter-name = Total-Max-Octets
check-name = Max-Octets
reply-name = ChilliSpot-Max-Total-Octets
sqlmod-inst
On Thu, 26 Feb 2009 16:55:00 +0200, t...@kalik.net wrote:
Sorry, i read mans and comments in config and try to do like you say but
it's not work as i need. I have sqlcounter:
sqlcounter noresetBytecounter {
counter-name = Total-Max-Octets
check-name = Max-Octets
reply
at the code and sqlcounter module sets the Reply-Message:
Your maximum %s usage time has been reached when user is rejected.
Check for that reply message and alter it.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
. error message
will be displayed.
I had a look at the code and sqlcounter module sets the Reply-Message:
Your maximum %s usage time has been reached when user is rejected.
Check for that reply message and alter it.
Thank you. I see this solution in the internet, but i need configurable
Reply
Thank you. I see this solution in the internet, but i need configurable
Reply-Message, becouse i want to limit not only traffic, but session time
too.
Actually, I can recall that sqlcounter had configurable Reply-Message in
early days (I had 1.0.5 where it was configurable). Download 1.0.5
.
3) Currently I receive something like Reply-Message = Your maximum
never usage time has been reached when the counter reaches its limit -
even when what was counted as not time but data volume. Can Reply-Message
for sqlcounter be configured as in the expiration module?
No. But you can
.
3) Currently I receive something like Reply-Message = Your maximum
never usage time has been reached when the counter reaches its limit –
even when what was counted as not time but data volume. Can Reply-Message
for sqlcounter be configured as in the expiration module
) Currently I receive something like Reply-Message = Your maximum
never usage time has been reached when the counter reaches its limit -
even when what was counted as not time but data volume. Can Reply-Message
for sqlcounter be configured as in the expiration module?
4) One surprise I have
Good Day.
Im wondering is someone could assist me here.
I currently have freeradius setup and working somewhat.
However I have following setup:
sqlcounter monthlytraffic {
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
reply
#query = SELECT SUM(OctetTotal) FROM thismonthsusage WHERE
UsernameView='%{%k}'
}
..
As soon as a new month rolls over there are NO accounting entries for that
user for that month, hence no record and freeradius denies user as he hasn't
got any entries, any body know how I should modify the view
--
sqlcounter noresetBytecounter {
counter-name = Total-Max-Octets
check-name = Max-Octets
reply-name = ChilliSpot-Max-Total-Octets
sqlmod-inst = sql
key = User-Name
reset = never
counter-type = data
liran tal wrote:
Waiting for that traffic limitation patch, Venkatesh.
Thanks.
Hi,
I was stuck with this problem too, and I came up with this solution,
which works in my test environment.
The idea is to store allowed bytes in Tmp-Integer-0, than just use
unlang to compare user's allowed
Hi,
On Wed, Nov 12, 2008 at 2:06 AM, liran tal [EMAIL PROTECTED] wrote:
Waiting for that traffic limitation patch, Venkatesh.
Thanks.
I am sorry. I had few busy days this week. You can expect a patch tomorrow.
On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K [EMAIL PROTECTED] wrote:
Hi Liran,
Hey,
Thanks for the tip, though that's FR2-specific solution and I'd like to be
able to get this sort out with older deployments
running 1.1.7 or earlier (god forbid! :-) )
That patch for rlm_sqlcounter would be ideal I think.
I think this should also be already pushed into the formal release,
Waiting for that traffic limitation patch, Venkatesh.
Thanks.
On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K [EMAIL PROTECTED] wrote:
Hi Liran,
On Sun, Nov 9, 2008 at 4:16 AM, liran tal [EMAIL PROTECTED] wrote:
Hey Venkatesh,
On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K [EMAIL PROTECTED]
On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K [EMAIL PROTECTED] wrote:
Hi Liran,
On Sun, Nov 9, 2008 at 4:16 AM, liran tal [EMAIL PROTECTED] wrote:
Hey Venkatesh,
On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K [EMAIL PROTECTED] wrote:
rlm_sqlcounter has one more limitation. In version
Answers before questions? Novel idea.
limited to 4GB
Sent from my iPhone
On 9 Nov 2008, at 14:00, liran tal [EMAIL PROTECTED] wrote:
On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K [EMAIL PROTECTED] wrote:
Hi Liran,
On Sun, Nov 9, 2008 at 4:16 AM, liran tal [EMAIL PROTECTED]
wrote:
Hey
Hey Venkatesh,
On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K [EMAIL PROTECTED] wrote:
2008/10/31 [EMAIL PROTECTED]:
It does make sense. rlm_sqlcounterworks like this toward the time of the
reset: lets say you have an hour left, your limit is 20 hours and you
have signed in 15 minutes
Hi Liran,
On Sun, Nov 9, 2008 at 4:16 AM, liran tal [EMAIL PROTECTED] wrote:
Hey Venkatesh,
On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K [EMAIL PROTECTED] wrote:
2008/10/31 [EMAIL PROTECTED]:
It does make sense. rlm_sqlcounterworks like this toward the time of the
reset: lets say you
Well, taking this issue back to the begining - it all started with my report
that using the attribute Chilli-Max-Total-Octets
in the sqlcounter provided as follows yields wrong results for all of the
reset times (daily/weekly/monthly):
sqlcounter counterChilliSpotMaxDailyOctets
this issue back to the begining - it all started with my report
that using the attribute Chilli-Max-Total-Octets
in the sqlcounter provided as follows yields wrong results for all of the
reset times (daily/weekly/monthly):
sqlcounter counterChilliSpotMaxDailyOctets
2008/10/31 [EMAIL PROTECTED]:
It does make sense. rlm_sqlcounterworks like this toward the time of the
reset: lets say you have an hour left, your limit is 20 hours and you
have signed in 15 minutes before counter reset time. When code
calculates that you can be online at reset time it
1.1.X)
What still disturbs me is that many of the hotspot forums (coovachilli and
chillispot) has post on how to add an sqlcounter
which performs these data queries successfully and user's feedback is that
everything is good and working. Not that it's
something to count on but I'd guess if somsone
is that many of the hotspot forums (coovachilli and
chillispot) has post on how to add an sqlcounter
which performs these data queries successfully and user's feedback is that
everything is good and working. Not that it's
something to count on but I'd guess if somsone had an issue then we'd know
about
(res = (data-reset_time - request-timestamp))) {
res = data-reset_time - request-timestamp;
res += check_vp-vp_integer;
}
(that's rlm_sqlcounter.c line about 710 in 2.0.5)
Sqlcounter was designed for time counters. When your
I've actually tested the sqlcounter for a data counter for both weekly and
monthly resets and that doesn't work well either...
This is odd because people have reported this working so... it is either
something in the configuration that I'm missing
or I really don't know what's going
.
Ivan Kalik
Kalik Informatika ISP
Dana 25/10/2008, liran tal [EMAIL PROTECTED] piše:
I've actually tested the sqlcounter for a data counter for both weekly and
monthly resets and that doesn't work well either...
This is odd because people have reported this working so... it is either
something
I have had hard time using sqlcounter for data. It has (at least had)
limitations for counting data like 2GB limit. I ended up writing my
own code for counting data.
Here is a small patch which will skip adding additional quota if
counter-type=time in sqlcounter.conf file
PROTECTED]
Behalf Of liran tal
Sent: Friday, October 24, 2008 1:07 AM
To: FreeRadius users mailing list
Subject: sqlcounter returning wrong value?
Hey,
I'm experimenting with some sqlcounter directives in radiusd.conf and
chilli as the NAS.
I've defined the following sqlcounter stanza
http://www.indohotspot.net
Your Hotspot solution
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Behalf Of liran tal
Sent: Friday, October 24, 2008 1:07 AM
To: FreeRadius users mailing list
Subject: sqlcounter returning wrong value?
Hey,
I'm
]
[mailto:freeradius-users-bounces+muliantofreeradius-users-bounces%2Bmulianto
[EMAIL PROTECTED]
Behalf Of liran tal
Sent: Friday, October 24, 2008 1:07 AM
To: FreeRadius users mailing list
Subject: sqlcounter returning wrong value?
Hey,
I'm experimenting with some sqlcounter
It (daily sqlcounter) does the same in 2.0.5:
rlm_sqlcounter: Authorized user jagoda, check_item=1000, counter=2635
rlm_sqlcounter: Sent Reply-Item for user jagoda, Type=Session-Timeout,
value=10027850
Returns value that is greater than the limit. I am using noreset
sqlcounter and that one
1 - 100 of 201 matches
Mail list logo
