Interim-Updates

[David Roze]

Thanks Peter, really appreciate it
I will add the links to the wiki on the pages as per your suggestion.
However, I wouldn't add them to the wiki as that's only tricks and tips as
you're mentionning, and they're not really part of the development.
It needs to be kept separated for maintenance and bug fixes

Thanks,
David

-----Original Message-----
From: Peter Nixon [mailto:listuser at peternixon.net] 
Sent: 17 July 2007 23:11
To: FreeRadius users mailing list; David Roze
Subject: Re: Interim-Updates

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-Octe
ts_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/