Radacct update at 3 hours

[Francois Gaudreault]

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)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111202/c71c58ad/attachment.html>