Radacct update at 3 hours

[Hitesh Vinzoda]

Hi,

We want to have accounting records created every 3 hours in case the users are not disconnected to create daily/weekly/monthly report.

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 http://freeradius.org/radiusd/raddb/sql.conf

Now i stalled that whether to modify. I am using FR 2.1.10.

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.

Any help on this would be appreciated.

Thanks in advance
 
Hitesh Vinzoda
Network Administrator
+91-9924117399
www.vinzoda.in

"There are 10 types of people in this world.
One who can understand binary and other's can't."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111202/62e54e93/attachment.html>