On Wed, Feb 24, 2010 at 1:32 AM, Alan DeKok 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 info/subscribe/unsubscribe? See http://
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
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
ffic volume and want disconnection to set
> > based 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 Traf
: 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
ffic volume and want disconnection to set
> > based 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 Traf
monthlytraffic {
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset = monthly/
//
/query = "SELECT
(sum(acctinputoctets)+
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 := and based on
sqlcounter calc, do a Reply = Sessions-Octets-
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 := and based on
sqlcounter calc, do a Reply = Sessions-Octets-
#x27;%{%k}' AND \
Month(acctstoptime) =(Month(NOW())) AND \
Year(acctstoptime) = Year(NOW())"
}
authorize {
.
monthlytraffic
.
}
instantiate {
.
monthlytraffic
.
}
created a dictionary entry in daloradius database of:-
id 94
>
> 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 = monthly
>
th MAX-ALL-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
monthlytraffic {
counter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT (sum(acctinputoctets)+sum(acctoutputoctets)) \
FROM ra
14 matches
Mail list logo