<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Verdana">In the source code see in
doc/rlm_sqlcounter<br>
Reggards,<br>
</font></font>
<pre class="moz-signature" cols="72">Carlos Martínez-Troncoso Cera
Coordinador de Servicios Internet/Intranet
Universidad del Norte
Barranquilla, Colombia
Tel: 57 5 3509367</pre>
<br>
<br>
Ross Tsolakidis wrote:
<blockquote
cite="mid1D6778BB284A5A418E7869A3A760F0C648ED5A@hermes.day3office.lan"
type="cite">
<pre wrap="">Thanks for responding.
Can you give me an example of how to set the counter to reset in SQL ?
This is my config for the counter.
counter daily {
filename = ${raddbdir}/db.daily
key = User-Name
count-attribute = Acct-Session-Time
reset = daily
counter-name = Daily-Session-Time
check-name = Max-Daily-Session
allowed-servicetype = Framed-User
cache-size = 5000
}
Thanks again.
Regards,
--
Ross
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:freeradius-users-bounces@lists.freeradius.org">freeradius-users-bounces@lists.freeradius.org</a>
[<a class="moz-txt-link-freetext" href="mailto:freeradius-users-bounces@lists.freeradius.org">mailto:freeradius-users-bounces@lists.freeradius.org</a>] On Behalf Of Alan
DeKok
Sent: Wednesday, 29 June 2005 12:58 AM
To: FreeRadius users mailing list
Subject: Re: sql counter clarification and issues
"Ross Tsolakidis" <a class="moz-txt-link-rfc2396E" href="mailto:Ross.Tsolakidis@day3.com.au"><Ross.Tsolakidis@day3.com.au></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Looking at that debug, where exactly is it resetting the counter ?
</pre>
</blockquote>
<pre wrap=""><!---->
The "counter" module is resetting the counter.
</pre>
<blockquote type="cite">
<pre wrap="">In the db.daily ? Because it's not resetting in SQL.
</pre>
</blockquote>
<pre wrap=""><!---->
Yes, the counter module doesn't say it's using SQL.
</pre>
<blockquote type="cite">
<pre wrap="">Also what is the db.daily ? How do you read that file ?
</pre>
</blockquote>
<pre wrap=""><!---->
You don't. Its used by the counter module to keep it's count.
</pre>
<blockquote type="cite">
<pre wrap="">What I'm trying to achieve here is to get mysql to reset the counters
its doing, and then start a new row if possible.
Within the table radacct. AcctInputOctets AcctOutputOctets.
Is it possible to do this ?
Does the counter actually do that ?
</pre>
</blockquote>
<pre wrap=""><!---->
You want sqlcounter.
Alan DeKok.
-
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>
-
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>