How to use radacct in two different databases

Phil Mayers p.mayers at
Wed Nov 23 19:46:34 CET 2011

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.

More information about the Freeradius-Users mailing list