Using multiple databases on the same freeRadius instance

[Gabriel Marais]

On 2017/02/14 10:26 AM, Pshem Kowalczyk wrote:
> 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
> }

i left the initial config in place.
>
> sql sql_second_database {
>   driver = "..."
>   .... #rest of the db config
> }

i then created a new config file with the second db connection details 
and included the file in radiusd.conf

from the radius debug, i can see it is loading the second config file:-
Wed Feb 15 14:00:18 2017 : Debug: including configuration file 
/etc/freeradius/sql_admindb.conf

This is the contents of the file:-

sql_admin_db {
         database = "mysql"
         driver = "rlm_sql_${database}"
         server = "localhost"
         login = "radius"
         password = "xxx"
         radius_db = "xxx_adminportal"
         # Print all SQL statements when in debug mode (-x)
         sqltrace = no
         sqltracefile = ${logdir}/sqltrace.sql
         num_sql_socks = ${thread[pool].max_servers}
         connect_failure_retry_delay = 60
         lifetime = 0
         max_queries = 0
}

Debug output shows it loads the initial sql config and makes the 
connections to the db:-
Wed Feb 15 14:00:18 2017 : Debug:  Module: Linked to module rlm_sql
Wed Feb 15 14:00:18 2017 : Debug:  Module: Instantiating module "sql" 
from file /etc/freeradius/sql.conf
Wed Feb 15 14:00:18 2017 : Debug:   sql {
Wed Feb 15 14:00:18 2017 : Debug:       driver = "rlm_sql_mysql"
Wed Feb 15 14:00:18 2017 : Debug:       server = "localhost"
Wed Feb 15 14:00:18 2017 : Debug:       port = ""
Wed Feb 15 14:00:18 2017 : Debug:       login = "radius"
Wed Feb 15 14:00:18 2017 : Debug:       password = "xxx"
Wed Feb 15 14:00:18 2017 : Debug:       radius_db = "radius"

Wed Feb 15 14:00:18 2017 : Info: rlm_sql (sql): Driver rlm_sql_mysql 
(module rlm_sql_mysql) loaded and linked
Wed Feb 15 14:00:18 2017 : Info: rlm_sql (sql): Attempting to connect to 
radius at localhost:/radius
Wed Feb 15 14:00:18 2017 : Debug: rlm_sql (sql): starting 0
Wed Feb 15 14:00:18 2017 : Info: rlm_sql (sql): Attempting to connect 
rlm_sql_mysql #0
Wed Feb 15 14:00:18 2017 : Info: rlm_sql_mysql: Starting connect to 
MySQL server for #0
Wed Feb 15 14:00:18 2017 : Info: rlm_sql (sql): Connected new DB handle, #0


However, no connections are made or no reference is made to the second 
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 .... }

I am using xlat statements in the proxy areas of the config where i need 
to call and insert the custom attributes.


I'm not sure why the db connections are not made to the second db...

>
> 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
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

-- 




Regards

Gabriel Marais

Office: +27 861 466 546 x 7001
Mobile: +27 83 663 2222
Mail: gabriel.j.marais at gmail.com

Unit 11, Ground Floor, Berkley Office Park
Cnr Bauhinia & Witch Hazel Str,
Highveld, Centurion, South-Africa
0157

PO Box 15846, Lyttelton, South Africa, 0140