Phil, Thank you, I will test the configuration and I will make a try in real world with that. Hope it work! Regards, Nataniel Klug --
-----Mensagem original----- De: freeradius-users-bounces+listas.nata=cnett.com.br@lists.freeradius.org [mailto:freeradius-users- bounces+listas.nata=cnett.com.br@lists.freeradius.org] Em nome de Phil Mayers Enviada em: quarta-feira, 23 de novembro de 2011 17:56 Para: freeradius-users@lists.freeradius.org Assunto: Re: RES: How to use radacct in two different databases
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 MySQL.
Yes. The config you've described should work. sqlippool will talk to your postgres install, and accounting will go into your mysql install. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html