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-T
loads 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
On Wed, Oct 3, 2012 at 12:04 PM, Russell Stockhammer
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 and eap) in 3.x is m
On Tue, 2 Oct 2012, Fajar A. Nugraha wrote:
On Tue, Oct 2, 2012 at 6:47 PM, 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
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? T
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 instru
On Tue, Oct 2, 2012 at 6:47 PM, 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...
>>
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
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]: Fail
Thanks Fajar!!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Wed, Aug 8, 2012 at 8:34 PM, Andres Gomez Ruiz
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 valid only 1 day).
> In
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
>
> > 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 chillispo
On Fri, Jun 29, 2012 at 2:58 PM, Andrei Petru Mura wrote:
> Fri Jun 29 10:20:06 2012 : Info: [hourlycounter] expand: %{sql:SELECT
> SUM(AcctSessionTime - GREATER((1340953200 -
> AcctStartTime::ABSTIME::INT4), 0)) FROM radacct WHERE
> UserName='test1' AND
hat I have
an issue with FR, so I don't go further to my chillispot NAS yet.
Do you have some suggestions?
N.B.
1. I changed the counter module name from dailycounter to hourlycounter,
for clearness.
2. Also, in the good working scenario debug trace, I logged in with test3
username. (to cl
t; 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'
henticate 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.
Blame the NAS.
> The sqlcounter is ebanled only if after I log in first time, log out and
> log in again. If
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
On Fri, Apr 1, 2011 at 10:40 AM, Alan DeKok 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 http://www.freeradius.org/list/users.htm
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 res
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 reac
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 to
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 as
it will
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 sqlco
k you 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.freeradiu
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
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
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
sqltrace.sql'
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql_mysql: query: SELECT (SUM(AcctInputOctets)+SUM(AcctOutputOctets))
FROM radacct WHERE UserName='wassim'
rlm_sql (sql): - sql_xlat finished
rlm_sql (sql): Released sql socket id: 0
radius_xlat: '2080402569'
rlm_sqlcou
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
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 = "
FreeRadius users mailing list
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-Session is not
> kicking users. (bu
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 Ses
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
- 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, wrote:
>
> I'm using Freeradius + Chillispot+MySql for hotspot. Sqlcounter
> noresetcounter works fi
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
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
On Fri, Jun 4, 2010 at 11:52 AM, Антон Зайцев wrote:
> 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 o
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 the
ion-Octets-Limit and sqlcounter
On Mon, Nov 30, 2009 at 4:44 PM, Charles
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
> 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 m
On Mon, Nov 30, 2009 at 4:44 PM, Charles 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 goal?
>
> Thanks in ad
- Original Message -
From: "Alan DeKok"
To: "FreeRadius users mailing list"
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) and its captive
portal features are briefly
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
>
Charles
- Original Message -
From: "Alan DeKok"
To: "FreeRadius users mailing list"
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 solution. I am i
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 documentat
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:
> 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 att
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 = "
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
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 do
the problem solved it just because 30 second less than one minute, i've tried
using Max-All-Sesion:=3600 and it works..
--- On Sat, 5/9/09, Nizar Zulmi wrote:
From: Nizar Zulmi
Subject: Re: authentication failed because sqlcounter...
To: t...@kalik.net, "FreeRadius users mailing li
> 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 wil
--- On Tue, 5/12/09, Ming-Ching Tiew 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 this this
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
implem
ed..
whats happen??
--- On Sat, 5/9/09, Ivan Kalik wrote:
From: Ivan Kalik
Subject: Re: authentication failed because sqlcounter...
To: "FreeRadius users mailing list"
Date: Saturday, May 9, 2009, 2:51 AM
> mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it
&
ed..
whats happen??
--- On Sat, 5/9/09, Ivan Kalik wrote:
From: Ivan Kalik
Subject: Re: authentication failed because sqlcounter...
To: "FreeRadius users mailing list"
Date: Saturday, May 9, 2009, 2:51 AM
> mm confusing..i just enable the sqlcounter in radiusd.conf. i just let it
&
> 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
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
>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). Do
xceeded." 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 nee
uot; 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.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Thu, 26 Feb 2009 16:55:00 +0200, 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
>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-
;t
allowed in 'post-auth' sections -- they have 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
>>> 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
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 mod
On Thu, 26 Feb 2009 12:03:22 +0200, Alan DeKok
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 noresetBytecounter retu
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
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 sqlcount
nfigurable. Don't use %b. Calculate start the way you
see fit.
>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 Re
th. Can that be
> done with freeradius?
>
>
rlm_sqlcounter only support calendar month or day or week.
>
> 3) Currently I receive something like Reply-Message = "Your maximum
> never usage time has been reached" when the counter reaches its limit –
> even
) 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
>#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 t
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
: Sent Reply-Item for user %s, Type=%s,
value=%u",
key_vp->strvalue,data->reply_name,reply_item->lvalue);
}
else{
-
Here is a sample sqlcounter.conf
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:
>>
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, th
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
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
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:
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 limit
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
>> > rese
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 mi
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
l" <[EMAIL PROTECTED]> piše:
>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/month
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
running 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
ms running 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 cou
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
en
I reduced it to 10,000 it worked fine.
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...
>Th
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 wha
gt;reset_time &&
(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)
Sql
Hey Ivan
2008/10/24 <[EMAIL PROTECTED]>
> 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
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
>
> >http://www.indohotspot.net
> >Your Hotspot solution
> > -Original Message-
> > From: [EMAIL PROTECTED]
> >[mailto:freeradius-users-bounces+mulianto
> [EMAIL PROTECTED]
> >Behalf Of liran tal
> > Sent: Friday, October 24, 2008 1:07 AM
> >
on-Timeout
>
>try it..
>rgds,
>Mulianto
>
>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: FreeRad
1 - 100 of 208 matches
Mail list logo