free time

Fajar A. Nugraha list at fajar.net
Sun Mar 10 01:28:23 CET 2013


On Sun, Mar 10, 2013 at 8:23 AM, Jed Gainer <jedgainer at gmail.com> wrote:
> I would still like to be able to see what they use via my admin panel I just
> want FR to ignore it.

Then use different database for it. Something like

if (time isnt between 2am and 5am){
        sql-for-normal-usage
}
else {
        sql-for-your-admin-panel
}

As usual, do lots of testing. On first glance, your sql query looks
fine when you're only dealing with small number of accounting records,
but would REALLY suck if you have lots of it (say, 10 million records
in radacct).

-- 
Fajar


More information about the Freeradius-Users mailing list