Hi Paul -
On Tue, 28 Sep 1999, Paul van der Zwan wrote:
> I have been asked to find a way to report the number of active ports
> in a configurable timestep.
> Something like a report for all hours or all 5 min periods showing
> the max number of active ports in that interval.
> They want it generated at any time/interval..
> How would I best handle this ?? At the moment Radiator is only logging
> accounting records to a standard detail file ( 70 MB per day and expected to
> grow a factor of 10 in the coming months) or should I switch to SQL accounting.
> (Anybody handling hundreds of megabytes of accounting date / day this way ?? )
> Any suggestions ?? I have some perl code to parse detail files but I doubt
> it would scale to the required sizes....
My suggestion here would be to set up a SessionDatabase in SQL and then just
write a little script to query it every 5 minutes and store the data for later
analysis. You could even have a look at the radwho.cgi script for inspiration.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
