Using multiple databases on the same freeRadius instance

[Pshem Kowalczyk]

Hi,

The quickest way is to create two named instances of the sql module like
this:

sql sql_first_database {
  driver = "..."
  .... #rest of the db config
}

sql sql_second_database {
  driver = "..."
  .... #rest of the db config
}

and then, instead of calling 'sql' module call your own ones:

sql_first_database
sql_second_database

you can also use them in xlat:

%{sql_first_database:INSERT INTO .... }

kind regards
Pshem




On Tue, 14 Feb 2017 at 20:09 Gabriel Marais <gabriel.j.marais at gmail.com>
wrote:

> Hi Guys,
>
> I am wondering if there are any way to use two different databases
> within the same freeRadius instance?
>
> Currently, I am using the default MySQL schema for AAA. I am inserting
> additional attributes in the pre-proxy configuration of my site. The
> attribute information comes from the same database. This works perfectly.
>
> I now have a site where I need to do the same but the additional
> attribute information needs to come from a different database (existing
> database on the client side), other than the AAA database.
>
>
> Is there a way to do this?
>
>
> Regards
>
> Gabriel
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html