RES: How to use radacct in two different databases
p.mayers at imperial.ac.uk
Wed Nov 23 21:56:00 CET 2011
On 11/23/2011 08:42 PM, Nataniel Klug wrote:
> I think I did not made my self clear. I need to store radacct data
> on MySQL and all the rest in PostgreSQL. I was reading about multiple
Ok, that's clear.
> instances of SQL (for redundant purposes) and I think it can be used. So in
> my sites-enable/client file I would have something like "sql" on
> Authorization section (and this instance would be a PostgreSQL) and a sql1
> on Accounting section (this would be a MySQL). In sqlippool.conf I can set
> it to run over "sql" instance (using PostgreSQL).
> Is this possible? I need to acces just the data on radacct over
Yes. The config you've described should work. sqlippool will talk to
your postgres install, and accounting will go into your mysql install.
More information about the Freeradius-Users