<!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>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></BODY></HTML>