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 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. --
-----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 15:47 Para: freeradius-users@lists.freeradius.org Assunto: Re: How to use radacct in two different databases
On 11/23/2011 06:04 PM, Nataniel Klug wrote:
Hello all,
I am having a problem. The problem is I was trying to use MySQL and SQLIPPOOL but I had many problems with IP allocation and release so I choose to try PostgreSQL and it worked really fine in every aspect. The problem is: I use a software made by a third part company that can only read MySQL tables (they use some kind of a socket to connect to database) and I need to measure my clients usage and show it to the clients so they have a web PHP/Java page where my client can see his usage.
So, as I am using PostgreSQL this become impossible so, is there any way to use PostgreSQL for authentication and MySQL for accounting? Is this possible?
IP allocation requires that the database is accessed both during authentication and accounting usually. So no - it's probably not possible to do this. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html