free time

Fajar A. Nugraha list at fajar.net
Sun Mar 10 09:57:20 CET 2013


On Sun, Mar 10, 2013 at 2:12 PM, Jed Gainer <jedgainer at gmail.com> wrote:
> Why use a different DB?

Different table is also fine, really. However in FR terms when you use
something different (e.g. different query, table, or database), you
configure it as separate sql instances.

Assuming you create your own admin panel, or can custimize it, you can
do something like this:
- one radacct table to store "normal" accounting entries
- one raddcct_free (or whatever) table to store accounting records in
"free" times.

Your admin panel can then access both records by executing queries on
both table, and use UNION (or SUM, depending on the query) to join the
results together. It should be much more resource-efficient compared
to using complex WHERE queries.

-- 
Fajar


More information about the Freeradius-Users mailing list