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? -- Descrição: 111027-nata_at_cnett
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.
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
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.
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
On Thu, Nov 24, 2011 at 1:04 AM, Nataniel Klug <listas.nata@cnett.com.br> wrote:
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.
The real question is what problems are you actually having, and why. If you use innodb storage engine (the default since mysql-5.5) sqlippool should work just fine, function-wise. An exception is if your system is really, really, busy (think over several hundred auths/s), where you'd need ndbcluster engine plus a custom sqlippol query.
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?
As Phil have answered, yes, you can. For completeness, sqlippool db is separate from auth db, so if your problem is ONLY sqlippool and you want to use postgress for that, you can just use postgresql sql instance for sqlippool while still using mysql sql instance for auth and acct. -- Fajar
participants (3)
-
Fajar A. Nugraha -
Nataniel Klug -
Phil Mayers