<!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">
Maybe my way of doing things is not the right one, but I had to
solve the same issue a while ago. What I did is I changed the
simple update in sql.conf to a stored procedure call, and in my
stored proc, I update the radacct entry, but I also insert another
record into a "log" table. That way I can do my stats easily.<br>
<br>
I am sure there is an easiest way of doing it.<br>
<br>
On 11-12-02 10:22 AM, Hitesh Vinzoda wrote:
<blockquote
cite="mid:1322839355.66760.YahooMailNeo@web95214.mail.in2.yahoo.com"
type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255,
255); font-family: verdana,helvetica,sans-serif; font-size:
10pt;">
<div><span>Hi,</span></div>
<div><span><br>
</span></div>
<div><span>We want to have accounting records created every 3
hours in case the users are not disconnected to create
daily/weekly/monthly report.</span></div>
<div><span><br>
</span></div>
<div><span>I have gone through all the steps involved till
modifying the accounting queries in sql.conf, i realized
that my sql.conf is different from one listed at </span><a
moz-do-not-send="true"
href="http://freeradius.org/radiusd/raddb/sql.conf">http://freeradius.org/radiusd/raddb/sql.conf</a></div>
<div><br>
</div>
<div>Now i stalled that whether to modify. I am using FR 2.1.10.</div>
<div><br>
</div>
<div>LNS is setup to send periodic updates every 3 hours and FR
is updating the records but the acctstarttime is unchanged and
acctstoptime is set to "null" but i can see that the
acctinoctets and output octets are updated. We need to have
separate record created in MYSQL radacct table once received
update from the LNS.</div>
<div><br>
</div>
<div>Any help on this would be appreciated.</div>
<div><br>
</div>
<div>Thanks in advance</div>
<div> </div>
<div><span style="font-family: garamond,'new york',times,serif;"><font
size="3"><span style="color: rgb(0, 0, 255); font-weight:
bold;">Hitesh Vinzoda</span><br>
<span style="font-weight: bold; color: rgb(0, 0, 0);">Network
Administrator</span><br style="font-weight: bold; color:
rgb(0, 0, 0);">
<span style="font-weight: bold; color: rgb(0, 0, 0);">+91-9924117399<br>
<span style="color: rgb(0, 0, 255); text-decoration:
underline;"><a class="moz-txt-link-abbreviated" href="http://www.vinzoda.in">www.vinzoda.in</a></span><br>
</span><br>
"There are 10 types of people in this world.<br>
One who can understand binary and other's can't."</font><br>
<br>
<br>
</span></div>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
-
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>
<br>
<br>
<pre class="moz-signature" cols="72">--
Francois Gaudreault, ing. jr
<a class="moz-txt-link-abbreviated" href="mailto:fgaudreault@inverse.ca">fgaudreault@inverse.ca</a> :: +1.514.447.4918 (x130) :: <a class="moz-txt-link-abbreviated" href="http://www.inverse.ca">www.inverse.ca</a>
Inverse inc. :: Leaders behind SOGo (<a class="moz-txt-link-abbreviated" href="http://www.sogo.nu">www.sogo.nu</a>) and PacketFence (<a class="moz-txt-link-abbreviated" href="http://www.packetfence.org">www.packetfence.org</a>) </pre>
</body>
</html>