<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>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 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;">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></div></div></body></html>