<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:tnt@kalik.net">tnt@kalik.net</a> a écrit :
<blockquote cite="mid:Yktgj1BV.1220995994.9810330.tnt@kalik.net"
type="cite">
<blockquote type="cite">
<pre wrap="">Good it's sent in the reply to the nas! Thx
But the sqlcounter i setup was supposed to reset every hours , but
apparently doesn't...
Where can i take a look to find out why?
</pre>
</blockquote>
<pre wrap=""><!---->
Check the sql query definition and value of reset in counter.conf.
</pre>
</blockquote>
<br>
here is the counter definition:<br>
sqlcounter bytesQuota {<br>
counter-name = traffic_quota<br>
check-name = Max-Traffic<br>
reply-name = Tmp-Integer-0<br>
sqlmod-inst = mysqldb<br>
key = User-Name<br>
reset = hourly<br>
query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM
radacct WHERE UserName='%{%k}'"<br>
}<br>
<br>
sounds good to me... what could be the reasn for noreset?<br>
<br>
<blockquote cite="mid:Yktgj1BV.1220995994.9810330.tnt@kalik.net"
type="cite">
<pre wrap="">
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
</body>
</html>