Radacct update at 3 hours

[Hitesh Vinzoda]

Hi,

Thanks for your prompt response. Could you please let me know where to include in sql.conf file to call the procedures.

P.S. : we are using freeradius 2.1.10

Thanks
 
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."





________________________________
 From: Francois Gaudreault <fgaudreault at inverse.ca>
To: freeradius-users at lists.freeradius.org 
Sent: Friday, 2 December 2011 9:32 PM
Subject: Re: Radacct update at 3 hours
 

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.

I am sure there is an easiest way of doing it.

On 11-12-02 10:22 AM, Hitesh Vinzoda wrote: 
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."
>
>
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html 


-- 
Francois Gaudreault, ing. jr fgaudreault at inverse.ca ::  +1.514.447.4918 (x130) :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) 
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111202/184f3929/attachment.html>