<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18882">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Anyone please, as this is driving me mad...</DIV>
<DIV> </DIV>
<DIV>Thx</DIV>
<DIV>Nev</DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=nev@itsnev.co.uk href="mailto:nev@itsnev.co.uk">Neville</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, February 07, 2010 1:28
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Max-Monthly-Traffic</DIV>
<DIV><BR></DIV>
<DIV>Sorry for troubling everyone on this, but I cannot work out why
Session-Octets-Limit is not calculating the differences between the counter
and the check_item and setting an higher limited than the check_item?</DIV>
<DIV> </DIV>
<DIV>Log below</DIV>
<DIV> </DIV>
<DIV>Sun Feb 7 12:59:50 2010 : Debug: rlm_sqlcounter: Check item is
greater than query result<BR>Sun Feb 7 12:59:50 2010 : Debug:
rlm_sqlcounter: Authorized user FT-memjxa, check_item=262100000,
counter=151223038<BR>Sun Feb 7 12:59:50 2010 : Debug: rlm_sqlcounter:
Sent Reply-Item for user FT-memjxa, Type=Session-Octets-Limit,
value=263954010<BR>Sun Feb 7 12:59:50 2010 : Info: ++[monthlytraffic]
returns ok</DIV>
<DIV> </DIV>
<DIV><BR>sqlcounter monthlytraffic
{<BR> counter-name =
Monthly-Traffic<BR>
check-name =
Max-Monthly-Traffic<BR>
reply-name =
Session-Octets-Limit<BR>
sqlmod-inst =
sql<BR>
key =
User-Name<BR>
reset = monthly<BR> query =
"SELECT IFNULL((sum(acctinputoctets)+sum(acctoutputoctets)),0) FROM radacct
WHERE username='%{%k}' AND Month(acctstoptime) =(Month(NOW())) AND
Year(acctstoptime) = Year(NOW())"<BR>}<BR></DIV>
<DIV> </DIV>
<DIV>Any pointers would help.</DIV>
<DIV> </DIV>
<DIV>Thx</DIV>
<DIV>Nev</DIV></BLOCKQUOTE></BODY></HTML>