<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div><span>Hi,</span></div><div><span><br></span></div><div><span>Thanks for your prompt response. Could you please let me know where to include in sql.conf file to call the procedures.</span></div><div><span><br></span></div><div><span>P.S. : we are using freeradius 2.1.10</span></div><div><span><br></span></div><div><span>Thanks</span></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;">www.vinzoda.in</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><br></div> <div style="font-size: 10pt; font-family: verdana, helvetica, sans-serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Francois Gaudreault <fgaudreault@inverse.ca><br> <b><span style="font-weight: bold;">To:</span></b> freeradius-users@lists.freeradius.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 2 December 2011 9:32 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Radacct update at 3 hours<br> </font> <br><div id="yiv737181396">
<div>
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 type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 10pt; font-family: verdana, helvetica, sans-serif; ">
<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 rel="nofollow" target="_blank" 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, 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 rel="nofollow" class="yiv737181396moz-txt-link-abbreviated" target="_blank" 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><fieldset class="yiv737181396mimeAttachmentHeader"></fieldset>
-
List info/subscribe/unsubscribe? See <a rel="nofollow" class="yiv737181396moz-txt-link-freetext" target="_blank" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<br>
<br>
<pre class="yiv737181396moz-signature">--
Francois Gaudreault, ing. jr
<a rel="nofollow" class="yiv737181396moz-txt-link-abbreviated" ymailto="mailto:fgaudreault@inverse.ca" target="_blank" href="mailto:fgaudreault@inverse.ca">fgaudreault@inverse.ca</a> :: +1.514.447.4918 (x130) :: <a rel="nofollow" class="yiv737181396moz-txt-link-abbreviated" target="_blank" href="http://www.inverse.ca">www.inverse.ca</a>
Inverse inc. :: Leaders behind SOGo (<a rel="nofollow" class="yiv737181396moz-txt-link-abbreviated" target="_blank" href="http://www.sogo.nu">www.sogo.nu</a>) and PacketFence (<a rel="nofollow" class="yiv737181396moz-txt-link-abbreviated" target="_blank" href="http://www.packetfence.org">www.packetfence.org</a>) </pre>
</div>
</div><br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br><br><br> </div> </div> </div></body></html>