Neville wrote:
Anyone please, as this is driving me mad...
2^31 issues? Check the code for unsigned int...
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Wed, Feb 24, 2010 at 1:32 AM, Alan DeKok al...@deployingradius.com wrote:
Neville wrote:
Anyone please, as this is driving me mad...
2^31 issues? Check the code for unsigned int...
So you're suggesting to change the source code for rlm_sqlcounter and recompile?
-
List
Anyone please, as this is driving me mad...
Thx
Nev
- Original Message -
From: Neville
To: freeradius-users@lists.freeradius.org
Sent: Sunday, February 07, 2010 1:28 PM
Subject: Max-Monthly-Traffic
Sorry for troubling everyone on this, but I cannot work out why
Session
: ++[monthlytraffic] returns ok
sqlcounter monthlytraffic {
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
reply-name = Session-Octets-Limit
sqlmod-inst = sql
key = User-Name
reset = monthly
users mailing listfreeradius-users@lists.freeradius.org
Subject: Re: MAX-Monthly-Traffic V2 Post.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
on time (session-timout)... a bit tricky isn't it?
So VERY True, Too many late nights and I really do appreciate your input as
this gave me food for thought and I now have EVERYTHING Working.
Both for Traffic Session USAGE.
For Usage, I still had to use Max-Monthly-Traffic as a Check
-Sessions.
This is what I've done so far...
I've added to ./raddb/sql/mysql/counter.conf
sqlcounter monthlytraffic {
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset
-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset = monthly
query = SELECT (sum(acctinputoctets)+sum(acctoutputoctets))
\
FROM radacct WHERE username='%{%k
())) AND \
Year(acctstoptime) = Year(NOW())
}
authorize {
.
monthlytraffic
.
}
instantiate {
.
monthlytraffic
.
}
created a dictionary entry in daloradius database of:-
id 9433
Type integer
Attribute Max-Monthly-Traffic
Value NULL
Format NULL
Vendor dictionary.freeradius.internal
many late nights and I really do appreciate your input as
this gave me food for thought and I now have EVERYTHING Working.
Both for Traffic Session USAGE.
For Usage, I still had to use Max-Monthly-Traffic as a Check := and based on
sqlcounter calc, do a Reply = Sessions-Octets-Limit = XX
many late nights and I really do appreciate your input as
this gave me food for thought and I now have EVERYTHING Working.
Both for Traffic Session USAGE.
For Usage, I still had to use Max-Monthly-Traffic as a Check := and based on
sqlcounter calc, do a Reply = Sessions-Octets-Limit = XX
{
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset = monthly/
//
/query = SELECT
(sum(acctinputoctets)+sum(acctoutputoctets
on time (session-timout)... a bit tricky isn't it?
So VERY True, Too many late nights and I really do appreciate your input as
this gave me food for thought and I now have EVERYTHING Working.
Both for Traffic Session USAGE.
For Usage, I still had to use Max-Monthly-Traffic as a Check
{
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset = monthly
query = SELECT (sum(acctinputoctets)+sum(acctoutputoctets)) \
FROM radacct WHERE username
14 matches
Mail list logo