Interim-Updates

[Peter Nixon]

On Tue 17 Jul 2007, David Roze wrote:
> Hi Peter and Stephan,
>
> I will update the page when I get a chance. It isn't the best way to
> proceed, you're right...
> One thing though, there's confusing between 2 pages with 2 different
> problems:
>
> Support for Gigawords in Mysql: I'm not using stored procedures, but
> adding an extra field for the Gigawords value. This will be changed with
> your solution.

Great. Thats the main thing I wanted to see fixed.

> Daily accounting: This gives the ability to create a new record everytime
> an interim-update is sent so people can check accounting more frequently
> and do not need to wait the session disconnects. Previous values need to
> be taken off the new received value to keep total accounting accurate
> (that's for Hugh's comment :)
> I use a stored procedure and I don't think I have another option to
> achieve this !??

Yes. I did read through this and see that you were doing something else also. 
I think you should be able to do it with a sub select in Postgresql, and 
AFAIK MySQL recently added support for them also. I could be wrong though, 
and I have nothing against stored procedures. (I use them extensively myself 
on postgres)

I think you solution is usefull, but I would like to see you explain that we 
consider the lack of MySQL Gigaword support in FreeRADIUS < 1.1.7 to be a 
bug which has been fixed :-)

You may even wish to link to:

http://wiki.freeradius.org/FAQ#Why_do_Acct-Input-Octets_and_Acct-Output-Octets_wrap_at_4_GB

I realise that you have your own site and content is a hard thing to come by, 
but if you like we would love to have any tips or tricks like this in the 
official FreeRADIUS wiki. Failing that, please feel free to add links to 
your articles at appropriate places in the wiki..

Regards
-- 

Peter Nixon
http://peternixon.net/